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