Hi
I have a simple table with 3 columns
I run several filtering rules on the table (3 in this example) and get 3 filtered tables according to the parameters I defined
To simplify, I built a query that only creates the filtered tables.
In the next step I want to run a loop that will load all the filtered tables as an image into an existing sheet called "Rprt"
Is it possible to export a table as an image from query to the workbook?
If it is not possible to export as an image, how can you dynamically export all the tables to the workbook using a loop (the amount of rows and columns varies according to the different filters)
The ultimate goal is to collect all the filtered tables and eventually create a report from all these tables and export it to pdf
In the attached query I tried to write:
Excel.Workbook.Write(Excel.CurrentWorkbook(), "Filtered Data", TablesAsTable)
And I got an error
Am I using the Excel.Workbook.Write function correctly?
Is it possible to do this i.e. export all the tables created in the query to the workbook as a table or as a shape?
Thanks in advance for any ideas or help on how to do
Bookmarks