XMerge Pocket Excel Plugin
OverviewThe Pocket Excel plugin converts between OpenOffice StarCalc XML format and Pocket Excel's binary file format. It currently supports reading and writing of files in Pocket Excel format 2.0. A zipfile containing the complete source is available. If you just want to browse the source online it is available here.
Using the Pocket Excel plugin
The Pocket Excel plugin is invoked in the same manner as all other XMerge plugins. Once the framework has been made aware of the plugin, the only thing needed to use it is to specify its MIME type as a source or destination type for conversion. The MIME type is specified in the
converter.xmlfile included in the
pexcel.jarfile. Currently, this is set to
For example, to use the Pocket Excel plugin in conjunction with the test driver supplied with the XMerge framework:
% java org.openoffice.xmerge.test.Driver -from staroffice/sxc -to x-application/x-pocket-excel Test.sxc
% java.org.openoffice.xmerge.test.Driver -from application/x-pocket-excel -to staroffice/sxc Test.pxl
FeaturesIn addition to basic text and number conversion there are two main categories of features supported in this converter. Below is a simple table outlining the two categories and the features they support.
Summary of Supported Features
+ Floating Points
|Bold, Italic, Underline|
(Horizontal & Vertical)
The second set of features supported in this converter relate to cell formatting. All the basic formatting is supported in this converter. The following is a list of these features
- Bold, Italic and Underline,
- Colour (background and foreground)
- Alignment (Horizontal & Vertical)
- Row and Column Width
- Windows freezes and Splits
ScreenShotsBelow are some screenshots to highlight the conversion capability of this filter.
StarCalc view of a spreadsheet
Pocket Excel view of the converted file
- Handling of unsupported functions
The second area are features that are not yet implemented
- Number Formatting
- Merge cells
Building the pluginThe Pocket Excel plugin is built as part of the XMerge framework. Its classes are stored in
pexcel.jar. See Building XMerge for more instructions.