Research Log of Web Science Students

Computer Science is not simply programming

Finally, a (probable) Solution!

with one comment

Most of you know that one part of our project is processing a spreadsheet (template for grades) and convert it to XML. We already have a solution for Excel files, which is Apache-POI. But for OpenOffice Spreadsheets (note: *.ods spreadsheets), we were feeling a little bit hopeless.

Thank God for online communities! I was browsing through a forum when I stumbled upon a person asking how to use ODS files in Java. There were some not-so-nice replies (like someone saying you can’t since ODS is an open, unusable format) and there were some gems. Yes, gems. A person referred the person asking to a site which contains a library for using ODF files in Java!

One of the links posted there redirected to the OpenOffice ODF Toolkit Project page. According to the site, the odftoolkit…

Aims to provide a home for libraries and tools that ease the development of applications that support ODF, where applications means applications in general, not just office productivity applications like

Woohoo! We’re one of those who’d be developing applications that would be supporting ODF.

The other recommendation of one of the people who replied to the thread was jOpenDocument. This one looks good as well, the guy was even kind enough to include a code (which reads/writes spreadsheets in ODS) as reference.

As for which to use between the two, well, I have to try first. Whichever is easier to work it will be the one to be used. Contest? Haha!


Written by jasetiojanco

August 26, 2009 at 9:27 am

Posted in UPS

Tagged with , , , ,

One Response

Subscribe to comments with RSS.

  1. Before the Open Document Format was used by OpenOffice, did you know that two students from DCS created an OpenOffice viewer BY parsing the XML files themselves and NOT relying on other libraries? Just a trivia.

    Just proves that if all else fails, you can ALWAYS create your own.

    Incidentally, please make sure that the libraries you are using have licenses that allow you to use it for applications for distribution and possibly, for sale.


    August 26, 2009 at 10:30 am

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: