Package org.apache.poi.hssf.converter
Class ExcelToHtmlConverter
- java.lang.Object
-
- org.apache.poi.hssf.converter.AbstractExcelConverter
-
- org.apache.poi.hssf.converter.ExcelToHtmlConverter
-
@Beta public class ExcelToHtmlConverter extends AbstractExcelConverter
Converts xls files (97-2007) to HTML file.
-
-
Constructor Summary
Constructors Constructor Description ExcelToHtmlConverter(HtmlDocumentFacade htmlDocumentFacade)
ExcelToHtmlConverter(Document doc)
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description String
getCssClassPrefixCell()
String
getCssClassPrefixDiv()
String
getCssClassPrefixRow()
String
getCssClassPrefixTable()
Document
getDocument()
boolean
isUseDivsToSpan()
static void
main(String[] args)
Java main() interface to interact withExcelToHtmlConverter
static Document
process(File xlsFile)
Converts Excel file (97-2007) into HTML file.static Document
process(InputStream xlsStream)
Converts Excel file (97-2007) into HTML file.static Document
process(HSSFWorkbook workbook)
Converts Excel file (97-2007) into HTML file.void
processWorkbook(HSSFWorkbook workbook)
void
setCssClassPrefixCell(String cssClassPrefixCell)
void
setCssClassPrefixDiv(String cssClassPrefixDiv)
void
setCssClassPrefixRow(String cssClassPrefixRow)
void
setCssClassPrefixTable(String cssClassPrefixTable)
void
setUseDivsToSpan(boolean useDivsToSpan)
Allows converter to wrap content into two additional DIVs with tricky styles, so it will wrap across empty cells (like in Excel).-
Methods inherited from class org.apache.poi.hssf.converter.AbstractExcelConverter
getFontReplacer, isOutputColumnHeaders, isOutputHiddenColumns, isOutputHiddenRows, isOutputLeadingSpacesAsNonBreaking, isOutputRowNumbers, setFontReplacer, setOutputColumnHeaders, setOutputHiddenColumns, setOutputHiddenRows, setOutputLeadingSpacesAsNonBreaking, setOutputRowNumbers
-
-
-
-
Constructor Detail
-
ExcelToHtmlConverter
public ExcelToHtmlConverter(Document doc)
-
ExcelToHtmlConverter
public ExcelToHtmlConverter(HtmlDocumentFacade htmlDocumentFacade)
-
-
Method Detail
-
main
public static void main(String[] args) throws Exception
Java main() interface to interact withExcelToHtmlConverter
Usage: ExcelToHtmlConverter infile outfile
Where infile is an input .xls file ( Word 97-2007) which will be rendered as HTML into outfile- Throws:
Exception
-
process
public static Document process(File xlsFile) throws IOException, ParserConfigurationException
Converts Excel file (97-2007) into HTML file.- Parameters:
xlsFile
- workbook file to process- Returns:
- DOM representation of result HTML
- Throws:
IOException
- If an error occurs reading or writing filesParserConfigurationException
- If configuration is incorrect
-
process
public static Document process(InputStream xlsStream) throws IOException, ParserConfigurationException
Converts Excel file (97-2007) into HTML file.- Parameters:
xlsStream
- workbook stream to process- Returns:
- DOM representation of result HTML
- Throws:
IOException
- If an error occurs reading or writing filesParserConfigurationException
- If configuration is incorrect
-
process
public static Document process(HSSFWorkbook workbook) throws IOException, ParserConfigurationException
Converts Excel file (97-2007) into HTML file.- Parameters:
workbook
- workbook instance to process- Returns:
- DOM representation of result HTML
- Throws:
IOException
- If an error occurs reading or writing filesParserConfigurationException
- If configuration is incorrect
-
getCssClassPrefixCell
public String getCssClassPrefixCell()
-
getCssClassPrefixDiv
public String getCssClassPrefixDiv()
-
getCssClassPrefixRow
public String getCssClassPrefixRow()
-
getCssClassPrefixTable
public String getCssClassPrefixTable()
-
getDocument
public Document getDocument()
-
isUseDivsToSpan
public boolean isUseDivsToSpan()
-
processWorkbook
public void processWorkbook(HSSFWorkbook workbook)
-
setCssClassPrefixCell
public void setCssClassPrefixCell(String cssClassPrefixCell)
-
setCssClassPrefixDiv
public void setCssClassPrefixDiv(String cssClassPrefixDiv)
-
setCssClassPrefixRow
public void setCssClassPrefixRow(String cssClassPrefixRow)
-
setCssClassPrefixTable
public void setCssClassPrefixTable(String cssClassPrefixTable)
-
setUseDivsToSpan
public void setUseDivsToSpan(boolean useDivsToSpan)
Allows converter to wrap content into two additional DIVs with tricky styles, so it will wrap across empty cells (like in Excel).Warning: after enabling this mode do not serialize result HTML with INDENT=YES option, because line breaks will make additional (unwanted) changes
-
-