9:41 AM
xlsxOpen[filePath_] := Module[{wb}, wb = StartExternalSession[<| "System" -> "Python", "Version" -> "3", "Executable" -> "/usr/local/bin/python3" |>]; ExternalEvaluate[wb, "import xlsxwriter"]; ExternalEvaluate[ wb, StringTemplate["workbook = xlsxwriter.Workbook(\"``\")"][filePath] ]; ExternalEvaluate[wb, "worksheet = workbook.add_worksheet()"]; wb ]
xlsxWrite[wb_, r_, c_, v_] := ExternalEvaluate[ wb, StringTemplate["worksheet.write(``, ``, \"``\")"][r, c, v] ]
xlsxMerge[wb_, r1_, c1_, r2_, c2_, v_] := ExternalEvaluate[ wb, StringTemplate["worksheet.merge_range(``, ``, ``, ``, \"``\")"][r1, c1, r2, c2, v] ]
9:58 AM
10 hours later…
8:02 PM
@halirutan @C.E. Thanks. Today I have tried the Java approach. Yesterday I tried the python approach but I didn't succeed to execute "> pip.exe install pyzmq" described here. The message was of the kind "access to a file denied"
8:25 PM
« first day (2797 days earlier) ← previous day next day → last day (1655 days later) »