Read Raw Excel Data (unformatted xlsx) using Power Automate - Excel File to SharePoint List

Office script used in this video:

[Sebastian-phyr]

WOW. I have to ask, can i do it with xls format? actually the reports i can capture has that one-page data format. I could use xlsx format but that report is generated with multiple sheets (it´s a nightmare). Thanks again

[Arcaser]

This is the best thing I’ve seen all day

[jamesmosier]

to get dynamic range area - let newTable = workbook.addTable(selectedSheet.getUsedRange(), true)

[jkunkoski]

I guess my only critique would be what happens if your range is variable. I notice the range is set and if you have less rows than the range, the same range is still brought in. It would be nice to be able to account for that. Looking that up now but not having much luck. Thanks for the video

[adyelencu]

Amazing video! Helped us with a simple and elegant automation. We do have a question, though: what if I don't know the number of rows my file will have? I can set it to a high number, but then it will run into a loop and try creating blanks. It still does the trick, just not very elegant. Got a suggestion?

[deeptech]

Wow, Thanks very much, You are life saver. I was struggling with this the whole day.

[marcosnunes]

Great video thanks!
I had a small issue on line 5 when trying to rename my table.
When running the script manually on excel it was working perfectly. When the script was triggered by my work flow, my table was not getting renamed on excel, meaning there was no results on my workflow output.
To solve it I decided to rename my excel table in a new line and it worked:

let newTable = workbook.addTable(selectedSheet.getRange("A1:F10"), true);

newtable.setName("mytable");

[timfruit]

This was incredibly helpful. Thank you!

[ahmedbenyahia]

Thank you so much, this has supported me a lot😃

[ugandhar]

is it possible to format all the sheets in a book and update table name with sheet name?

[dcpowered]

Thanks a lot! Please post more videos on Power Automate!
P.S. please use a better mic.

[pradipta]

do I need to write script for each individual files ? its impossible if the files are generated dynamically. Is there any we can attach the Script to dynamic files ?

[ion]

Awesome video and very well explained i wish you had a channel of your own, is confusing some videos are in spanish and others in english.