Writing ods files?

Hi,

I'm working on a Java application that can export its data
in a spreadsheet format. My client is the Canadian
government, and though they're slow to show any interest in
ODF, I'd like to be a bit forward thinking and allow the
data to be exported in ODS format.

The data is simple - just numbers and text, no formulas or
formatting (though I do need to be able to create several
worksheets in each document). Is the odf4j library yet
capable of creating simple ODS docs?

If so, do I need to register as a project member in order to
get the source code?

Thanks,

Michael Davis
Software Developer (on contract)
Publiservice
Telephone | Téléphone 613-949-0446
47 Clarence St, Ottawa
Service Canada
Government of Canada | Gouvernement du Canada
 

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeodftoolkit.openoffice.org
For additional commands, e-mail: dev-helpodftoolkit.openoffice.org

If multiple worksheets were not a problem you could just
write an HTML
table.  Rename this text file with *.xls, and EXCEL will
read it.  An
old trick, but it has put out many a report ...

I never checked to see if Open Office reads HTML tables in
the same
way, perhaps I should.
--- Michael.Davisservicecanada.gc.ca wrote:

> Hi,
> 
> I'm working on a Java application that can export its
data in a
> spreadsheet format. My client is the Canadian
government, and though
> they're slow to show any interest in ODF, I'd like to
be a bit
> forward thinking and allow the data to be exported in
ODS format.
> 
> The data is simple - just numbers and text, no formulas
or formatting
> (though I do need to be able to create several
worksheets in each
> document). Is the odf4j library yet capable of creating
simple ODS
> docs?
> 
> If so, do I need to register as a project member in
order to get the
> source code?
> 
> Thanks,
> 
> Michael Davis
> Software Developer (on contract)
> Publiservice
> Telephone | Téléphone 613-949-0446
> 47 Clarence St, Ottawa
> Service Canada
> Government of Canada | Gouvernement du Canada
>  
> 
>
------------------------------------------------------------
---------
> To unsubscribe, e-mail: dev-unsubscribeodftoolkit.openoffice.org
> For additional commands, e-mail: dev-helpodftoolkit.openoffice.org
> 
> 



       
____________________________________________________________
________________________
Choose the right car based on your needs.  Check out Yahoo!
Autos new Car Finder tool.
http://autos.yahoo.
com/carfinder/

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeodftoolkit.openoffice.org
For additional commands, e-mail: dev-helpodftoolkit.openoffice.org

Hi there,
in my application, I do export data into ISO-ODF format
already.
Several months ago I created a simple library that can work
on ODS
documents, however it is still experimental.
The idea is to provide to it some existing document (it
might be
blank, for example blank-template.odf) and my mini library
builds
model by parsing content.xml DOM.

I was using it only for simple cases, it works but I have
some trouble
with - for example, when I export numeric data, I cannot
force it to
keep formating style for newly created cells, but maybe it
is not so
hard to correct. I wanted to correct this, but did not have
time
enough.

I can share it with you, maybe you will find solution or you
enhance
it somehow and share it with me 

The project is in attachment. It is created in NetBeans
5.5.1, but if
you use another IDE, it will be simple to import. If you
launch Main
class, it will use test.ods and create simple document.

Regards,
Witold Szczerba

2007/8/28, Michael.Davisservicecanada.gc.ca
<Michael.Davisservicecanada.gc.ca>:
> Hi,
>
> I'm working on a Java application that can export its
data in a spreadsheet format. My client is the Canadian
government, and though they're slow to show any interest in
ODF, I'd like to be a bit forward thinking and allow the
data to be exported in ODS format.
>
> The data is simple - just numbers and text, no formulas
or formatting (though I do need to be able to create several
worksheets in each document). Is the odf4j library yet
capable of creating simple ODS docs?
>
> If so, do I need to register as a project member in
order to get the source code?
>
> Thanks,
>
> Michael Davis
> Software Developer (on contract)
> Publiservice
> Telephone | Téléphone 613-949-0446
> 47 Clarence St, Ottawa
> Service Canada
> Government of Canada | Gouvernement du Canada
>
>
>
------------------------------------------------------------
---------
> To unsubscribe, e-mail: dev-unsubscribeodftoolkit.openoffice.org
> For additional commands, e-mail: dev-helpodftoolkit.openoffice.org
>
>
------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeodftoolkit.openoffice.org
For additional commands, e-mail: dev-helpodftoolkit.openoffice.org

