JDBCODBC functionality -- Java to Excel for complex workbooks
Before I start with a Java to Excel project, I have one concern. It seems
that the Excel data is what is accessed. Is this true? Or are the live equation "linked" and being
accessed. I am not happy with Excel 2007, I have built a complex spreadsheet in 2003. Three linked
I want to move my spreadsheets into Java and keep Excel functionality, the Excel calculation
engine and lose the ribbon. Is this possible? The calculations are extensive.
My level of programming skills are advanced in excel/vba and novice in java/eclipse.
The Java to Excel program doesn't do much. It creates an Excel worksheet in a workbook. You
can read and write "simple" Excel tables easily -- just a header row and data rows. Anything else
through the JDBCODBC bridge won't work well. To do something more advanced, consider keeping your
workbooks and VBA macros. Look first at groovy
to invoke your VBA'S -- that shouldn't be too hard.
The other option which is more work is to use the Apache POI package to do the same thing.
This was first published in June 2008