org.dhatim.fastexcel

Class Worksheet

java.lang.Object

org.dhatim.fastexcel.Worksheet

public class Worksheet
extends Object

A worksheet is a set of cells.

Method Summary

Modifier and Type	Method and Description
void	finish() Finish the construction of this worksheet.
void	formula(int r, int c, String expression) Set the cell formula at the given coordinates.
String	getName() Get worksheet name.
Workbook	getWorkbook() Get parent workbook.
Range	range(int top, int left, int bottom, int right) Create a new range of cells.
StyleSetter	style(int r, int c) Get a new style setter for a cell.
Object	value(int r, int c) Get the cell value (or formula) at the given coordinates.
void	value(int r, int c, Object value) Set the cell value at the given coordinates.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

getName

public String getName()

Get worksheet name.

Returns:

Worksheet name.

getWorkbook

public Workbook getWorkbook()

Get parent workbook.

Returns:

Parent workbook.

value

public void value(int r,
                  int c,
                  Object value)

Set the cell value at the given coordinates.

Parameters:

r - Zero-based row number.

c - Zero-based column number.

value - Cell value. Supported types are String, Date, ZonedDateTime. Note Excel timestamps do not carry any timezone information; Date values are converted to an Excel serial number with the system timezone. If you need a specific timezone, prefer passing a ZonedDateTime. and Number implementations.

value

public Object value(int r,
                    int c)

Get the cell value (or formula) at the given coordinates.

Parameters:

r - Zero-based row number.

c - Zero-based column number.

Returns:

Cell value (or Formula).

formula

public void formula(int r,
                    int c,
                    String expression)

Set the cell formula at the given coordinates.

Parameters:

r - Zero-based row number.

c - Zero-based column number.

expression - Cell formula expression.

style

public StyleSetter style(int r,
                         int c)

Get a new style setter for a cell.

Parameters:

r - Zero-based row number.

c - Zero-based column number.

Returns:

Newly created style setter.

range

public Range range(int top,
                   int left,
                   int bottom,
                   int right)

Create a new range of cells. Note coordinates are reordered if necessary to make sure top <= bottom and left <= right.

Parameters:

top - Top row.

left - Left column.

bottom - Bottom row.

right - Right column.

Returns:

Newly created range.

finish

public void finish()
            throws IOException

Finish the construction of this worksheet.

Throws:

IOException - If an I/O error occurs.