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)