topic Re: Store table data loaded in script into .xls/.xlsx in QlikView

Store table data loaded in script into .xls/.xlsx

punitpopli — Thu, 16 Nov 2017 02:25:58 GMT

Hi Experts,

May I know if we can store the table loaded in QliKView script into .xls or .xlsx file?

Have gone through few posts, but didnt find the solution for the same.

Can anyone please help me in here?

Thanks in advance

Regards,

Punit

Re: Store table data loaded in script into .xls/.xlsx

punitpopli — Thu, 16 Nov 2017 02:35:56 GMT

I think we can use this macro,but need to know if we can get tableName instead of ObjectID.

Sub BasicExportToExcel

DIM ExcelApplication, ExcelWorkbook

SET ExcelApplication = CREATEOBJECT("Excel.Application")

SET ExcelWorkbook = ExcelApplication.Workbooks.Add

ActiveDocument.GetSheetObject("TB01").CopyTableToClipBoard TRUE

ExcelWorkbook.Worksheets(1).Paste

ExcelApplication.DisplayAlerts = FALSE

ExcelWorkbook.SaveAs "C:\BuffaloBI - Post Content\Qlikview\Export Excel\test.xls", 56

ExcelApplication.Quit

MsgBox "Export Complete"

End Sub

If we can get table Name then the Macro can be used for exporting the data to required format from the script.

Re: Store table data loaded in script into .xls/.xlsx

rwunderlich — Thu, 16 Nov 2017 04:03:33 GMT

No, this macro would not work from script. The ActiveDocument handle is not available from script. The only idea I can think of is to store it in csv format (txt) and call some batch converter on the file. Google "csv to excel command line" and you'll see lot's of options ranging from free to low cost.

-Rob

Re: Store table data loaded in script into .xls/.xlsx

punitpopli — Thu, 16 Nov 2017 09:02:42 GMT

Thank you rwunderlich‌ for you reply, will work on the approach.

Regards,

Punit

Re: Store table data loaded in script into .xls/.xlsx

tomasz_tru — Thu, 16 Nov 2017 14:01:12 GMT

Set extension of your CSV file to .xls and Excel should open it. SAP used this advanced technology for export

Re: Store table data loaded in script into .xls/.xlsx

punitpopli — Wed, 22 Nov 2017 09:14:08 GMT

Thanks for your reply, will work on the proposed solution.