Forum Discussion
Convert CSV to Excel Office Script
I created the convert csv to excel office script from the template. I used it in power automate to convert all csv files in a folder to excel. It worked great until today now I am receiving and error...
It doesn't work in Automate
See line 30, column 13: Office Scripts cannot infer the data type of this variable. Please declare a type for the variable.
perhaps works in ScriptLab.
But in general, does that solve an issue when csv is not forwarded to the script?
// Create a 2D array with one row. change back
let data: string[][] = [];
Because I tested it in native js environment rather than type script, so I use let data=[] without type declare.
if possible,use that in your codes as above.
what I mean change the regular expression which can parse directly without additional codes to check like below
// Check for blanks at the start of the row.
if (row[0].charAt(0) === ',') {
row.unshift("");
}
let data: string[][] = [];
Because I tested it in native js environment rather than type script, so I use let data=[] without type declare.
if possible,use that in your codes as above.
what I mean change the regular expression which can parse directly without additional codes to check like below
// Check for blanks at the start of the row.
if (row[0].charAt(0) === ',') {
row.unshift("");
}
What a shame...
Lorenzo , I've seen nothing more.
Did I miss something or did aflesner not come back to you on this issue?
- Yes,I think so.
Oh, yes, your javascript/truescript professionalism is very appreciated, it helps to adjust existing ExcelScript. To play with the flow we need to reproduce it in our environment with data used, not enough input for that.
- Sure, that is true. I have no environment to have trouble shooting on the Power Automate flow question from the open thread.
Just a small talk on relative codes -:) That's okay, but that doesn't answer on question why we don't have csv input from Power Automate flow.
