From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id 8NVmI8L56l+fSwAA0tVLHw (envelope-from ) for ; Tue, 29 Dec 2020 09:41:22 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0 with LMTPS id GElIH8L56l8qLAAA1q6Kng (envelope-from ) for ; Tue, 29 Dec 2020 09:41:22 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id E38299403A2 for ; Tue, 29 Dec 2020 09:41:21 +0000 (UTC) Received: from localhost ([::1]:33948 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kuBVH-0003M1-Dr for larch@yhetil.org; Tue, 29 Dec 2020 04:41:19 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:52858) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kuBUY-0003Ky-Cd for emacs-orgmode@gnu.org; Tue, 29 Dec 2020 04:40:34 -0500 Received: from stw1.rcdrun.com ([217.170.207.13]:57823) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kuBUV-0006uS-Jr for emacs-orgmode@gnu.org; Tue, 29 Dec 2020 04:40:33 -0500 Received: from localhost ([::ffff:41.210.145.189]) (AUTH: PLAIN securesender, TLS: TLS1.2,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 000000000029543F.000000005FEAF98C.000005B1; Tue, 29 Dec 2020 02:40:27 -0700 Date: Tue, 29 Dec 2020 10:32:01 +0300 From: Jean Louis To: emacs-orgmode@gnu.org Subject: Re: Microsoft Excel spreadsheet editing directly from within emacs. Message-ID: Mail-Followup-To: emacs-orgmode@gnu.org References: <87k0t11vzi.fsf@mat.ucm.es> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <87k0t11vzi.fsf@mat.ucm.es> User-Agent: Mutt/2.0 (3d08634) (2020-11-07) Received-SPF: pass client-ip=217.170.207.13; envelope-from=bugs@gnu.support; helo=stw1.rcdrun.com X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN X-Migadu-Spam-Score: -2.33 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Queue-Id: E38299403A2 X-Spam-Score: -2.33 X-Migadu-Scanner: scn0.migadu.com X-TUID: t0oHNHOdaSoI * Uwe Brauer [2020-12-29 00:07]: > >>> "JL" == Jean Louis writes: > > > * Daniel Martín [2020-12-28 19:22]: > >> Hongyi Zhao 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.