Re: Microsoft Excel spreadsheet editing directly from within emacs.

[Jean Louis <bugs@gnu.support>]

* 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.