KDB to Excel choose cells

Community Support
1

I’d like to export tables to certain cells within Excel.  Is this possible? 

As in tab1 to A1, tab2 to A10, tab3 to A30.

Right now i’m importing data to excel using xml ‘websocket’ but it is not robust enough.  Must be a better way to generate files with multiple tables (given variable number of tables).

Thanks.

2

 Hi Ben,

I see 3 options here

1) You can use save your data int the separate excel file and link all necessary fields with your current excel . i.e. 2 files with links to each other

2) You can send http requests(i.e in this case you need to write macros in Excel)

http://www.timestored.com/kdb-guides/kdb-http-webserver

https://code.kx.com/q/interfaces/excel-client-for-q/

3) You can read all information from the file and save new file with new values


??, 18 ???. 2018 ?. ? 23:31, Ben R <benrothman93@gmail.com>:

I’d like to export tables to certain cells within Excel.  Is this possible? 

As in tab1 to A1, tab2 to A10, tab3 to A30.

Right now i’m importing data to excel using xml ‘websocket’ but it is not robust enough.  Must be a better way to generate files with multiple tables (given variable number of tables).

Thanks.

–
Submitted via Google Groups

3

Hi Ben,

May try this:

h:hopen `:Savetoexcel.xls;

neg[h] raze .h.edsn Table1Table2`Table3

!((A:abc;B:2 5 13;C:ACF);

(D:2 5 13;E:10 20 30;F:AC`F);

(G:ab`c;H:2 5 13;I:10 20 30));

hclose h

Regards

Neetha