Force Import Format of Excel columns
Dear community, I am trying to import data from the attached Excel file "DATA_SAMPLE_TO_IMPORT.xlsx", using following jsl script: Open(
".\DATA_SAMPLE_TO_IMPORT.xlsx",
Worksheets( "DATA" ),
Use for all sheets( 1 ),
Concatenate Worksheets( 0 ),
Create Concatenation Column( 0 ),
Worksheet Settings(
1,
Has Column Headers( 1 ),
Number of Rows in Headers( 1 ),
Headers Start on Row( 1 ),
...
cyrille_wagner