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 workbooks in fact.
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 COM interface
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