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 22:47:55 +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="39825"; mail-complaints-to="usenet@ciao.gmane.io" To: Org-mode , help-gnu-emacs Original-X-From: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane-mx.org@gnu.org Tue Dec 29 15:49:10 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 1kuGJC-000AGf-A2 for geo-emacs-orgmode@m.gmane-mx.org; Tue, 29 Dec 2020 15:49:10 +0100 Original-Received: from localhost ([::1]:49258 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kuGJA-0001np-US for geo-emacs-orgmode@m.gmane-mx.org; Tue, 29 Dec 2020 09:49:08 -0500 Original-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 Original-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 Original-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) In-Reply-To: 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+geo-emacs-orgmode=m.gmane-mx.org@gnu.org Original-Sender: "Emacs-orgmode" Xref: news.gmane.io gmane.emacs.orgmode:134249 gmane.emacs.help:126897 Archived-At: 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