B4A Library OfficeWorker - Create office docs!

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:

        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]

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

 

[XverhelstX]

I'm in my last year computer science ("informaticabeheer" in dutch). (High school)
Tomorrow I have religion :BangHead:

Tomas

 

[Amalkotey]

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, 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.

Thanks ;D
I wish you also success on the certification.

Tomas

 

[Erel]

Thank you for sharing!

 

[XverhelstX]

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.

 

[Erel]

I'm not a lawyer. Based on my understanding you can use it commercially and only need to redistribute the Notice.txt file that comes with the project. This is not really practical in an Android application. I think that specifying in the About box that you are using project x should be enough.

 

[vb1992]

How would I output to PowerPoint with this?

 

[XverhelstX]

Only excel is supported yet.

Tomas

Sent from my SE Xperia Play using Tapatalk.

 

[ashchopra]

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]

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]

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?

 

[peacemaker]

is cell font size changeable here ?

 

[peacemaker]

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.

 

[XverhelstX]

Unfortunately, i'm not working on this library anymore for now.
I might update this in the feature. I'm working on a bigger project atm.
If anyone is interested in the source code, please contact me.

Kind regards,
Tomas

 

[peacemaker]

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

 

[McDomFr]

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]

Seems, for formula no ValueAsFormula method available also.

 

[peacemaker]

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