S Sinimon Member Jan 16, 2012 #1 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?
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?
Kiffi Well-Known Member Licensed User Longtime User Jan 17, 2012 #3 Sinimon said: Do anyone have an idea? Click to expand... just test it by yourself. The library contains a sample-code. Greetings ... Kiffi Upvote 0
Sinimon said: Do anyone have an idea? Click to expand... just test it by yourself. The library contains a sample-code. Greetings ... Kiffi
S Sinimon Member Jan 17, 2012 #4 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
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 :-(
S Sinimon Member Jan 17, 2012 #5 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
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 B4X founder Staff member Licensed User Longtime User Jan 17, 2012 #6 For some reason you appear as an unlicensed user in the forum. Please contact [email protected] in order to fix it. Upvote 0
For some reason you appear as an unlicensed user in the forum. Please contact [email protected] in order to fix it.
peacemaker Expert Licensed User Longtime User Mar 17, 2012 #7 Seems, there is no method for getting an existing WorkBook and getting cell's value from a row. Last edited: Mar 17, 2012 Upvote 0
S szaldapetree New Member Licensed User Longtime User Mar 19, 2012 #8 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
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.
F Firpas Active Member Licensed User Longtime User Jan 14, 2015 #9 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 Upvote 0
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
F Firpas Active Member Licensed User Longtime User Jan 14, 2015 #11 Thanks With Excel lib, is posible insert images?? And with OfficeWorker library?? Upvote 0
DonManfred Expert Licensed User Longtime User Jan 14, 2015 #12 Firpas said: With Excel lib, is posible insert images? Click to expand... Look at the library or maybe in the docuwiki then you know it Firpas said: nd with OfficeWorker library?? Click to expand... You can contact the Author (if you reach him/get a response) Upvote 0
Firpas said: With Excel lib, is posible insert images? Click to expand... Look at the library or maybe in the docuwiki then you know it Firpas said: nd with OfficeWorker library?? Click to expand... You can contact the Author (if you reach him/get a response)
F Firpas Active Member Licensed User Longtime User Jan 16, 2015 #13 ok, thanks for your reply Upvote 0