OfficeWorker

[Sinimon]

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]

Do anyone have an idea?

 

[Kiffi]

Do anyone have an idea?

just test it by yourself. The library contains a sample-code.

Greetings ... Kiffi

 

[Sinimon]

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 :-(

 

[Sinimon]

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??

 

[Erel]

For some reason you appear as an unlicensed user in the forum. Please contact support@basic4ppc.com in order to fix it.

 

[peacemaker]

Seems, there is no method for getting an existing WorkBook and getting cell's value from a row.

 

[szaldapetree]

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.

 

[Firpas]

Where is the link to download OfficeWorker library??

The initial link

https://www.b4x.com/android/forum/threads/officeworker-create-office-docs.13117/#content

not work.

Thanks

 

[DonManfred]

better use the excel-lib

 

[Firpas]

Thanks

With Excel lib, is posible insert images??

And with OfficeWorker library??

 

[DonManfred]

With Excel lib, is posible insert images?

Look at the library or maybe in the docuwiki then you know it

nd with OfficeWorker library??

You can contact the Author (if you reach him/get a response)

 

[Firpas]

ok, thanks for your reply