Generating Excel without headings

0

Hi Michał,
I don't think there is a built in way to do it.
The only thing that comes into my mind is using Generate an Excel file Action, with a template, where row with headers will be hidden. (Have not tested it though)

It's still not what you are asking, because header will be there, just not visible.

Exactly, I need an Excel file with no headers because this is only accepted by the app I want my users to import this file to. If I only hide them thay will still be there, as you said. Too bad, as this would be easy to program in the designer studio.

Hi Michał,

I only know a part of your use case but I want to let you know of two options I'm aware of:

There's a PowerShell library for working with Excel file which doesn't require excel to be installed. Maybe a PowerShell action could help you in this case. At least, if the App has an API to which you can upload the document from PowerShell. While it would be possible to read / get the Excel file, it will get tricky to write it back, as the workflow will be checked out during the action execution.
https://github.com/dfinke/ImportExcel

The PowerShell uses an old version of a now commercial solution. There's still this .dll around which could be used in an SDK to remove the headers.
https://www.nuget.org/packages/EPPlusFree/

Best regards,
Daniel

Thanks Daniel, I will try that!