ExcelAPI

Java Excel API - A Java API to read, write and modify Excel spreadsheets This is the home PaGE of Java Excel API - open source Java API which allows Java developers to read Excel spreadsheets and to generate Excel spreadsheets dynamically. In addition, it contains a mechanism which allows java applications to read in a Spreadsheet, modify some cells and write out the new spreadsheet. This API allows non Windows operating systems to run Pure Java applications which can both Process and deliver Excel spreadsheets. Because it is Java, this API may be invoked from within a servlet, thus giving access to Excel functionality over internet and intranet web applications. Features Reads data from Excel 95, 97, 2000 workbooksReads and writes formulas (Excel 97 and later only)Generates spreadsheets in Excel 2000 formatSupports font, number and date formattingSupports shading and colouring of cellsModifies existing worksheetsSupports image creationPreserves macros on copyCustomizable logging