Hi I currently have to collaborate with an excel file that contains quite a bit of complex formula. I cannot simply import the file via xlsx-->csv-->org Since csv does no know about excel formulas. Does anybody know about a tool a trick to use that excel formula. Regards Uwe Brauer
Just an idea (especially given I havent touched Excel formulae for a v. long time):
Have you considered using (G)awk?
It could be possible to build up a list of arrays containing data and formulae and then perform as result in the end block.
It could get onerous to do and may be hackish/bespoke but Awk can be quite satisfying a tool.
Im sure somebody is sitting on a more correct approach however.
====================
Jonathan McHugh
indieterminacy@libre.brussels
July 1, 2021 6:31 PM, "Uwe Brauer" <oub@mat.ucm.es> wrote:
> Hi
>
> I currently have to collaborate with an excel file that contains quite a
> bit of complex formula. I cannot simply import the file via
> xlsx-->csv-->org
>
> Since csv does no know about excel formulas.
>
> Does anybody know about a tool a trick to use that excel formula.
>
> Regards
>
> Uwe Brauer
On Thursday, 1 Jul 2021 at 18:28, Uwe Brauer wrote: > I currently have to collaborate with an excel file that contains quite a > bit of complex formula. Do you need bi-directional collaboration? If you do, I doubt there's a solution out there. Collaboration with people using MS based tools is challenging (being polite here). > I cannot simply import the file via xlsx-->csv-->org xlsx is XML based so you could, in principle, read the information directly from the xl/worksheets/sheetN.xml component in the file (the xlsx file itself should be a zip archive). The format will consist of entries such as <row r="1" ...><c r="A1"...<f>FF</f><v>XX</v></c>...</row> where FF would be the formula (and XX the value of that formula) for entry in A1. Lots of detail omitted in the above, mind you. -- : Eric S Fraga via Emacs 28.0.50, Org release_9.4.6-577-gf76d4d : Latest paper written in org: https://arxiv.org/abs/2106.05096
[-- Attachment #1: Type: text/plain, Size: 1156 bytes --] >>> "ESF" == Eric S Fraga <e.fraga@ucl.ac.uk> writes: > On Thursday, 1 Jul 2021 at 18:28, Uwe Brauer wrote: >> I currently have to collaborate with an excel file that contains quite a >> bit of complex formula. > Do you need bi-directional collaboration? If you do, I doubt there's a > solution out there. Collaboration with people using MS based tools is > challenging (being polite here). Xlsx-->org would be enough for the moment. >> I cannot simply import the file via xlsx-->csv-->org > xlsx is XML based so you could, in principle, read the information > directly from the xl/worksheets/sheetN.xml component in the file (the > xlsx file itself should be a zip archive). The format will consist of > entries such as > <row r="1" ...><c r="A1"...<f>FF</f><v>XX</v></c>...</row> > where FF would be the formula (and XX the value of that formula) for > entry in A1. Lots of detail omitted in the above, mind you. Right, this is basically what I am trying to do now. A manual approach of sorts. I just realized that there are operations I am not sure how to do them in org. I'll send a different post about it. [-- Attachment #2: smime.p7s --] [-- Type: application/pkcs7-signature, Size: 5673 bytes --]