Share
Report
2Hi,
I had a flow working perfectly, converting csv to xlsx but since last Thursday it stopped working.
The flow uses the following script (taken from Power GI youtube tutorial: https://www.youtube.com/watch?v=2TIolfmtWQM) that no longer works:
function main(workbook: ExcelScript.Workbook, linecsv: string[]) {
let selectedSheet = workbook.getActiveWorksheet();
const alllines = linecsv;
let counter = 1;
for (let line of alllines) {
if (line.includes(",")) {
let items = line.split(",");
// Set range A1:B2 on selectedSheet
selectedSheet.getRange("A" + counter + ":B" + counter).setValues([[items[0], items[1]]]);
counter++;
}
}
// Add a new table at range A1:B2 on selectedSheet
workbook.addTable(selectedSheet.getRange("A1:B" + counter), true).setName("hoja1");
}
It runs, but it does not return anything other than a table with no data. It seems part of this code does not work since latest microsoft change on Thursday, whtever it was.
Thank you,
Categories:
I have the same question (0)
All responses (
Answers (
