Justin,
On a very pragmatic level, I just use CSV as the interchange format. Not ideal but it works. Excel -> CSV -> J + step1 (Linux) : ssconvert -S ssconvert ships with gnumeric, works pretty well and is low hassle + step 2 (Linux): Jd J -> CSV -> Excel + step 1 (Linux): Jd + step 2 (Windows): cut and paste into a designated spreadsheet tab using gvim, and call the data as required from other tabs for formating. I guess something more Excel-ish could be done if the final location of the file is under control (e.g. if no need to e-mail the spreadsheet). + step 2 (Linux or Windows) When I need to do something fancy (mostly geomatics), I simply "import" with LibreOffice, which gives a much better control over what is going on than Excel does. The limit is Excel is "official" in the company. All this is unixly compatible with csvtool if needed. Luckily, my Excel colleagues don't complain too much about receiving CSV's. Incidentally, I am encountering success with the use of markdown within spreadsheet cells; again my Excel colleagues are nice and disciplined and don't mind. Once or twice in the past I added an "export" button using Excel macros, but found it not worth the trouble (Excel are macros too boring and maintainability issues arise when the spreadsheet layout is retuned). As soon as I have workflows acoss multiple systems, some documentation is necessary. I also find MobaXterm provides an excellent terminal for multi-system workflows (transparent security for scp, provides cygwin scripting on Windows, single tool which greatly simplifies training etc.). Philip De : Justin Paston-Cooper <paston.coo...@gmail.com> À : Programming forum <programm...@jsoftware.com> Sujet : [Jprogramming] J and Spreadsheets Date : 05/01/2021 16:40:34 Europe/Paris Hello, I don't know much Excel, and I know some J. The dataflow aspect of Excel excites me, and I am averse to GUI programming. https://code.jsoftware.com/wiki/Articles/JExcel details how to integrate J with Excel. I don't know how up-to-date this is. Because I run Linux, it would be difficult for me to run Excel. Are there any interesting alternatives that would enable me to quickly build interfaces involving dataflow? I couldn't find anything on using Libreoffice Calc. Thanks in advance, Justin ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
