Using Excel Scripts with Power Automate to convert CSV

[@markmclean154]

great job Shane, Just had a use case presented to me today after one of our vendors no longer export to a true table.

[@ShanesCows]

Awesome! Good news a couple of weeks aog I woulud have your were stuck but not with this magic. 🤩

[@alexjones3045]

Hi Shane, great video as always. I use this formula to support with dynamic table ranges when creating an excel table in PA '=OFFSET(Sheet1!A1,0,0,SUBTOTAL(103,Sheet1!$A:$A),10)' Just need to insert the formula into the 'Table Range*' section of the (Excel) Create Table within PA. I can't take credit for this formula and tip, but credit to the unknown author.

[@ShanesCows]

Awesome, thanks for sharing!

[@oluwatobiyusuf]

Thank you Shane

[@ShanesCows]

Always happy to help. 😎

[@daudi4793]

Hey Shane, Thank you for making this awesome video. I am wanting to convert csv into xlsx. I have 85 columns and about 3890 rows. The rows will vary from month to month. I have used gpt in the past to generate a script for me and it has been a hit and miss for the steps shared by gpt and the script. If I want to follow your video to conver csv into xlsx and don't want the file data in sharepoint, so until what point should I follow your video?

[@ShanesCows]

I would follow the video until you run the script. At that point you have a proper XLSX. Then you could do whatever you want with the file, like get it out of SharePoint. But you are going to have to put the file on SharePoint or OneDrive to use the Excel actions. So do things in SharePoint and then move the file where you want it.

[@ikas0011]

Thanks Shane. this is very useful .. I wish I have your curiosity :D

[@ShanesCows]

Thanks. Curiosity is fun. 🤩

[@Akira_203]

ChatGPT and other LLM’s when used as coding assistance are like kiddy-scripting on steroids

[@ShanesCows]

Yeah, they can be used just for Kiddy Scripting but also if I wanted to get deep in Excel Scripts I could. I could use the LLM to help me create a learning plan, explore topics deeper, and become an Excel Script. That is cool, either learn just enough to solve a simple problem or become a pro, all up to me. 😎

[@Akira_203]

F in the chat for all those peeps with office scripts disabled for security reasons 🫡

[@bossrf274]

F

[@ShanesCows]

Yeah, I can't do anything about that 🙃