Unanswered

How to work with .XLSM spreadsheets - is it any way currently possible?

(0) Share

Report

Posted on by Community member

Hi everyone, I've been presented with the challenge of reading data from a .XLSM file to place in a SharePoint list. So far, I've been unsuccessful with pure Power Automate cloud attempts by trying to get file content and placing it into a newly created file - resulted corrupt. Furthermore, the input file does not have the data saved into a table.

I think I may have to ask the user to transform input data a bit before flow acts on it, but wanted to check if there is ANYTHING that might help get to the data. Potentially thought of maybe planting a spreadsheet in a SharePoint folder with an Office Script to act on another spreadsheet in the same folder, but the Office Script functionality seems limited as well.

Any feedback at all is valuable and would really appreciate it

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

GeoffRen Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

I would recommend using an Office Script. They should be able to work with .XLSM files and you should be able to return the even non table data to Power Automate for use later in the Flow. It seems you tried using Office Scripts to do this a bit. What troubles did you have?

Was this reply helpful? Yes No
Community member on at

Like (0)

Report
Copy link

Link copied!

I was able to talk with the business to change the file from a .XLSM to a .XLSX that allowed me to use an Office Script that is kind of working now. Thank you for the help

Was this reply helpful? Yes No
Community member on at

Like (0)

Report
Copy link

Link copied!

Use macro-enabled files in Power Automate flows - Office Scripts | Microsoft Docs

Was this reply helpful? Yes No