Пример #1
0
  /**
   * @param filePath
   * @param output
   * @throws InvalidFormatException
   * @throws IOException
   * @throws ParserConfigurationException
   * @throws TransformerException
   */
  public static void convert(String filePath, String output)
      throws InvalidFormatException, IOException, ParserConfigurationException,
          TransformerException {
    XlsxConverter converter = new XlsxConverter(filePath, output);

    Integer sheetNum = converter.x.getNumberOfSheets();
    for (int i = 0; i < sheetNum; i++) {
      XSSFSheet sheet = converter.x.getSheet(converter.x.getSheetName(i));
      String sheetName = converter.x.getSheetName(i);
      System.out.println("----starting process sheet : " + sheetName);
      // add sheet title
      {
        Element title = converter.htmlDocumentFacade.createHeader2();
        title.setTextContent(sheetName);
        converter.page.appendChild(title);
      }

      converter.processSheet(converter.page, sheet);
    }

    converter.htmlDocumentFacade.updateStylesheet();

    Element style =
        (Element) converter.htmlDocumentFacade.getDocument().getElementsByTagName("style").item(0);

    style.setTextContent(converter.css.append(style.getTextContent()).toString());

    converter.saveAsHtml(output, converter.htmlDocumentFacade.getDocument());
  }
Пример #2
0
 public static void main(String[] args)
     throws InvalidFormatException, IOException, ParserConfigurationException,
         TransformerException {
   String name = "xml";
   XlsxConverter.convert("c:/poi/" + name + ".xlsx", "c:/poi/x/" + name + ".html");
 }