As excel spreadsheets grow in complexity, organizations are forced to extend spreadsheet logic beyond a single desktop. Microsoft does not provide a Java-based API for Excel, leaving developers to puzzle over how to effectively automate and replicate spreadsheet logic in a way that fits into their Java architecture.

This white paper discusses four essential Java-based methods for automating and replicating Excel spreadsheet logic. You will explore an API-driven Java toolset that can read, write and calculate the formulas within Excel files. Discover methods for enabling developers to automatically inherit the security and scalability features associated with their J2EE application server. Learn how to incorporate these Java-based approaches into applications across a range of industries, from banking and insurance to finance.