I have created an excel file and it is opened without any problem,
but I don't know how to format all the cells in Sheet1 to the specific format, "Text" other than "General"
Please help me!
Code: Select all
path := "E:\test1.xls" sleep, 100 XL := ComObjCreate("Excel.Application") sleep, 100 XL.Workbooks.Open(path) sleep, 100 XL.Visible := True