org.nuxeo.ecm.platform.groups.audit.service.acl.excel

Interface IExcelBuilder

All Known Implementing Classes:

ExcelBuilder, ExcelBuilderMultiSheet

public interface IExcelBuilder

Method Summary

Methods

Modifier and Type	Method and Description
org.apache.poi.ss.usermodel.Comment	addComment(org.apache.poi.ss.usermodel.Cell cell, String text, int row, int col, int colWidth, int rowHeight)
Collection<org.apache.poi.ss.usermodel.Sheet>	getAllSheets()
org.apache.poi.ss.usermodel.Font	getBoldFont()
org.apache.poi.hssf.util.HSSFColor	getColor(ByteColor color)
org.apache.poi.ss.usermodel.Sheet	getCurrentSheet()
int	getCurrentSheetId()
org.apache.poi.ss.usermodel.Workbook	getWorkbook()
org.apache.poi.ss.usermodel.Workbook	load(File file)
org.apache.poi.ss.usermodel.Workbook	load(String file)
int	loadPicture(String image)
void	mergeRange(int firstRow, int firstColumn, int lastRow, int lastColumn)
org.apache.poi.ss.usermodel.CellStyle	newCellStyle()
org.apache.poi.ss.usermodel.CellStyle	newColoredCellStyle(ByteColor color)
org.apache.poi.ss.usermodel.Font	newFont()
org.apache.poi.ss.usermodel.Font	newFont(int size)
int	newSheet(int index, String name)
void	save(File file)
void	save(String file)
org.apache.poi.ss.usermodel.Cell	setCell(int row, int column, String content) Set a cell text content with no styling information.
org.apache.poi.ss.usermodel.Cell	setCell(int row, int column, String content, org.apache.poi.ss.usermodel.CellStyle style) Set a cell content at the given indices, and apply the style if it is not null.
void	setColumnWidth(int column, int width) Set the width (in units of 1/256th of a character width)
void	setColumnWidthAuto(int column)
void	setCurrentSheetId(int s)
void	setFreezePane(int colSplit, int rowSplit)
void	setFreezePane(int colSplit, int rowSplit, int leftmostColumn, int topRow)
void	setPicture(int pictureIdx, int col1, int row1, boolean resize)
void	setRowHeight(int row, int height)
void	setSplitPane(int xSplitPos, int ySplitPos, int leftmostColumn, int topRow, int activePane)

Method Detail

setCell

org.apache.poi.ss.usermodel.Cell setCell(int row,
                                       int column,
                                       String content,
                                       org.apache.poi.ss.usermodel.CellStyle style)

Set a cell content at the given indices, and apply the style if it is not null. If row(i) does not exist yet, it is created, otherwise it is recycled. If cell(i,j) does not exist yet, it is created, otherwise it is recycled. Reminder: excel support a maximum of 65,536 rows and 256 columns per sheet

Parameters:

row - row index

column - column index

content - a string to display in the cell

style - a style to apply to the cell

Returns:

the created or retrieved cell in case additional stuff should be done on it.

setCell

org.apache.poi.ss.usermodel.Cell setCell(int row,
                                       int column,
                                       String content)

Set a cell text content with no styling information.

See Also:

setCell(int i, int j, String content, CellStyle style)}

getCurrentSheet

org.apache.poi.ss.usermodel.Sheet getCurrentSheet()

getAllSheets

Collection<org.apache.poi.ss.usermodel.Sheet> getAllSheets()

getCurrentSheetId

int getCurrentSheetId()

setCurrentSheetId

void setCurrentSheetId(int s)

newSheet

int newSheet(int index,
           String name)

setRowHeight

void setRowHeight(int row,
                int height)

setColumnWidth

void setColumnWidth(int column,
                  int width)

Set the width (in units of 1/256th of a character width)

setColumnWidthAuto

void setColumnWidthAuto(int column)

setFreezePane

void setFreezePane(int colSplit,
                 int rowSplit)

setFreezePane

void setFreezePane(int colSplit,
                 int rowSplit,
                 int leftmostColumn,
                 int topRow)

setSplitPane

void setSplitPane(int xSplitPos,
                int ySplitPos,
                int leftmostColumn,
                int topRow,
                int activePane)

mergeRange

void mergeRange(int firstRow,
              int firstColumn,
              int lastRow,
              int lastColumn)

addComment

org.apache.poi.ss.usermodel.Comment addComment(org.apache.poi.ss.usermodel.Cell cell,
                                             String text,
                                             int row,
                                             int col,
                                             int colWidth,
                                             int rowHeight)

newColoredCellStyle

org.apache.poi.ss.usermodel.CellStyle newColoredCellStyle(ByteColor color)

save

void save(String file)
          throws IOException

Throws:

IOException

save

void save(File file)
          throws IOException

Throws:

IOException

load

org.apache.poi.ss.usermodel.Workbook load(String file)
                                          throws org.apache.poi.openxml4j.exceptions.InvalidFormatException,
                                                 IOException

Throws:

org.apache.poi.openxml4j.exceptions.InvalidFormatException

IOException

load

org.apache.poi.ss.usermodel.Workbook load(File file)
                                          throws org.apache.poi.openxml4j.exceptions.InvalidFormatException,
                                                 IOException

Throws:

org.apache.poi.openxml4j.exceptions.InvalidFormatException

IOException

newFont

org.apache.poi.ss.usermodel.Font newFont(int size)

newFont

org.apache.poi.ss.usermodel.Font newFont()

getBoldFont

org.apache.poi.ss.usermodel.Font getBoldFont()

newCellStyle

org.apache.poi.ss.usermodel.CellStyle newCellStyle()

getWorkbook

org.apache.poi.ss.usermodel.Workbook getWorkbook()

getColor

org.apache.poi.hssf.util.HSSFColor getColor(ByteColor color)

loadPicture

int loadPicture(String image)
                throws IOException

Throws:

IOException

setPicture

void setPicture(int pictureIdx,
              int col1,
              int row1,
              boolean resize)