Is communication between J and Excel automatic? This is important to me. I am wondering how you would make sure that Excel stops updating before sending over to J, and take the next message from J only when Excel has finished updating.
On Wed, 6 Jan 2021 at 23:38, <jph.but...@mailoo.org> wrote: > > 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 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
