From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id ovnCFZhn+F/JAwAA0tVLHw (envelope-from ) for ; Fri, 08 Jan 2021 14:09:28 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id CB0LEZhn+F+EagAAB5/wlQ (envelope-from ) for ; Fri, 08 Jan 2021 14:09:28 +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 6FB719404E1 for ; Fri, 8 Jan 2021 14:09:27 +0000 (UTC) Received: from localhost ([::1]:35382 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kxsSE-0008Ta-AW for larch@yhetil.org; Fri, 08 Jan 2021 09:09:26 -0500 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 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 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 From: "H. Dieter Wilhelm" To: Hongyi Zhao Subject: Re: Microsoft Excel spreadsheet editing directly from within emacs. References: <87v9clnttt.fsf@robertthorpeconsulting.com> Date: Fri, 08 Jan 2021 15:07:15 +0100 In-Reply-To: (Hongyi Zhao's message of "Tue, 29 Dec 2020 22:47:55 +0800") Message-ID: <861revy12k.fsf@duenenhof-wilhelm.de> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain 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: 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: , Cc: help-gnu-emacs , Org-mode Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN X-Migadu-Spam-Score: -2.35 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: 6FB719404E1 X-Spam-Score: -2.35 X-Migadu-Scanner: scn0.migadu.com X-TUID: pJfDc7EpTL6N 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