Home >Web Front-end >HTML Tutorial >Convert Excel to Html Excel preview_html/css_WEB-ITnose
Convert Excel to Html Excel preview_html/css_WEB-ITnose
- WBOYOriginal
- 2016-06-24 11:44:411361browse
Based on the Poi demo, the effect is pretty good. Let me share it with you. Let’s take a look at the effect first.
The effect is basically the same, here is how to do it
1. Processing of merged cells
/**
* Process the merged cells according to the merged output content
* @param formatAsString
*/
private void handlerMergedString(String formatAsString) {
String[] strArr = formatAsString.split( ":" );
int startCol = strArr[0].charAt(0) - 65;
int endCol = strArr[1].charAt(0) - 65;int endRol = Integer.valueOf(strArr[1].substring(1));
mergedCache. put(startRol "_" startCol, new Integer[] { endRol - startRol 1,
endCol - startCol 1});
for (int i = startRol; i <= endRol; i ) {
for (int j = startCol; j <= endCol; j ) {
notNeedCread.add(i "_" j);
}
}
notNeedCread.remove(startRol "_" startCol);
}
Store the merged cells of the entire sheet, and then conveniently When you decide, just write rowspan and colsopan for td, which is relatively simple
2. CSS settings
private void styleContents(CellStyle style) {
if (style.getAlignment() != 2) {
styleOut( "text-align" , style.getAlignment(), ALIGN );
styleOut( "vertical-align" , style.getAlignment(), VERTICAL_ALIGN);
}
}
private void fontStyle(Font font) {
if (font.getBoldweight() >=Font.BOLDWEIGHT_BOLD)
out.format( " font-weight: bold;%n" );
if (font.getItalic())
out.format( " font-style: italic;%n" );
out.format( " font-family: %s;%n" , font.getFontName());
int fontheight = font.getFontHeightInPoints();
if (fontheight == 9) {
fontheight = 10;
}
out.format( " font-size: %dpt;%n" , fontheight);
helper.styleColor(out, "color" , getColor(font));
}
Get the value from cellStyle, and then fill it in the css, already font css, this concept needs to be distinguished between font and style because of the complex units behind it The font needs to be set iteratively. In addition,
There are many different things in version 03 and 07, which need to be set separately
3. Obtaining the value--more important and complex
public String getHtmlValue(Cell cell) {
if (Cell.CELL_TYPE_BOOLEAN == cell.getCellType()
|| Cell.CELL_TY PE_NUMERIC = = cell.getCellType()) {
cell.setCellType(Cell.CELL_TYPE_STRING);
return cell.getStringCellValue();
else } if (Cell.CELL_TYPE_STRING = = cell.getCellType()) {
if (cell.getRichStringCellValue().numFormattingRuns() == 0) {
return XmlEscapers.xmlContentEscaper().escape(cell.get StringCellValue() );
} else if (is07) {
{ getHSSFRichString((HSSFRichTextString) cell.getRichStringCellValue());
}
Determine the cell type, and then set the value. If it is String, you need to determine whether it is complex text. If so, you need to process it according to 03 and 07 respectively, iterate the column type list and then output
Overall, it’s much easier than you think
How to use --- only one sheet can be output
/**
* Excel becomes the interface
* @author JueYue
*/
public final class ExcelToHtmlUtil {
private ExcelToHtmlUtil() {
}
/**
* Convert to Table
* @param wb Excel
* @return
*/
public static String toTableHtml(Workbook wb) {
return new ExcelToHtmlServer(wb, false , 0).printPage();
}
/**
* Convert to Table
* @param wb Excel
* @param sheetNum sheetNum
* @return
*/
public static String toTableHtml(Workbook wb, int sheetNum) {
return new ExcelToHtmlServer(wb, false , sheetNum).printPage();
}
/**
* Convert to complete interface
* @param wb Excel
* @param sheetNum sheetNum
* @return
*/
public static String toAllHtml(Workbook wb) {
return new ExcelToHtmlServer(wb, true , 0).printPage();
}
/**
* Convert to complete interface
* @param wb Excel
* @param sheetNum sheetNum
* @return
*/
public static String toAllHtml(Workbook wb, int sheetNum) {
return new ExcelToHtmlServer(wb, true , sheetNum).printPage();
}
}
源码地址EasyPoi