emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Jean Louis <bugs@gnu.support>
To: emacs-orgmode@gnu.org
Subject: Re: Microsoft Excel spreadsheet editing directly from within emacs.
Date: Tue, 29 Dec 2020 10:32:01 +0300	[thread overview]
Message-ID: <X+rbcXQ5ytFVpfnN@protected.rcdrun.com> (raw)
In-Reply-To: <87k0t11vzi.fsf@mat.ucm.es>

* Uwe Brauer <oub@mat.ucm.es> [2020-12-29 00:07]:
> >>> "JL" == Jean Louis <bugs@gnu.support> writes:
> 
> > * Daniel Martín <mardani29@yahoo.es> [2020-12-28 19:22]:
> >> Hongyi Zhao <hongyi.zhao@gmail.com> writes:
> >> 
> >> > Is it possible for me to edit Microsoft Excel spreadsheet directly
> >> > from within emacs, especially utilizing the powerful capabilities of
> >> > orgmode?
> >> 
> >> Not directly, but you could first save the Excel spreadsheet as CSV and
> >> then import it into Org-Mode using M-x org-table-import.  I haven't
> >> checked how this works in practice, so YMMV.
> 
> > It performs poorly and takes very long time. It is limited unless
> > limits are raised. And its usability on the scale from 0 to 10 is 1.
> 
> Not for me. What sort of files were you converting?

Directory of businesses with their names and addresses in CSV
format. It is not the only file that would have those problems. One
way to go could be not to use Org mode, but to use org-table-importa
as that is then much faster, and then to turn on org mode again.

I have just said my user experience, I am not using org-table-import
as I find it hackish function low on the scale of usability.

When importing CSV documents I usually import it into database by
using the built in PostgreSQL features or Emacs Lisp parsing of
CSV.

Org tables I used mostly for transactions but not any more as it does
not scale up with many people, it becomes hell and it would be tedious
or impossible to teach any staff on distance on how to use it. There
is no collaboration.

PostgreSQL offers collaboration feature with its server model right
out of the box and staff member on distance can enter their
transactions straight. So I replaced Org mode tables with database
backed. Right tool for right purpose.



  reply	other threads:[~2020-12-29  9:41 UTC|newest]

Thread overview: 30+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2020-12-28 15:18 Microsoft Excel spreadsheet editing directly from within emacs Hongyi Zhao
2020-12-28 16:21 ` Daniel Martín
2020-12-28 16:51   ` Stefan Monnier
2020-12-28 17:39   ` Filipp Gunbin
2020-12-28 19:47   ` Jean Louis
2020-12-28 21:06     ` Uwe Brauer
2020-12-29  7:32       ` Jean Louis [this message]
2020-12-29 15:36         ` Uwe Brauer
2020-12-28 19:36 ` Jean Louis
2020-12-28 19:55   ` Daniele Nicolodi
2020-12-28 20:37     ` Jean Louis
2020-12-29 11:51       ` Stefan Nobis
2020-12-29 13:41         ` Eric S Fraga
2020-12-30 22:19         ` Jean Louis
2020-12-31 12:17           ` Stefan Nobis
2021-01-02  0:48             ` Samuel Wales
2020-12-29  0:06   ` andres.ramirez
2020-12-29  2:29     ` Carson Chittom
2020-12-28 20:12 ` Uwe Brauer
2020-12-29 10:07   ` Eric S Fraga
2020-12-29  4:02 ` Robert Thorpe
2020-12-29  4:53   ` Hongyi Zhao
2020-12-29  7:49     ` Jean Louis
2020-12-29 14:47       ` Hongyi Zhao
2020-12-29 14:59         ` Greg Minshall
2020-12-29 15:34         ` Jean Louis
2020-12-29 17:54         ` Robert Thorpe
2020-12-29 23:39           ` Hongyi Zhao
2020-12-30  3:06             ` Robert Thorpe
2021-01-08 14:07         ` H. Dieter Wilhelm

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=X+rbcXQ5ytFVpfnN@protected.rcdrun.com \
    --to=bugs@gnu.support \
    --cc=emacs-orgmode@gnu.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).