Package biz.c24.io.api.presentation.stream

Various classes for stream based parsing and formatting of data objects.

See:
          Description

Class Summary
BitDataReader Bit aligned data stream reader.
BitDataWriter Bit aligned data stream writer.
BorderedCharDataReader Char data stream reader.
ByteAlignedBitDataReader Byte aligned data stream reader.
ByteAlignedBitDataWriter Byte aligned data stream writer.
DataReader Data reader abstraction layer.
SpreadSheet Spreadsheet support broker.
SpreadSheetReader SpreadSheet broker implementation for reading.
SpreadSheetWriter SpreadSheet broker implementation for writing.
 

Package biz.c24.io.api.presentation.stream Description

Various classes for stream based parsing and formatting of data objects.

SpreadSheet broker classes

Supported SpreadSheet data format

This implementation supports the data format that is supported by 3rd party tool Apache POI. So currently it is supported:

R1C1 style addressing

The addressing of cells is specified in slightly modified Microsoft® Excel® "R1C1 reference style" as described in ECMA-376. Part 4. §3.17.2.3.2. The modifications here is about using the zero based row and column offset additionally to omitting it at all. So, it is allowed 0. Also the both: row and collumn is required in address. So, it is not possible to omit either from them. The format may be exposed in following manner:
    address = [ SHEET ] ROW COLUMN
    SHEET = <string literal> "!"
    ROW = "R" [ <numeric literal> ]
    COLUMN = "C" [ <numeric literal> ]
where numeric literal is positive numeric value (including zero). It represents the offset for row and column respectively. If number is absent it is equivalent to zero. If address has the sheet, its mean that offset is starting from top-left corner of sheet (R0C0).

SpreadSheet Formula support

With aids the 3rd party tool it is possible to handle the formulas. Depends on binding type the formula may be evaluated before population or preserved as is: And vise versa for inverse process (when data object is serialized into SpreadSheet), For details please see reader and writer



C24 Technologies © 2002-2012: All Rights Reserved.