From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id YPgUH+5B61/uYgAA0tVLHw (envelope-from ) for ; Tue, 29 Dec 2020 14:49:18 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id CHDWGu5B61/dLwAAbx9fmQ (envelope-from ) for ; Tue, 29 Dec 2020 14:49:18 +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 E90CC9402C8 for ; Tue, 29 Dec 2020 14:49:16 +0000 (UTC) Received: from localhost ([::1]:49258 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kuGJH-0001np-MJ for larch@yhetil.org; Tue, 29 Dec 2020 09:49:15 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:50656) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kuGIG-0001lb-Fb; Tue, 29 Dec 2020 09:48:12 -0500 Received: from mail-lf1-x134.google.com ([2a00:1450:4864:20::134]:34834) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1kuGID-0004at-Jr; Tue, 29 Dec 2020 09:48:12 -0500 Received: by mail-lf1-x134.google.com with SMTP id h22so31353327lfu.2; Tue, 29 Dec 2020 06:48:08 -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; bh=4w7hPUIhDiodC6B67MpO49N1/0ifSvoovaUDdK23mgg=; b=bxXkqd9AjC1cstaxk/8zJIzm86eKsciOSpQjuA4ZrxNXDXSqN/3ubGLoPwCcrfgsFz 1iH+yyMIDdxoa8KlkoxRJ22FQNDTTdcZh1zszVuO6CJN0t+aFFG5YHaBNNYtpPeHe/TJ qQr+TAN2tuBNu3VJDPhuC7lnQ/Pg48Ku9REdETUAt7biMaOFrWrzOI4V0xFm/qPlotyl kDoSh3X51nWaIiXqu5FqppfMofaWejDoQM3RcfiX15vbzzzqJOw01jRrXEVp1XJpfyju ferLIC3U81srRbfiAYcX82er6w9Mpid+USxNqiNncYHcuP/9FvubjMgzX90ybIVqpoBj BQIg== 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; bh=4w7hPUIhDiodC6B67MpO49N1/0ifSvoovaUDdK23mgg=; b=jJxvqS/TNycuHqQwYFlG5R7z3DkGsv6w8524nqyGAVOEHcNEsUfMfo9LhHUsUa7HuQ LWPE4bLhlsZZTbMdOHH77eWlyfCL7X7OktngSck/V9nd1KIaLHQkqTrGJAGB/LOTwXaJ U9/EBtjWSfkomzVynzd62vvlgMxZsSpW2mtBo/30JOOcB4lWlEBqDxOsi+jCsOlPGgMA TneO2CwSJXHG2mITpl+1lwfNrWK5bkjGvoa9D5M5eP7l+dvguIU/Osu3dr2EZ7q/31jK CtKfH4v0ypD9ZyLrY26sik9AWi0X69dqlblAx8a13jS6QTCFfDd0H1aCQK+mqJA855ii u8Hg== X-Gm-Message-State: AOAM5332I0eI7dVP8UTsck68t9ri00KZXOB/L2NnbuI0feqLgCr1CoaF u9vTRAKy8YMM0EJ+kSm4xRW/ZHgmtUxiB6RtEhL9dRvYWyVO/Oc+ X-Google-Smtp-Source: ABdhPJzbPaFCJLSt7HY3JRcDDlT9eK8AjdKTAlHidwtwXCGf8ZCUZbmsx9FVhQz7k4sJDTIW88Ikt9b+/zeAxgWGpxI= X-Received: by 2002:a2e:8557:: with SMTP id u23mr25567723ljj.287.1609253286886; Tue, 29 Dec 2020 06:48:06 -0800 (PST) MIME-Version: 1.0 References: <87v9clnttt.fsf@robertthorpeconsulting.com> In-Reply-To: From: Hongyi Zhao Date: Tue, 29 Dec 2020 22:47:55 +0800 Message-ID: Subject: Re: Microsoft Excel spreadsheet editing directly from within emacs. To: Org-mode , help-gnu-emacs Content-Type: text/plain; charset="UTF-8" Received-SPF: pass client-ip=2a00:1450:4864:20::134; envelope-from=hongyi.zhao@gmail.com; helo=mail-lf1-x134.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+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=bxXkqd9A; 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: E90CC9402C8 X-Spam-Score: -3.03 X-Migadu-Scanner: scn1.migadu.com X-TUID: UWEgiSC42JdM 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. > > - do you also use charts? > > - do you personally use spreadsheet or multiple people have to enter > data? > > - how many rows do you enter over months, or years? > > - are there complex formulas to be followed? > > - if not secret, you can as well show the table of your data to see > here > > Then people reading the mailing list may help you better with advise > how to proceed. > > For some new data coming over and over again I will almost always use > a database to track it. > > Example is weekly statistics, as that is something I may keep for > years in a database and see slices in various periods of times. > > Another example of keeping it in the database are geological > coordinates like latitude and longitude that may have plethora of > various notations and geographic datums. Such coordinates can belong > to a set of coordinates and set of coordinates could be something like > a route or something like area. A route would be drawn differently and > linearly and area would be drawn differently, by connecting the begin > and end position. > > Similar things may be accomplished with spreadsheets as well where > some columns can determine the type of the column with the drop down > list. > > Example of a cell of a spreadsheet with type-like+ > Column A Column B + > +-------------------++-----------------+ > | Mr. Joe Doe || From website | > +-------------------+| From poster | > | By partner | > | By radio | > +-----------------+ > > > When you wish to determine a type for specific entry spreadsheet > programs do offer that, I just find it so much harder then using the > SQL database. > > Once you explain your data entry and your need I will see if I can > help. > > -- Assoc. Prof. Hongyi Zhao Theory and Simulation of Materials Hebei Polytechnic University of Science and Technology engineering NO. 552 North Gangtie Road, Xingtai, China