[EKL Quick Tips] Reading "multi line" Excel cells in EKL

EKL ​​​​​​​Knowledgeware ​​​​​​​

I was wondering if an EKL script could manage an Excel sheet with multi line cells... For the record, it works fine using SplitString and Chr(10).

EKL Script :

let sPathExcelFile (String)
sPathExcelFile = "E:\myExcelFile.xlsx"


let xlSheet (DTSheetType)
xlSheet = CreateSheet(sPathExcelFile)

xlSheet.SheetIndex = 2

let CellMultiLine (String)
CellMultiLine=""
CellMultiLine =xlSheet.CellAsString(6,1)
Notify("cell = #",CellMultiLine)

let lstCellValues(List)
lstCellValues = SplitString(CellMultiLine,Chr(10),False)
Notify("# lines",lstCellValues.Size())

let singleVal (String)
for singleVal inside lstCellValues
    Notify("line : #",singleVal)