Can we create .sod programitcally?

[skaviman]

Hi,
I am new to espreadsheet. I have requirement that user provides the attribute of spreadsheet in screen and then we have to generate the report.
Can we create the .sod programitcally?

Can someone help me.....Please

Thanks
Sandip

[vdodson]

Hi Sandip,

Yes, you can dynamically create either the XLS file... or spreadsheet design file (SOD) directly with the e.Spreadsheet Engine APIs. There is more information at Spreadsheet Reporting - BIRT Wiki - BIRT Exchange

[skaviman]

Thanks Virgil.

Correct me if I am wrong

this is the way you do the same...

doc.fileSaveAs(new java.io.File("path/filename"), DocumentType.ACTUATE_9_WORKBOOK, new DocumentSaveCallback());.

right, ofcourse, you have other ways to...

Also I have another question, if I generate the report with .sod, can users update the values of the generated report, which I woulld like to save in the database?


Thanks again for your great help.

Sandip

[rmurphy]

There is nothing in e.Spreadsheet that will automatically write values back to a database. However, this can be accomplished in a variety of ways depending on your applicaiton. If you are delivering an XLS file to your users, you could pass through a VB Macro that would make calls back to a server which would update values based on users actions. The following DevShare post describes passing VB Macros through to a XLS file.

Including VBA functionality in e.spreadsheet report - Tips & Tricks - BIRT Exchange

You could also allow your users to upload their XLS file and use e.Spreadsheet to parse the file and programmatically update the database.

If you are using e.Spreadsheet in a Java GUI applicaiton, you can capture Java Events (i.e. start edit, end edit, etc) and programmatically update the database.

Rob

[skaviman]

Thanks Rob,

We are using J2EE so we should be able to capture the events.

Thanks again.

[rmurphy]

Sandip,
The events I was referring to are Java AWT/Swing events. Not J2EE based events such as JMS.

Rob