I'm using the following technique to convert CSV data into Excel:
Convert CSV files to Excel workbooks - Office Scripts | Microsoft Docs
However, as some values in the CSV contain a comma, they are wrapped in quotes. Example:
The quotes are carried over to Excel, which is unintended.
Can I edit the script or otherwise remove the quotes from the final Excel somehow?
Go to Solution.
Assuming it is column B, just add the following to the end of your script:
Please consider accepting my answer as a solution if it helps to solve your problem.CheersDamienPlease take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks
View solution in original post
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Check out the new Power Platform Community Connections gallery!