Database to excel

[#1]

Hi All,

I have connected Qlikview app to database and have also loaded the data.

Now i want to load that data into excel sheet.

Let me know the script syntax.

Thanks

[anbu1984]

Check this link

http://www.quickintelligence.co.uk/write-csv-qlikview-store/

[vardhancse]

If we want to export data to excel, why cant' u directly export from DB.

If want to export data from QlikView we can use some objects in front end and can export the data to excel.

Straight table,Table Box -> Export to excel.

If not in script->

Store into (File_Name.xlsx);

[its_anandrjs]

Hi,

From Qlikview table not store file as the Excel file you have to store it CSV text and then you can save it later as excel file from windows

Ex:-

TableName:

LOAD * Inline

[

Regions,Sales

R1,4582

R2,2563

R3,2693

R4,1852

];

STORE TableName into TableName.csv(txt);

Regards

Anand

[ashfaq_haseeb]

Hi,

Try like this

STORE [Your Table Name] into  [Your Table Name].xls(txt);

Regards

ASHFAQ