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 0IYoHJS26l9XQgAA0tVLHw (envelope-from ) for ; Tue, 29 Dec 2020 04:54:44 +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 SGQEGJS26l9zZwAAB5/wlQ (envelope-from ) for ; Tue, 29 Dec 2020 04:54:44 +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 DF3F594014B for ; Tue, 29 Dec 2020 04:54:43 +0000 (UTC) Received: from localhost ([::1]:48126 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1ku71t-0005L3-Mq for larch@yhetil.org; Mon, 28 Dec 2020 23:54:41 -0500 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 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 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) MIME-Version: 1.0 References: <87v9clnttt.fsf@robertthorpeconsulting.com> In-Reply-To: <87v9clnttt.fsf@robertthorpeconsulting.com> From: Hongyi Zhao Date: Tue, 29 Dec 2020 12:53:58 +0800 Message-ID: Subject: Re: Microsoft Excel spreadsheet editing directly from within emacs. To: Robert Thorpe Content-Type: text/plain; charset="UTF-8" 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: , 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: -3.03 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20161025 header.b=HsQAMNOl; dmarc=pass (policy=none) header.from=gmail.com; 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: DF3F594014B X-Spam-Score: -3.03 X-Migadu-Scanner: scn0.migadu.com X-TUID: u0MMKdEi920K 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