From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id OFOgLnS+61+GMwAA0tVLHw (envelope-from ) for ; Tue, 29 Dec 2020 23:40:36 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0 with LMTPS id yNC0KnS+619HGQAA1q6Kng (envelope-from ) for ; Tue, 29 Dec 2020 23:40:36 +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 44F4B940484 for ; Tue, 29 Dec 2020 23:40:36 +0000 (UTC) Received: from localhost ([::1]:60662 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kuObS-0003ky-LX for larch@yhetil.org; Tue, 29 Dec 2020 18:40:34 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:58148) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kuOad-0003jQ-MO; Tue, 29 Dec 2020 18:39:43 -0500 Received: from mail-lf1-x136.google.com ([2a00:1450:4864:20::136]:46704) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1kuOaa-00082x-8v; Tue, 29 Dec 2020 18:39:43 -0500 Received: by mail-lf1-x136.google.com with SMTP id y19so34054802lfa.13; Tue, 29 Dec 2020 15:39:39 -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=hmSccRvE1jC7WaQt9qpJjqlach/izz5e7lizxErBN88=; b=FoZEf9rN7Os5t1AsfBdnUg1O3jrgSx1lznJfCWLsQ8bXS8JVgkQiRlGdFBUsk7C/js LHIplS8Mj9+x0RXnDCmzq2tk13STSkp6GZTH7eumYMbZEER92ERPo2iFUYJWyyjp/SBm 8ycHG5bNczMhJ2b1hmjVONWl9AcKgm+GCMb9buGRMs694dBmWmM2x8sBqGzTQMbaXRvm Rw9NMdLmXFvHZV911RVV+mra9l7L5WQfG7M+MmBsUrtHTeRy9qOjVduaxgX4TQMSTGT9 c/2u8FXVhKSdUwqQ3ZzISu/o+ZzlnV7avJeXp6TanHavTuSyiGskGweFp9+jCTmtd2DQ 4dLQ== 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=hmSccRvE1jC7WaQt9qpJjqlach/izz5e7lizxErBN88=; b=gVqAY1GfUPr28HM9icOPwAp4CPewPV79fJ5tbZPEA1md7VoKJkocPXq8v1F0dsQbWa aNwm/ZmzGYivAj+O0AAu/f/Ezq55YIW14+7uRE0E2cRFR7oPU8DVOrqFWp+gPeuK6ils PcurrK7UpNiSaBLV95Sw0Lmyifr+IFlJeh5VKvwPN4+hpHH1jUhpLGdHW6xjL6Ytiotd St49cn9+plMb6UdW3mZe9E4O6NcseQs99HE5l7nCNXkm9wE09XpOHSBgWFeWpPs09CBO ZvaHXdpuWLKLWNbYVZhPr+i4D/M0zc3OFPCpP6hk5ldpmLrcVt6Ca5+LBa6Wa0gffZgb TZ4Q== X-Gm-Message-State: AOAM5312y1BLNlZ7yfOFX7tl8tGgGx7RgBQ1QL2YOvr/uI5ofSxdlREo rnJDSls8J0VMEP1R51+VbU74Az5FkcyHlaAB3pY= X-Google-Smtp-Source: ABdhPJxzje7OL+cP/d+HdxMyazQgfKe/MYsLldQmDgiqp1yLV6TpXFBMINGOahkfUYxlnXjxijglF6yJdPYqrHsrOZg= X-Received: by 2002:a05:651c:118a:: with SMTP id w10mr21140745ljo.13.1609285177685; Tue, 29 Dec 2020 15:39:37 -0800 (PST) MIME-Version: 1.0 References: <87a6tw4hvy.fsf@robertthorpeconsulting.com> In-Reply-To: <87a6tw4hvy.fsf@robertthorpeconsulting.com> From: Hongyi Zhao Date: Wed, 30 Dec 2020 07:39:26 +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=2a00:1450:4864:20::136; envelope-from=hongyi.zhao@gmail.com; helo=mail-lf1-x136.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: -1.23 Authentication-Results: aspmx1.migadu.com; dkim=fail (headers rsa verify failed) header.d=gmail.com header.s=20161025 header.b=FoZEf9rN; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=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: 44F4B940484 X-Spam-Score: -1.23 X-Migadu-Scanner: scn0.migadu.com X-TUID: IUZ2CNmW19CP On Wed, Dec 30, 2020 at 1:55 AM Robert Thorpe wrote: > > 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. > > Who creates the spreadsheet first? Is it you or someone else? From/by others, in most instances. > > If it's you then things can be quite simple. You can create a > comma-separated or tab-separated file in Emacs or something else. Do you mean export the org table with CSV/TSV formats? I noticed that the default orgmode table column separator is |. > You can then import that file into Libreoffice and then save it as a .XLSX > or .XLS file. You can make a script in Libreoffice to do the import > just the way you want it. Sounds wonderful. Is there such an example script? > > Things are more difficult if you are given a .XLSX or .DOCX file by > someone else. In that case you have to use Libreoffice or something > like it straight away. You also have to be very careful was re-saving > the file with changes because Libreoffice has some subtle > incompatabilities with MS Excel and MS Word. > > If you just want to add new sheets to existing spreadsheets that is not > too bad. The problem is changing values in existing sheets. You're absolutely right. BR, -- Assoc. Prof. Hongyi Zhao Theory and Simulation of Materials Hebei Polytechnic University of Science and Technology engineering NO. 552 North Gangtie Road, Xingtai, China