some demo code:
Code: Select all
xl := ComObjCreate("Excel.Application")
xl.Workbooks.Open("R:\test.xlsx")
xl.Sheets("Test").Select
xlContent := xl.ActiveSheet.UsedRange.Value
Msgbox, % xlContent[13, 6]
xl.Workbooks.Close()
xl.Quit
xl =
Let's say that the cell at 13, 6 contains the text "2000".
My problem is, that the array at that position will not contain "2000"
now, but "2000.000000"...
It doesn't matter if the Excel cell is formatted as standard or text.
What am I missing here?