saving data on drive in script

[#1]

Hi All

as we import data from drives in to qvw like

load * from table

can we export data from qvw in the script on to excel saved on shared drives

can you please share syntax

thanks

[#2]

Hi ,

You can store the file in CSV format\

Store tablename into filename.csv (txt) ;

[#3]

so that means i can't save in existing xls file via script?

[#4 · Accepted solution]

tab:

load *

from tablename;

store tab into D:\test.qvd;

store tab into D:\test1.xlsx;

[#5]

Hi,

Yes,you can save in existing xls file via script.

use the syntax:

Store tablename into filename.xls;

Regards,

Snehal Nabar