Excel table formatting

[N30fyte]

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

[Shai_E · Accepted solution]

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

[N30fyte]

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