OfficeWorker

Sinimon

Member
Hello i want to work with the OfficeWorker library. i want to open a existing excel file. then i want to read and write some things in the excel file. i dont know how to read the infos of the cells...
can i do any easy thing like this:
text = Excel.cell (2,3)
msgbox (text,"")
?
or is it more complicated?
 

Sinimon

Member
The sample contains how to create a file and rows. and how to write in this rows. but I want to open a file and read some infos... i tried it... but no positive result :-(
 
Upvote 0

Sinimon

Member
ok i found a way to open the excel file.. i thing i have to do it by:
ew.readFileAsExcel(File.DirRootExternal,"excel.xls")

but how can i read the info of the Cell located at x:3, y:2 as example??
 
Upvote 0

peacemaker

Expert
Licensed User
Longtime User
Seems, there is no method for getting an existing WorkBook and getting cell's value from a row.
 
Last edited:
Upvote 0

szaldapetree

New Member
Licensed User
Longtime User
I could easily be missing something but I cannot find a way to open an existing .xls file and set it to a workbook instance. This is too bad because I could really use this library if I could read and update existing xls files.
 
Upvote 0

DonManfred

Expert
Licensed User
Longtime User
Upvote 0
Top