hi q experts,
I know that you can write a table to a csv file using save but is it possible to write it to an xls spreadsheet with multiple tabs? like write a table in tab1 and another in tab2
mg
Can you use some tool to convert csv to multiple excel?
At least you can manually convert yourself?
Hi,
You can use the .h.edsn function from the .h namespace (code.kx.com/wiki/Doth) to do this - although it’s still listed as TBD there, so it might change in the future.
This function takes a dictionary with the tab names and tables as an argument.
An example using this to write an xls file:
(:./test.xls) 0:.h.edsn[(test1`test2)!(table1;table2)]
Steven Hutchinson
AquaQ Analytics