Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SetCell function doesn't work for me
#3
Thanks for your quick reply, Gintaras!
Actually, some ExcelSheet functions work, for example this code runs without errors:
 
Code:
Copy      Help
typelib Excel
Excel.Application a._create
Excel.Workbook b=a.Workbooks.Add()
ExcelSheet es.ws=b.Worksheets.Item(1)
es.Activate(4) ;;activate Excel
es.ws.Application.Sheets.Item(1).Name = "Object Browser"
int intWindow=win("" "XLMAIN")
max intWindow
str FilePath.expandpath("$desktop$\Object Browser.xls")
del FilePath; err
b.SaveAs(FilePath @ @ @ @ @ 1)

es.ws.Application.ActiveSheet.Range("A1").Value = "Object"
es.ws.Application.ActiveSheet.Range("B1").Value = "Member"
es.ws.Application.ActiveSheet.Range("C1").Value = "Definition"
Seems like only ExcelSheet__Range function doesn't work

I need to loop through cells and set their values using counters as cell addresses.
Is there a workaround for it, without using SetCell?


Messages In This Thread
RE: SetCell function doesn't work for me - by linkiddx - 09-08-2024, 11:01 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)