Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ALL
I am trying to export a table with data to PDF. However, it is not exporting just the current sheet.
Kindly advise how to export all.
Rgds
Bharati
Export to PDF will only export what you can see on the screen.
If you want all of the data in a table then you need to choose export data when you right click on the table object.
You also can Export to PDF the entire sheet. But again it will only show you whatever you are currently looking at.
There may be an extension that does something different. But not sure.
Are you trying to export ONE table or all Graphs and Tables??
Export to PDF will only export what you can see on the screen.
If you want all of the data in a table then you need to choose export data when you right click on the table object.
You also can Export to PDF the entire sheet. But again it will only show you whatever you are currently looking at.
There may be an extension that does something different. But not sure.
Entire sheet
Thank you for your reply!
Yes i tried Export data and this work fine but we want to export entire sheet in PDF so that it is read-only.
Exporting in PDF will only take screenshot of chart and convert it into PDF. It won't export whole data.\
In that case you can export in Excel and convert it into PDF.
Hi Bharati,
Export PDF steps as below:
Step1: Create a document report.
Step2 : Create a Action of Text Box and pass Document Report ID to export to PDF
Thanks,
Nitin
Qlik Branch has few options. One of them is Qlik Branch
Hi ,
Try this code:
SUB Export
set sObject1 = ActiveDocument.GetSheetObject("CH09")
sObject1.Export "E:\QlikView\Data\Testing\Report.Pdf", ", "
end sub
By using this macro u can store any where u want and u can save file which format u want .
I hope this may helps you.
-Nagarjun
Hi
thank you for your reply.
Please advise where to put this code.
SUB Export
set sObject1 = ActiveDocument.GetSheetObject("CH09")
sObject1.Export "E:\QlikView\Data\Testing\Report.Pdf", ", "
end sub
Rgds
Bharati