0

Assistance Needed – Excel Table Printout to Word (Image Size, Scaling, and Font Issues)

Filipe Otávio Reis

04 March 2026 19:28

None

Follow

Hello,

I hope you are doing well.

I am currently using Encodian actions within Power Automate to extract a print of an Excel table and insert it into a Word document. However, I am facing some issues and would like guidance on the best approach.

Current Process

1. I use the "Convert Excel" action to convert my Excel table into PNG.
2. After that, I use "Populate Word Document", applying the option "Fit to size" so the image adjusts to a placeholder inside the Word template.

Issues I Am Experiencing

1. The PNG generated from Excel includes the entire Excel screen area, not only the selected table.

   • Because of this, the image becomes very large,
   • it creates excessive blank space inside the Word document,
   • and it breaks the formatting of the final output.

2. The image does not auto-scale properly.

   • If the table is small, I want it inserted with a proportional smaller size.
   • If the table is large, I want it to scale to the placeholder size without overflowing.
   • Currently, the PNG always comes with too much surrounding empty area.

3. Excel font is not preserved.

   • In Excel I use the Sora font.
   • However, after converting to PNG, the font appears changed in the final output.
   • I need the generated image to preserve the original Excel font exactly as defined.

What I Need

I would like guidance from Encodian on:

1. The best action or recommended approach to export an Excel table as an image only of the selected range, without capturing the entire sheet.
2. How to ensure the PNG is generated with correct dimensions, proportional to the original table size.
3. How to maintain the Sora font (or custom fonts in general) when converting Excel to an image.
4. Whether there is an Encodian action that allows:
   • exporting only a named range
   • or capturing a defined table
   • or cropping the output automatically before sending to Word.

If needed, I can provide screenshots showing how the output is currently appearing in the Word document.

Thank you in advance for your help.
Kind regards,
Filipe

• Facebook
• Twitter
• LinkedIn

1 comment

• 
  Permanently deleted user 05 March 2026 14:30 Official comment

  Hi Filipe,

  Thank you for getting in touch with your query.

  Can you please confirm if you need the Excel table to go into the Word document as an image specifically?

  I ask because another approach could be to have a table template in your Word Template document, we can then use Excel - Extract Rows to obtain the table data from the Excel document and use this to populate the Word document.

  If you did want to take this alternative action then you would need to add a table to your Word template and add in the tags to allow array data to populate the table. My example is below and attached but I have also provided a link to the article that details the different Syntax that can be used in Word - Populate here.

  

  Now in the flow you would need to use the Excel - Extract Rows action. Simply add the Base64 of the Excel document in to the File Content as Dynamic content. There are additional settings you can add if required, but my example uses the default (settings info can be found in the support article).

  Next I added in a Compose action to create the JSON for the Word Populate action (please note this is not a requirement, you can just add the JSON directly in the action)

  My compose setup is as below - 

  

  I have the dynamic content from the Excel - Extract Rows action wrapped in JSON because if you do not it is considered as string data

  

  Then you simply need to add the output of the Compose into the Word - Populate action.

  This will give you the results as per the table below

  

  I also note that if you have the Tags in the word template set with the Font you require it will retain the font in the result document.