Read an excel in KDB

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

https://github.com/dilshod/xlsx2csv

Thanks all. Seems converting xls to csv is most convienet option available.