- - The excel file path.
- - (Optional) Sheet number. Default is 1.
- - (Optional) Last row number.
- - (Optional) Last column number.
Code: Select all
[ [ "a1", "b1", "c1" ], [ "a2", "b2", "c2" ] ]
Example: Load excel data to ListviewNote: This function uses (instead of ) to read the data, it can avoids the numbers such as converted into . But if the cell contains formula, the formula code itself will be read, not the actual value.
Related script: Create excel file from array or listview