B4A Library OfficeWorker - Create office docs!

XverhelstX

Well-Known Member
Licensed User
Hello everyone!

I'm proud to release the alpha version of OfficeWorker!
With OfficeWorker, you will be able to create your own Excel, PowerPoint, Word, Visio, Outlook and Publisher files.

Currently OfficeWorker is in alpha stage.
It now only include HSSF Excel files. (.xls).

These are the following functions:

B4X:
        Dim EW As ExcelWorker
   Dim Wb As ExcelHSSFWorkbooks
   Dim Sheet1 As ExcelSheets
   Dim Row1, Row2 As ExcelRows
   Dim Cell1, Cell2 As ExcelCells
   Dim CS, CS2 As ExcelCellStyles
   Dim Color As ExcelColors
   Dim Fonts As ExcelFonts
You can create your own sheets, give style to cells, save, etc.
I'm releasing it now, cause it needs some debugging.

Please let me know what you think of it so far.
Link include:
- Library files ( POI3.7.jar and OfficeWorker.jar)
- Sample file
- ReadMe (don't forget to read).

3.5 mb
Download here.

Note that I am currently in my exam period and won't be able to be online much till next friday.

Have fun.

Tomas
 

Amalkotey

Active Member
Licensed User
Note that I am currently in my exam period and won't be able to be online much till next friday.

Hello Tomas,

What an examination completing you?

best regards
Amalkotey
 

Amalkotey

Active Member
Licensed User
Well, I wish you for tomorrow much success. I provide me as a SAP APAP/4 developer (consultant) before. The certification will take place on the 02/10/2012. I am nevertheless stressed.
 

XverhelstX

Well-Known Member
Licensed User
Thanks Erel, i still have a question though. What exactly is meant with the Apache License? Are you able to use this in a commercial library? Do i have to add the source code or something? I read it on wiki, but i don't understand it completely.

Tomas

Sent from my SE Xperia Play using Tapatalk.
 

ashchopra

Member
Licensed User
Office Worker Completion

Hi XverhelstX
Any update to the Alpha version !!
Dying to see a mature library to handle excel files and then the rest of the MsOffice Docs !! :)
 

Sinimon

Member
Hey really nice that there is a way to work with excel files. but can you tell me how to read a single cell like x:3 , y:2 ? i can not find a way to do it.. :(
 

peacemaker

Expert
Licensed User
Seems, only BooleanCellValue method is available to get cell's value :-(

EW.Initialize("EW")
EW.readFileAsExcel(Folder, Name & ".xls")


Wb...... 'how to get existing WB ?

Sheet1.sheet = Wb.getSheet("1")
Row1.row = Sheet1.getRow(0)
Cell1.cell = Row1.getCell(1)
Cell1..... How to get other value?
 
Last edited:

peacemaker

Expert
Licensed User
1) ExcelFonts object exists, but seems, no method to initialize it to manipulate by font, fontsize...
2) ExcelColors: only 3 colors exist :-(

Dear author, is it possible to update the lib just to use it with currently existing objects, but at least fully functional, if they exist ?

I mean, add some colors, allow font usage...
I see, that opening XLS is not possible, but if it's published to write XLS - please, let it make it well.
 

peacemaker

Expert
Licensed User
Dear library developers,
Maybe any could edit XverhelstX's sources to use fontsize of ExcelFonts object ?
 

McDomFr

New Member
Licensed User
Formula

Hi,
is it possible to set a cell as a formula ?

i'm using
Cell1.createCell(4)
Cell1.ValueAsString = "=A2*D2"

but it become a value not a formula.
I tryed to find a way using the ExcelcellStyles but i didn't find.

thanks.
br
 

peacemaker

Expert
Licensed User
Seems, for formula no ValueAsFormula method available also.
 

peacemaker

Expert
Licensed User
No news ?
Any Java developer to help with XverhelstX's XLS lib (several methods mentioned above in this thread)?
 
Top