From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Hongyi Zhao Newsgroups: gmane.emacs.orgmode,gmane.emacs.help Subject: Re: Microsoft Excel spreadsheet editing directly from within emacs. Date: Tue, 29 Dec 2020 12:53:58 +0800 Message-ID: References: <87v9clnttt.fsf@robertthorpeconsulting.com> Mime-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="17066"; mail-complaints-to="usenet@ciao.gmane.io" Cc: help-gnu-emacs , Org-mode To: Robert Thorpe Original-X-From: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane-mx.org@gnu.org Tue Dec 29 05:54:37 2020 Return-path: Envelope-to: geo-emacs-orgmode@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 1ku71o-0004Lc-KE for geo-emacs-orgmode@m.gmane-mx.org; Tue, 29 Dec 2020 05:54:36 +0100 Original-Received: from localhost ([::1]:48126 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1ku71n-0005L3-LR for geo-emacs-orgmode@m.gmane-mx.org; Mon, 28 Dec 2020 23:54:35 -0500 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]:41414) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ku71R-0005KR-IE; Mon, 28 Dec 2020 23:54:13 -0500 Original-Received: from mail-yb1-xb30.google.com ([2607:f8b0:4864:20::b30]:32871) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1ku71P-0001sw-UA; Mon, 28 Dec 2020 23:54:13 -0500 Original-Received: by mail-yb1-xb30.google.com with SMTP id o144so11453077ybc.0; Mon, 28 Dec 2020 20:54:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=4bxi4yidbbmVATCvIumTvMV/Tqu5zpvSo+fmv8TTCiI=; b=HsQAMNOlgw6hNQaliPPnWSeeP5taINe6nsCSdNJ33DxL9iOA3zheLN3viNqqcMKq52 NZqxLM1eXDnli0Hrm+exBKEO/lXOjb5Jmkmv9cmaOqf1NoNu28SD5wmU4rjlB69Ap1HP rlACSFxf3oyg4r3Wmlh8wFcdw1ioR6fLJVu6FX8Ds8fso1/E1ThsJbASXkBX12bXhI7P /wHX6A9Z9EGa1iR9oZ/E5U9CVD3JtvrCPi/RytaPcYDMpV48rf6KUgtHU1jcjv9gV36p 9Rv8eOER249hgpzzBTwVTi9wyRAdfY7qqdL6bImULq5BB6Z27y2NREVSBoxKM+LAr1ZC O07Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=4bxi4yidbbmVATCvIumTvMV/Tqu5zpvSo+fmv8TTCiI=; b=T3FGNFxauYv3AD2Jlc56HSMhHltl0oQPaf7EGJK7NXE5Cj0/sBD02BOZOW6wvHHsz7 TzNt6/930Af7JEXG62+1TctXiPMXIQFp60Jn5WA4O49lJKbT0lD9BUkABDRNs2Wev05h 8rexyPWwui8YK+ejBf1uolGfxTYqNCzhJxdWb+AkBFmDu8rOexh13LopM8W3Ahek9G66 OWcE8RNR2rdMvC0f/1am51xFOvnxYQJjzBoMhmhG6C4ff6LrYTQCVqTeSTR6Ox9KxChq 1cDJfVMoXtkaZzRwjBfl88RURoPHF9eMxSs94GdlFJRAkqgqoRIpSNmTZzI+xLN/kUFs 1TiA== X-Gm-Message-State: AOAM5309IJP0/8KZhFEXrNuXnDOq+6YRu8z1NuFJDJEbLJ2i/N5PL+2M E9hAoQ7Z9Q5TS7YEB3SSTel9Lt/1iqCosaM1zsf240VnxDCyAQkM X-Google-Smtp-Source: ABdhPJySbD5jLlUyXa8Zw/uVfqHbVayLmmYeBBs85A2sFCv9mQ/f8vj4a1GkCNfmgYyCbv7Y/O/bjlOshhcwC+0+rhI= X-Received: by 2002:a25:1e86:: with SMTP id e128mr11952180ybe.326.1609217649731; Mon, 28 Dec 2020 20:54:09 -0800 (PST) In-Reply-To: <87v9clnttt.fsf@robertthorpeconsulting.com> Received-SPF: pass client-ip=2607:f8b0:4864:20::b30; envelope-from=hongyi.zhao@gmail.com; helo=mail-yb1-xb30.google.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=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+geo-emacs-orgmode=m.gmane-mx.org@gnu.org Original-Sender: "Emacs-orgmode" Xref: news.gmane.io gmane.emacs.orgmode:134240 gmane.emacs.help:126889 Archived-At: On Tue, Dec 29, 2020 at 12:02 PM Robert Thorpe wrote: > > Hongyi Zhao writes: > > > Is it possible for me to edit Microsoft Excel spreadsheet directly > > from within emacs, especially utilizing the powerful capabilities of > > orgmode? > > People here have suggested lots of things. > > It depends on the application. Jean Louis is correct to say that Emacs > spreadsheets are not as fully featured as things like Libreoffice. > > Plotting charts is a problem. So is sending spreadsheets to other > people in a way that they can read the file. > > In my past jobs I've used spreadsheets a lot. I've found that Emacs is > very useful for the beginning steps. If you have data in > comma-separated-value format or tab-separated-value format then you can > quickly check it over in Emacs and do cleaning-up changes. But then > I've found it best to take that CSV/TSV output and put it into a full > spreadsheet package, to generate final output. That is, if you need > charts and distribution to others. >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. Regards -- Assoc. Prof. Hongyi Zhao Theory and Simulation of Materials Hebei Polytechnic University of Science and Technology engineering NO. 552 North Gangtie Road, Xingtai, China