Script converting then corrupt XLSX?

[jamiechalmerzlp]

Basically I am trying to modify the flow to work dynamically so when an email comes in with a subject filter of "XXX" then 'Loop' to create files saving the attachments, then it moves on to the flow documented here https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/convert-csv however, it does create the XLSX but they are corrupt so when I try to open the doucments, they don't open and I get an error stating 'This workbook couldn't be opened because the file format may not be matching with the file extension.' Also note, my workbook sheet for the CSV is not called 'Sheet1' so I don't know if that is having an impact on it. Please help ASAP :(

Article URL

(https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/convert-csv

[AlexJerabek]

Hi @jamiechalmerzlp,

Let me see if I can help. First, we need to understand where the error is introduced.

Did you try the sample independent of your email scenario? If you create everything with the files in the convert-csv-example.zip file, does it work?

In your flow, are the .xlsx files able to be opened before the script is run? Put another way, if you remove the Run script step, are you able to open the empty .xlsx files? That would tell us if the issue is with the script or earlier in the flow.

Also, the worksheet name shouldn't matter as long as it's the same in the template file.

[jamiechalmerzlp]

Hey @AlexJerabek thanks for the sharp response. In all honesty, I have not tried it with the test documents as I had my own CSV that I needed it to function with so I had been testing with that. I have attached an image of my flow. The top half just saves the email attachments to a folder called 9x9, the bottom half follows the

[AlexJerabek]

Thanks for sharing the flow screenshot. I can't see anything wrong, so we're going to have to try a couple debugging steps.

1. If you remove the Run script step, are you able to open the XLSX files?
2. When you test the flow, you can select each step after it runs to see the output. Does the .csv output look normal in your Get File Content Dynamically For CSVs step? Here's my output from the test files.
   

[jamiechalmerzlp]

Hey Alex, so I have it working now to copy the contents from the csv to the newly created xlsx, however, I am still seeing "" around the strings on the spreadsheet, indicating to me that there must be something wrong on my end of course. However, I have done step by step everything the guide states to me. Can you possibly take this to PM with me so that I can share the screenshots without releasing employee data? Many thanks