|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.apache.poi.hssf.converter.AbstractExcelConverter org.apache.poi.hssf.converter.ExcelToFoConverter
@Beta public class ExcelToFoConverter
Converts xls files (97-2007) to XSL FO.
Field Summary |
---|
Fields inherited from class org.apache.poi.hssf.converter.AbstractExcelConverter |
---|
_formatter |
Constructor Summary | |
---|---|
ExcelToFoConverter(org.w3c.dom.Document document)
|
|
ExcelToFoConverter(FoDocumentFacade foDocumentFacade)
|
Method Summary | |
---|---|
protected java.lang.String |
createPageMaster(float tableWidthIn,
java.lang.String pageMasterName)
|
protected org.w3c.dom.Document |
getDocument()
|
float |
getPageMarginInches()
|
protected boolean |
isEmptyStyle(CellStyle cellStyle)
Returns false if cell style by itself (without text, i.e. |
static void |
main(java.lang.String[] args)
Java main() interface to interact with ExcelToFoConverter |
static org.w3c.dom.Document |
process(java.io.File xlsFile)
Converts Excel file (97-2007) into XSL FO file. |
protected boolean |
processCell(HSSFWorkbook workbook,
HSSFCell cell,
org.w3c.dom.Element tableCellElement,
int normalWidthPx,
int maxSpannedWidthPx,
float normalHeightPt)
|
protected void |
processCellStyle(HSSFWorkbook workbook,
HSSFCellStyle cellStyle,
org.w3c.dom.Element cellTarget,
org.w3c.dom.Element blockTarget)
|
protected void |
processCellStyleBorder(HSSFWorkbook workbook,
org.w3c.dom.Element cellTarget,
java.lang.String type,
short xlsBorder,
short borderColor)
|
protected void |
processCellStyleFont(HSSFWorkbook workbook,
org.w3c.dom.Element blockTarget,
HSSFFont font)
|
protected void |
processColumnHeaders(HSSFSheet sheet,
int maxSheetColumns,
org.w3c.dom.Element table)
|
protected float |
processColumnWidths(HSSFSheet sheet,
int maxSheetColumns,
org.w3c.dom.Element table)
Creates COLGROUP element with width specified for all columns. |
protected void |
processDocumentInformation(SummaryInformation summaryInformation)
|
protected int |
processRow(HSSFWorkbook workbook,
CellRangeAddress[][] mergedRanges,
HSSFRow row,
org.w3c.dom.Element tableRowElement)
|
protected org.w3c.dom.Element |
processRowNumber(HSSFRow row)
|
protected float |
processSheet(HSSFWorkbook workbook,
HSSFSheet sheet,
org.w3c.dom.Element flow)
|
protected boolean |
processSheet(HSSFWorkbook workbook,
int sheetIndex)
Process single sheet (as specified by 0-based sheet index) |
protected void |
processSheetName(HSSFSheet sheet,
org.w3c.dom.Element flow)
|
void |
processWorkbook(HSSFWorkbook workbook)
|
void |
setPageMarginInches(float pageMarginInches)
|
Methods inherited from class org.apache.poi.hssf.converter.AbstractExcelConverter |
---|
getColumnName, getColumnWidth, getDefaultColumnWidth, getFontReplacer, getRowName, isOutputColumnHeaders, isOutputHiddenColumns, isOutputHiddenRows, isOutputLeadingSpacesAsNonBreaking, isOutputRowNumbers, isTextEmpty, setFontReplacer, setOutputColumnHeaders, setOutputHiddenColumns, setOutputHiddenRows, setOutputLeadingSpacesAsNonBreaking, setOutputRowNumbers |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public ExcelToFoConverter(org.w3c.dom.Document document)
public ExcelToFoConverter(FoDocumentFacade foDocumentFacade)
Method Detail |
---|
public static void main(java.lang.String[] args)
ExcelToFoConverter
Usage: ExcelToHtmlConverter infile outfile
Where infile is an input .xls file ( Word 97-2007) which will be rendered as XSL FO into outfile
public static org.w3c.dom.Document process(java.io.File xlsFile) throws java.lang.Exception
xlsFile
- file to process
java.lang.Exception
protected java.lang.String createPageMaster(float tableWidthIn, java.lang.String pageMasterName)
protected org.w3c.dom.Document getDocument()
getDocument
in class AbstractExcelConverter
public float getPageMarginInches()
protected boolean isEmptyStyle(CellStyle cellStyle)
protected boolean processCell(HSSFWorkbook workbook, HSSFCell cell, org.w3c.dom.Element tableCellElement, int normalWidthPx, int maxSpannedWidthPx, float normalHeightPt)
protected void processCellStyle(HSSFWorkbook workbook, HSSFCellStyle cellStyle, org.w3c.dom.Element cellTarget, org.w3c.dom.Element blockTarget)
protected void processCellStyleBorder(HSSFWorkbook workbook, org.w3c.dom.Element cellTarget, java.lang.String type, short xlsBorder, short borderColor)
protected void processCellStyleFont(HSSFWorkbook workbook, org.w3c.dom.Element blockTarget, HSSFFont font)
protected void processColumnHeaders(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)
protected float processColumnWidths(HSSFSheet sheet, int maxSheetColumns, org.w3c.dom.Element table)
AbstractExcelConverter.isOutputRowNumbers()
==true)
protected void processDocumentInformation(SummaryInformation summaryInformation)
protected int processRow(HSSFWorkbook workbook, CellRangeAddress[][] mergedRanges, HSSFRow row, org.w3c.dom.Element tableRowElement)
protected org.w3c.dom.Element processRowNumber(HSSFRow row)
protected float processSheet(HSSFWorkbook workbook, HSSFSheet sheet, org.w3c.dom.Element flow)
protected boolean processSheet(HSSFWorkbook workbook, int sheetIndex)
protected void processSheetName(HSSFSheet sheet, org.w3c.dom.Element flow)
public void processWorkbook(HSSFWorkbook workbook)
public void setPageMarginInches(float pageMarginInches)
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |