A Java library for reading/writing Excel

File Release Notes and Changelog

Release Name: 2.6.1

Notes:
When reading in headers/footers, handled the case where the format string doesn't contain any alignment tags
If a cell is read in which exceeds the boundaries defined in the Dimension record, then the sheet is resized and the cells added (prior to this fix a warning would be displayed and the cell discarded)
Fixed the copyTo method when copying cells with data validation
Added the method Workbook.importSheet to import a sheet from another readable workbook (so you can merge spreadsheets together). Unfortunately, charts are not yet supported with this mechanism
Enabled the SEARCH function when parsing formulas
Used Date.SHORT and Date.MEDIUM within the built in formats, which should pick up the Locale specific date formats
Added the ability to remove a named range
Did a deep copy of the column formats on the copySheet method (instead of just passing across the reference)
Added the Used Attributes to the XF Record
Included the struckout flag in the Font copy constructor
Added support for column autosizing (although this will be very processor intensive)
Added support for page break preview mode via the SheetSettings bean
Handled shared string formulas which evaluated to an empty string
More tinkering with sheet name rendering in formulas. Moved all the sheet name functionality for escaping apostrophes and adding quotes around the sheet name into WorkbookParser
Fixed a bug in the data validation where it was ignoring the DVAL record in certain circumstances
Fixed a bug in findCellByName so that it retrieves based on the external sheet index
Provided access to some of the image details, such native dimensions, resolution and an approximate calculation within Excel
Supplied a SharedBooleanFormulaRecord 

Changes: