don't know how to format the whole excel worksheet in Text format
Posted: 20 Jul 2018, 14:04
Hi all,
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!
Thank you!
Kitty
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"
Code: Select all
path := "E:\test1.xls"
sleep, 100
XL := ComObjCreate("Excel.Application")
sleep, 100
XL.Workbooks.Open(path)
sleep, 100
XL.Visible := True
Thank you!
Kitty