From: "H. Dieter Wilhelm" <dieter@duenenhof-wilhelm.de>
To: Hongyi Zhao <hongyi.zhao@gmail.com>
Cc: help-gnu-emacs <help-gnu-emacs@gnu.org>,
Org-mode <emacs-orgmode@gnu.org>
Subject: Re: Microsoft Excel spreadsheet editing directly from within emacs.
Date: Fri, 08 Jan 2021 15:07:15 +0100 [thread overview]
Message-ID: <861revy12k.fsf@duenenhof-wilhelm.de> (raw)
In-Reply-To: <CAGP6PO+hyR93tC0bzFtYTbAX5q2iRsK8vG5W1W2EpAHeNhtmvg@mail.gmail.com> (Hongyi Zhao's message of "Tue, 29 Dec 2020 22:47:55 +0800")
Hongyi Zhao <hongyi.zhao@gmail.com> writes:
> On Tue, Dec 29, 2020 at 5:40 PM Jean Louis <bugs@gnu.support> wrote:
>>
>> * Hongyi Zhao <hongyi.zhao@gmail.com> [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
>> > <https://openpyxl.readthedocs.io>, 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
prev parent reply other threads:[~2021-01-08 14:09 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
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 [this message]
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=861revy12k.fsf@duenenhof-wilhelm.de \
--to=dieter@duenenhof-wilhelm.de \
--cc=emacs-orgmode@gnu.org \
--cc=help-gnu-emacs@gnu.org \
--cc=hongyi.zhao@gmail.com \
/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).