From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: "H. Dieter Wilhelm" Newsgroups: gmane.emacs.help,gmane.emacs.orgmode Subject: Re: Microsoft Excel spreadsheet editing directly from within emacs. Date: Fri, 08 Jan 2021 15:07:15 +0100 Message-ID: <861revy12k.fsf@duenenhof-wilhelm.de> References: <87v9clnttt.fsf@robertthorpeconsulting.com> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="24658"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) Cc: help-gnu-emacs , Org-mode To: Hongyi Zhao Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Fri Jan 08 15:08:43 2021 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kxsRV-0006Hu-68 for geh-help-gnu-emacs@m.gmane-mx.org; Fri, 08 Jan 2021 15:08:41 +0100 Original-Received: from localhost ([::1]:33776 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kxsRU-0007lm-3a for geh-help-gnu-emacs@m.gmane-mx.org; Fri, 08 Jan 2021 09:08:40 -0500 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]:52322) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kxsQI-0007kU-W6; Fri, 08 Jan 2021 09:07:27 -0500 Original-Received: from mout.kundenserver.de ([212.227.17.10]:38113) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kxsQB-0004vo-EA; Fri, 08 Jan 2021 09:07:26 -0500 Original-Received: from ping ([92.116.161.32]) by mrelayeu.kundenserver.de (mreue109 [212.227.15.183]) with ESMTPSA (Nemesis) id 1MTRIg-1kWHQe1kVw-00Ti7H; Fri, 08 Jan 2021 15:07:16 +0100 In-Reply-To: (Hongyi Zhao's message of "Tue, 29 Dec 2020 22:47:55 +0800") X-Provags-ID: V03:K1:7/mZ1dRQRdG7KnMHYPZW60CK7tK8kkR2HHSh38iB3xOm/mBEiJw 3pL7xmuhZzJFSdr7IeSy7HqtM505fylf9gwwxclmtZKdHUjwPGiT70khd/6m2Ix39H117R2 XtlrsIgmPTnITnUAFD21zx3PhVJWMYNdY9X4yB2TebBmJKZHBssymNtvGKHf3vfytxnwkLo no/qKM6+5Y7VZeLqomZMg== X-UI-Out-Filterresults: notjunk:1;V03:K0:ToOgHs04tBo=:3/+2gZxOpMuBx3NrIdaT2x EPfdyWrDTttFm56J7MUFy7u2QXzEdN6eUooZc3RA4HIKpB5Q5egKJpIN8CBbvClLZ+dZOQqwk jyk0vW2sm5j+aTiTtbzggpXQ0ticJ3PEnn6H9JBuDCKLKdJk/7yHLUGO++EzEAkrCtjbHtppl +3bqHdRyTlJEIf8Kas6/sVHmrqnLTMGQFgYnqqWDrptn8v3aUMQ0fp27qak8YXPmSbpUXdM3u kJlw5LtSbCBTyucnZtizRhf47Qz/CVKKmoLtDOPCHow7cIuTLpeugnHthOnoZeKzNi6Wi2hcl qPfPyvvALSdoO09EU9Kr+cFCupNo1uOEZavAe8dRjjljmHtHkdwQpHWqSgHvjthrqgaTiopyo qJvU8776hg3xwdHDTN6h4VBCIKPsYcx5IvDNEzl0U6q8bWCKMrk0/iCmpr7CPjNRM6cK4NzTQ 4DwVcPJLEw== Received-SPF: none client-ip=212.227.17.10; envelope-from=dieter@duenenhof-wilhelm.de; helo=mout.kundenserver.de 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, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_NONE=0.001, SPF_NONE=0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Original-Sender: "help-gnu-emacs" Xref: news.gmane.io gmane.emacs.help:127109 gmane.emacs.orgmode:134447 Archived-At: Hongyi Zhao writes: > On Tue, Dec 29, 2020 at 5:40 PM Jean Louis wrote: >> >> * Hongyi Zhao [2020-12-29 07:55]: >> > From this point of view, if we want to have both full-features and >> > powerful capabilities in manipulating spreadsheet, it seems that only >> > the python based programmatic tools/packages, say, openpyxl >> > , can meet the requirements >> > currently. >> >> What are you requirements? > > I use Linux as my working environment exclusively. So, I can't access > the native MS Office supplied for macOS/Windows. But I sometimes > really need to manipulate and process MS Office documents, especially > DOCX and XLSX files. Though there are some free and open source office > suites, e.g. LibreOffice, but none of them can completely compatible > with the MS Office. > > So, I want to find a way that can be used to programmatically complete > any possible work done by MS Office word/excel. For directly reading Excel sheets I highly recommend "readxl" from the R package bundle "tidyverse". https://r4ds.had.co.nz/ It's an investment though but it pays in the long run for serious data science. After processing you should be able to write data in an excel file with the "writexl" package. (Did not test it, never had the need to export into Excel. :-)) By the way, I'm mostly doing data processing in org-mode R source blocks. And I'm also converting data into org-mode tables but mostly small ones for latex table exports. And you can also do spreadsheet calculations with them https://orgmode.org/manual/The-Spreadsheet.html Here's a small example #+LATEX: \definecolor{VitescoYellow}{RGB}{242,229,0} #+LATEX: \rowcolors[]{1}{VitescoYellow!100}{VitescoYellow!5} #+caption: Required motor torque to reach src_R{N} rpm in src_R{T} s | *Cases* | *Torque* in Nmm | |------------+------------------| | Best case | 9.5 | | Worst case | 11.6 | #+TBLFM: @2$2='(org-sbe mintorque):: @3$2='(org-sbe maxtorque) (Above org table is reading results from named org source blocks.) If you really, really need to return data in MS formats you might have to run a virtual machine with Windows, not that I recommend that but live is ... Hope that is interesting Dieter -- Best wishes H. Dieter Wilhelm Zwingenberg, Germany