Unanswered

Convert CSV files to Excel workbooks - Office Scripts not working?

(0) Share

Report

Posted on by cbendavid

I have been using Convert CSV files to Excel workbooks - Office Scripts | Microsoft Docs tutorial to convert a csv to excel data in sharepoint. I have also tried in onedrive. My limiter seems to be in Office Scripts since I can't seem to make it beyond csv = csv.replace(/\r/g, "");

function main(workbook: ExcelScript.Workbook, csv: string) {
 
 let sheet = workbook.getWorksheet("Sheet1");

 // Remove any Windows \r characters.
 csv = csv.replace(/\r/g, "");

 // Split each line into a row.
 let rows = csv.split("\n");
 /*

I get the error

Line 9: Cannot read properties of undefined (reading 'replace')

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Yutao Huang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Based on the error message, it feels to me the script input parameter "csv" is probably missing. Can you share a bit more about your flow? Where did you get the source CSV content? Did you pass this CSV content to the "Run script" action as a parameter for "csv"?

Was this reply helpful? Yes No
Bubulover 32 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I previously used the below video and it works for me.

Convert CSV Files to Excel (xslx format) in Power Automate - Bing video

Hoping it helps.

Was this reply helpful? Yes No