Extentech Inc. RSS Feeds powered by Sheetster Server

Closed Requests: RESOLVED: Add ability to specify Chart Axis Placement

It is useful in certain situations to be able to specify the placement of an axis.

Closed Requests: Cell Validations

Includes improved support for creating ValidationHandles in ExtenXLS.

Closed Requests: COMPLETED: Add worksheet level scope handling to Named Ranges

Currently ExtenXLS does not differentiate between workbook and worksheet scoped named ranges.

Handling has been requested by Zoltan G. to utilize this functionality.

Initial glance at code indicates we will want to add a setScope/getScope() method to NameHandle, along with a method to get Scoped names only from a Worksheet. We may want a method to get all NameHandles that refer to a particular worksheet, as well as one that only returns explicity scoped ones.

I'd advise testing after at the workbook level as well, and verifying that getNamedRanges() does in fact return all named ranges.

Closed Requests: Support for Excel Comments

The ability to read and write Excel cell comments using the CellHandle class.

Closed Requests: Encrypted Spreadsheets

Various prospective customers have requested support for loading encrypted workbooks.

Closed Requests: Windows 7 Support for OpenXLS

Add Windows 7 support for OpenXLS

Closed Requests: Ability to address columns > 256

This is a sub-task of OOXML/XLSX support.

This will entail:

refactor MAX_ROWS and MAX_COLS to be compatible with XLSX/OOXML new higher limits.

This will entail changing calls to those static ints to method calls that return appropriate limit based on a workbook level compatibility-mode setting.

It will break:

column references in ExcelTools
PtgRefs
short-based row nums
memory usage with huge files

Some advantages of the new handling:

Increased support for 'spreadsheet as database' use case
sheet-level loading: this will be critical as we handle larger OOXML files as memory consumption will skyrocket in some use cases.
potential ability to dispense with many byte-saving nonsense BIFF8 internals such as "DBCELL"
in 'compatibility-mode', ExtenXLS will retain the XLS format and limits, then when in 'normal' mode it will use OOXML limits and filesystem to read/write sheets on the fly.

Closed Requests: Search for Cells by Pattern

Add a WorkBookHandle method like:

/** search for cells by pattern */ 
public CellHandle[] getCellsByPattern(String regexp){ }

Closed Requests: Support for XLSX (Office Open XML) Spreadsheet Files

ExtenXLS 7.0 will feature initial support of the XLSX file format. For more information on XLSX and the Office Open XML formats, please see the following:

http://en.wikipedia.org/wiki/.xlsx

http://office.microsoft.com/en-us/help/HA100069351033.aspx

http://www.ecma-international.org/publications/standards/Ecma-376.htm

Closed Requests: Excel 2007 Support

The newest version of ExtenXLS supports basic Excel 2007 features. We can successfully process VBA Macros, ActiveX, OLEObject, as well as most formulas, named ranges, etc.

Below is a list of features still in development or known issues:

Array formulas are not yet handled
Higher row and column limits not yet supported
External references in the workbook, formulas and named ranges are not yet handled
Many chart options and types are not yet handled and many complex series is not able to be parsed correctly
Certain images are not processed correctly, and we are unable to process EMF images at this time
Conditional Formatting and Data Validations are not yet handled
Headers/Footers, Page Margins, etc., are not yet handled
Custom properties are not yet handled
Tables and data tables are not yet handled
Drawing shapes are handled to varying degrees.

Known Issues:

There are two known outstanding formula issues - one due to non-standard shared formula movement, the other due to complex formula string parsing
Formats (Styles) are often not correct, from number formats to background colors. Sometimes Excel 2007 will report "Records Repaired: Formats from Styles.xml" upon open. 3- There are literally hundreds of miscellaneous OOXML options that will be added as time goes on. Please alert us to anything that is missing and we will add it to our list.

Closed Requests: Ability to import/read CSV files into ExtenXLS

Add the ability to read in CSV files into ExtenXLS which will import the data into a new sheet.