Manipulating Excel 2003 files

[KP Kirchdörfer]

Gents;

 

I'm searching for a solution to read from one and write to another Excel 2003 file.

So far I found JDBC-ODBC Bridge, the Apache POI project.

 

The latter looks pretty complicated at a first glance, the first requires to create a odbc data source for each and every file I want to access (which should be programmatically possible with JNDI..., but then it starts to be a bigger project).

 

I preferthe JDBC-ODBC-Bridge approach, cause it sounds, that it's "just another database".

But I may be misleaded.

 

Any hints how to accomplish the task?

 

thx kp

_______________________________________________
Ibm-netrexx mailing list
[hidden email]
Online Archive : http://ibm-netrexx.215625.n3.nabble.com/

[Fernando Cassia-2]

Excel to CSV and back?.

It might be brute-force, but then you will be dealing with something
NetRexx has no trouble reading, parsing and saving.

1st step: conversion
http://www.java-tips.org/other-api-tips/jexcel/converting-excel-documents-to-csv-files.html

2nd step use supercsv
http://supercsv.sourceforge.net/
"The main motivation for Super Csv is to be the best, fastest and most
programmer friendly free CSV package for Java. Super Csv's unique
features raises the bar and sets a new standard for CSV packages.
Super Csv is designed around solid Object-oriented principles, and
thus aims to leverage your Object-oriented code, making it easier to
write and maintain."

disclaimer: I never used either, but just another venue worth exploring.

FC

On Sat, Aug 6, 2011 at 16:01, KP Kirchdoerfer <[hidden email]> wrote:
> Any hints how to accomplish the task?



--
"Si, yo creo en los objetos. Inclusive más que en los seres humanos.
Creo que son más fieles ¿no?. Porque, claro, los seres humanos pueden
traicionarte, pero los objetos no, a los objetos
los traicionamos nosotros."
                                     -Manuel Mujica Laines

_______________________________________________
Ibm-netrexx mailing list
[hidden email]
Online Archive : http://ibm-netrexx.215625.n3.nabble.com/