I have an excel file and want to read this in KDB. is there any way I can do it ? I tried reading with read0 but the data there is almost unrecognizable to format it further.
Your best bet is to convert the excel file to csv and then load the csv
http://code.kx.com/wiki/Cookbook/UsingKdb#How_do_I_import_a_CSV_file_into_a_table.3F
There are functions in the .h namespace for creating excel sheets, but none that I know of for the reverse operation
To: Terry Lynch , Kdb+ Personal Developers
If you're on Windows (and apparently Linux but I haven't tried it) you can use ODBC direcly from kdb to read the file http://code.kx.com/wiki/Cookbook/ODBC/qclient
Or you can use POI or jExcelReader via Java (or odbc/jdbc bridge)=E2=80=8E. Not a small amount of effort so if a one-off=E2=80=8E use the CSV as Terry suggested.
|
From: Terry Lynch
Sent: Thursday, August 20, 2015 04:09
To: Kdb+ Personal Developers
Reply To: personal-kdbplus@googlegroups.com
Subject: Re: [personal kdb+] Read an excel in KDB
|
Your best bet is to convert the excel file to csv and then load the csv
There are functions in the .h namespace for creating excel sheets, but none that I know of for the reverse operation
Thanks all. Seems converting xls to csv is most convienet option available.