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)