topic Re: Excel table formatting in Qlik Automate

Excel table formatting

N30fyte — Thu, 28 Aug 2025 10:44:01 GMT

Hi,

I'm using the Create Excel Table with Headers automation block to create spreadsheets from Qlik Sense straight tables and distribute them by email.

It all works fine, but I do have an issue with the formatting of the output spreadsheets. They are created by default with blue and white shaded alternate rows and sort/filter arrows in the column headers.

Ideally I would like to produce 'straight' Excel tables with no formatting at all. Is this possible either by modifying the Create... block or by using a different approach?

Thanks!

Neo

Re: Excel table formatting

Shai_E — Tue, 02 Sep 2025 12:31:06 GMT

Hi @N30fyte

From checking the api behind the scenes for the block

Create Excel Table with Headers

Which seems to be

tableCollection: add - Microsoft Graph v1.0 | Microsoft Learn

Even in the docs to create a table i dont see an option in the body to specify a style.

There is an option to specify a style when updating a table

Update table - Microsoft Graph v1.0 | Microsoft Learn

I think this request should be considered as a feature request, to maybe add a block to update a table.

Best Regards

Re: Excel table formatting

N30fyte — Wed, 03 Sep 2025 07:52:22 GMT

Thanks @Shai_E ! I think I may have to investigate building a straight .xlsx using the existing Excel blocks as the end-user's requirement is not for a table.

Rgds,

Neo