Unanswered

Create Excel Table output without Header row

(1) Share

Report

Posted on by MO-19080930-0

I've been asked to create a workflow that processes an input csv and saves the output as an excel file which I've been able to do. But because this requires an Excel Table it has the header row Column1, Column2 etc.

The file will be uploaded into another system which won't accept this. Is there a way to create an excel table or insert rows into an excel file without needing the header rows? Or can I somehow create an excel file in SharePoint and set the file content with a .csv formatted object? Any work around would be acceptable. I don't particularly want to open each file and delete out the top row, it sort of defeats the point of Power Automate.

Thank you.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Chriddle 8,441 Super User 2025 Season 2 on at

Like (1)

Report

You can do this via Graph API requests (convertToRange and delete):

E.g.:

Post https://graph.microsoft.com/v1.0/me/drive/root:/tmp/test.xlsx:/workbook/tables/AATest/convertToRange
Post https://graph.microsoft.com/v1.0/me/drive/root:/tmp/test.xlsx:/workbook/worksheets/Tabelle1/range(address='A1:F1')/entireRow/delete

Was this reply helpful? Yes No
MO-19080930-0 38 on at

Like (0)

Report

Thanks for the suggestions. I can't use Encodian because there's a licensing cost and unfortunately I don't have permissions to use the Graph API in our business.

I ended up using this method:

Convert CSV files to Excel workbooks - Office Scripts | Microsoft Learn

In SharePoint Online by creating the .osts file in my document library instead of OneDrive in the example. This worked really well actually:

Was this reply helpful? Yes No