Convert Excel to Html Excel preview_html/css_WEB-ITnose

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

* @date May 10, 2015 11:51:48 AM

*/

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