CODEWITHSUNDEEP
automationkdb+
user8415577
user8415577

Reputation:

Automating scripts in q/kdb

I have some codes in kdb+(which uses q) which generates data in tabular form. The problem is I need to run each line separately and export the data to excel. Is there any way to automate this such that all the excel files can ben generated in one go? Thanks

Upvotes: 1

Views: 619

Answers (1)

Sean O'Hagan
Sean O'Hagan

Reputation: 1697

Whils't you can of course use csv as suggested above, .h.edsn is the function used for creating excel workbooks. It takes a dictionary of sheetNames->tables.

`:/var/tmp/excel.xls 0: .h.edsn `tab1`tab2!(([]10?10);([]20?20))

Then just open the xls file in excel.

Upvotes: 4

Related Questions