jxl.demo
Class Write

java.lang.Object
  |
  +--jxl.demo.Write

public class Write
extends java.lang.Object

Demo class which writes a spreadsheet. This demo illustrates most of the features of the JExcelAPI, such as text, numbers, fonts, number formats and date formats


Field Summary
private  java.lang.String filename
          The filename
 
Constructor Summary
Write(java.lang.String fn)
          Constructor
 
Method Summary
 void write()
          Uses the JExcelAPI to create a spreadsheet
private  void writeBordersSheet(WritableSheet s)
          Adds cells to the specified sheet which test the various border styles
private  void writeDateFormatSheet(WritableSheet s)
          Adds cells to the specified sheet which test the various date formats
private  void writeFormulaSheet(WritableSheet ws)
          Test out the formula parser
private  void writeLabelFormatSheet(WritableSheet s1)
          Adds cells to the specified sheet which test the various label formatting styles, such as different fonts, different sizes and bold, underline etc.
private  void writeLabelsSheet(WritableSheet ws)
          Write out loads of labels, in order to test the shared string table
private  void writeNumberFormatSheet(WritableSheet s)
          Writes out a sheet containing the various numerical formats
 
Methods inherited from class java.lang.Object
, clone, equals, finalize, getClass, hashCode, notify, notifyAll, registerNatives, toString, wait, wait, wait
 

Field Detail

filename

private java.lang.String filename
The filename
Constructor Detail

Write

public Write(java.lang.String fn)
Constructor
Parameters:
fn -  
Method Detail

write

public void write()
           throws java.io.IOException,
                  WriteException
Uses the JExcelAPI to create a spreadsheet
Throws:
java.io.IOException -  
WriteException -  

writeNumberFormatSheet

private void writeNumberFormatSheet(WritableSheet s)
                             throws WriteException
Writes out a sheet containing the various numerical formats
Parameters:
s -  

writeDateFormatSheet

private void writeDateFormatSheet(WritableSheet s)
                           throws WriteException
Adds cells to the specified sheet which test the various date formats
Parameters:
s -  

writeLabelFormatSheet

private void writeLabelFormatSheet(WritableSheet s1)
                            throws WriteException
Adds cells to the specified sheet which test the various label formatting styles, such as different fonts, different sizes and bold, underline etc.
Parameters:
s1 -  

writeBordersSheet

private void writeBordersSheet(WritableSheet s)
                        throws WriteException
Adds cells to the specified sheet which test the various border styles
Parameters:
s -  

writeLabelsSheet

private void writeLabelsSheet(WritableSheet ws)
                       throws WriteException
Write out loads of labels, in order to test the shared string table

writeFormulaSheet

private void writeFormulaSheet(WritableSheet ws)
                        throws WriteException
Test out the formula parser