Home > Ask the AS/400 Experts > iSeries Web Development Questions & Answers > JDBCODBC functionality -- Java to Excel for complex workbooks
Ask The iSeries 400 Expert: Questions & Answers
EMAIL THIS

JDBCODBC functionality -- Java to Excel for complex workbooks

Jim Mason EXPERT RESPONSE FROM: Jim Mason

Pose a Question
Other iSeries 400 Categories
Meet all iSeries 400 Experts
Become an Expert for this site


iSeries news and advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 14 May 2008
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.



Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
iSeries Web Development
Accessing AS/400 data using Excel ODBC drivers
IBM WebSphere Studio Application Developer error
Database pooling on iSeries
Connecting WebSphere to AS/400 for image retrieval
Retrieving the value selected by a user
Condense ILE service program procedures
WebSphere error during login process
Connecting WebSphere to a DB2 database
WebFacing error: User ID or password invalid
Starting Dominos on a Windows 2000 server

iSeries Java programming
Groovy programming on IBM i
EGL Rich UI on IBM i: Do you Dojo?
Programming for the Web on the IBM i, what is possible
Database performance comparisons on IBM i
Database drivers on the i: MySQL vs. IBM Toolbox
How to: Output SQL script to a text file from an AS/400
Application modernization for the iSeries: Why bother?
Necessity leads to iSeries Watchdog development
Accessing AS/400 data using Excel ODBC drivers
Top 10 System i white papers
iSeries Java programming Research

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


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.




Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



iSeries Networking - Printing, Remote Access, TCP/IP
HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy 		  TechTarget - The IT Media ROI Experts