Janklab provides an API for reading and writing Office files, especially Excel. This allows you to work with Excel
Matlab has support for Excel reading and writing, using xlswrite
, writetable
, and similar functions. But it only supports reading and writing of basic arrays and tables, and requires Microsoft Excel to be installed on your machine.
Janklab’s Office IO API doesn’t use the Office applications. Instead, it’s built on the Apache POI Java library, and reads & writes the files directly. This is good because:
wkbk = jl.office.excel.createNew();
sheet = wkbk.createSheet("Hello");
sheet.cells{1,1} = "Hello, world!";
sheet.cells{2,1} = 42;
wkbk.save("Hello World.xlsx");
Actually, Excel is the only format currently implemented. I’ll add Word or other applications if there’s actual user interest in them.