Hello Witold Szczerba,


On 8/29/07, Witold Szczerba <pljosh.mailgmail.com> wrote:
> Hi there,
> in my application, I do export data into ISO-ODF format
already.
> Several months ago I created a simple library that can
work on ODS
> documents, however it is still experimental.
> The idea is to provide to it some existing document (it
might be
> blank, for example blank-template.odf) and my mini
library builds
> model by parsing content.xml DOM.
>
> I was using it only for simple cases, it works but I
have some trouble
> with - for example, when I export numeric data, I
cannot force it to
> keep formating style for newly created cells, but maybe
it is not so
> hard to correct. I wanted to correct this, but did not
have time
> enough.
>
> I can share it with you, maybe you will find solution
or you enhance
> it somehow and share it with me 
>
> The project is in attachment. It is created in NetBeans
5.5.1, but if
> you use another IDE, it will be simple to import. If
you launch Main
> class, it will use test.ods and create simple
document.

Sounds good. I plan to look at your project. By the way, why
dont you
start contributing to the "odf4j" project? You can
contribute to the
development of libraries to handle ODS documents.

Visit, http://odftoolkit.op
enoffice.org

Thanks
-- 
Amit krishna Saha
[URL]:http://amitsaha.in
.googlepages.com

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeodftoolkit.openoffice.org
For additional commands, e-mail: dev-helpodftoolkit.openoffice.org

Hello,

Great to hear from you.

For the purpose of odf4j you can contact either Lars
Oppermann, Bernd
Eilers or the project leader Dieter Loeschky, who are all
available
here on this list.

Do write in here with your ideas whenever you have some
time!

Thanks
-- 
Amit krishna Saha
[URL]:http://amitsaha.in
.googlepages.com

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeodftoolkit.openoffice.org
For additional commands, e-mail: dev-helpodftoolkit.openoffice.org

Hi,

I downloaded the source and tried to create a document. It
did create a document, with a worksheet called
"sheet1", but all the cells were empty in it. Did
I make a mistake in the code, or is the odf4j functionality
still incomplete?

the source is below.

Many thanks,
Michael Davis

    SpreadsheetDocument doc = new SpreadsheetDocument();
    DefaultTableModel model = new DefaultTableModel();
    
    Vector row = new Vector();
    row.add( "foo" );
    row.add( new Integer( 1 ) );
    model.addRow( row );
        
    doc.addSpreadsheet( "sheet1", model, false );
    
    doc.save( "test.ods" );
    doc.close();
 

> -----Original Message-----
> From: Michael.Davisservicecanada.gc.ca
> [mailto:Michael.Davisservicecanada.gc.ca]
> Sent: Tuesday, August 28, 2007 5:25 PM
> To: devodftoolkit.openoffice.org
> Subject: [odftk-dev] Writing ods files?
> 
> 
> Hi,
> 
> I'm working on a Java application that can export its
data in 
> a spreadsheet format. My client is the Canadian
government, 
> and though they're slow to show any interest in ODF,
I'd like 
> to be a bit forward thinking and allow the data to be 
> exported in ODS format.
> 
> The data is simple - just numbers and text, no formulas
or 
> formatting (though I do need to be able to create
several 
> worksheets in each document). Is the odf4j library yet

> capable of creating simple ODS docs?
> 
> If so, do I need to register as a project member in
order to 
> get the source code?
> 
> Thanks,
> 
> Michael Davis
> Software Developer (on contract)
> Publiservice
> Telephone | Téléphone 613-949-0446
> 47 Clarence St, Ottawa
> Service Canada
> Government of Canada | Gouvernement du Canada
>  
> 
>
------------------------------------------------------------
---------
> To unsubscribe, e-mail: dev-unsubscribeodftoolkit.openoffice.org
> For additional commands, e-mail: dev-helpodftoolkit.openoffice.org
> 
> 

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeodftoolkit.openoffice.org
For additional commands, e-mail: dev-helpodftoolkit.openoffice.org