+ Reply to Thread
Results 1 to 2 of 2

Export data from a table in power query as an image

  1. #1
    Forum Contributor
    Join Date
    07-08-2014
    Location
    israel
    MS-Off Ver
    office 365
    Posts
    101

    Export data from a table in power query as an image

    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
    Attached Files Attached Files
    Last edited by sryair; 03-26-2024 at 03:13 AM.

  2. #2
    Forum Contributor
    Join Date
    07-08-2014
    Location
    israel
    MS-Off Ver
    office 365
    Posts
    101

    Re: Export data from a table in power query as an image

    I tried using
    = Excel.Workbook.Write(Excel.CurrentWorkbook(), "Filtered Data", TablesAsTable)

    But I get an error

    Is it possible to export tables created in the query as tables or as images to the workbook?

    Thanks in advance for any ideas or help on how to do
    Last edited by AliGW; 03-29-2024 at 03:29 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 01-08-2024, 09:57 PM
  2. [SOLVED] Power query - Match data from Table 1 to table 2
    By stribor40 in forum Excel General
    Replies: 2
    Last Post: 11-28-2023, 11:07 PM
  3. Power query header merge and export to csv
    By CeLxIcFeTlON in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-05-2023, 05:03 PM
  4. Replies: 3
    Last Post: 11-26-2022, 02:14 AM
  5. Sorting Pivot Table Pulling from Power Query Data Table
    By perkyparker in forum Office 365
    Replies: 1
    Last Post: 05-22-2021, 03:02 PM
  6. Update Power Query before export with VBA
    By lofgren in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-26-2020, 03:36 PM
  7. Excel export to Power Point--Image Scale code
    By VBNewb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2011, 08:21 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1