Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook

org.apache.poi.hssf.usermodel.HSSFWorkbook
High level representation of a workbook. This is the first object most users will construct whether they are reading or writing a workbook. It is also the top level object for creating new sheets/etc. @see org.apache.poi.hssf.model.Workbook @see org.apache.poi.hssf.usermodel.HSSFSheet @author Andrew C. Oliver (acoliver at apache dot org) @author Glen Stampoultzis (glens at apache.org) @author Shawn Laubach (slaubach at apache dot org) @version 2.0-pre

      throws ProTransException {
    if (directory == null || directory.length() == 0) {
      throw new ProTransException("Katalog ikke satt");
    }


    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("sheet");


    int currentRow = 0;
    int startCell = 0;


    HSSFRow row;

View Full Code Here

  }


  public void generateJiggReport(final ExcelReportSetting reportSetting,
      final Map<Object, Object> data) throws ProTransException {
    String excelPath = getExcelPath();
    HSSFWorkbook wb = new HSSFWorkbook();


    HSSFSheet sheet = getSheet(wb, 1, new int[] { 4000 });


    int currentRow = 0;
    HSSFRow row;

View Full Code Here


  public void generateOrdrereserveTakstolReport(
      final ExcelReportSetting reportSetting,
      final Map<Object, Object> data) throws ProTransException {
    String excelPath = getExcelPath();
    HSSFWorkbook wb = new HSSFWorkbook();


    HSSFSheet sheet = getSheet(wb, 1, new int[] { 4000 });


    int currentRow = 0;
    HSSFRow row;

View Full Code Here


  public void generateDeviationSumJobFunction(
      final ExcelReportSetting reportSetting,
      final Map<Object, Object> data) throws ProTransException {
    String excelPath = getExcelPath();
    HSSFWorkbook wb = new HSSFWorkbook();


    HSSFSheet sheet = getSheet(wb, 10, new int[] { 5000, 1000, 5000, 5000,
        5000, 5000, 5000, 5000, 5000, 5000 });


    int currentRow = 0;

View Full Code Here

    return excelPath;
  }


  public void generateSalesGoalReport(ExcelReportSetting reportSetting,
      Map<Object, Object> data) throws ProTransException {
    HSSFWorkbook wb = new HSSFWorkbook();


    HSSFSheet sheet = getSheet(wb, 21, new int[] { 5000, 6000, 5000, 5000,
        5000, 5000, 5000, 5000, 5000, 5000, 5000, 5000, 5000, 5000,
        5000, 5000, 5000, 5000, 5000, 5000, 5000 }

View Full Code Here

      Map<Object, Object> data) throws ProTransException {


    ImmutableMap<String, Integer> productAreaColumns = new ImmutableMap.Builder<String, Integer>()
        .put("Takstol", 1).put("Garasje", 3).put("Byggelement", 5)
        .build();
    HSSFWorkbook wb = new HSSFWorkbook();


    HSSFSheet sheet = getSheet(wb, 21, new int[] { 5000, 6000, 5000, 5000,
        5000, 5000, 5000, 5000, 5000, 5000, 5000, 5000, 5000, 5000,
        5000, 5000, 5000, 5000, 5000, 5000, 5000 }

View Full Code Here

   * @return HSSFWorkbook 对象
   */
  public static HSSFWorkbook output(String sheetName,
      String[] columnPropterties, String[] columnNames, List<?> list)
  {
    HSSFWorkbook workbook = new HSSFWorkbook();
    HSSFSheet sheet = workbook.createSheet(sheetName);
    // 创建第1行，也就是输出表头
    HSSFRow row = sheet.createRow(0);
    HSSFCell cell;
    for (int i = 0; i < columnNames.length; i++)
    {

View Full Code Here

   */
  public static void export2SimpleExcel(String sheetName,
      String[] columnPropterties, String[] columnNames, List<?> list,
      OutputStream out) throws IOException
  {
    wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet(sheetName);
    // 创建第1行，也就是输出表头
    HSSFRow row = sheet.createRow(0);
    HSSFCell cell;
    for (int i = 0; i < columnNames.length; i++)

View Full Code Here

  /**
   * @Description: 初始化
   */
  private static void init()
  {
    wb = new HSSFWorkbook();
    initStyles();
  }

View Full Code Here

   * @throws IOException 
   * @Description: 初始化（带模板文件输入流）
   */
  private static void init(InputStream input) throws IOException
  {
    wb = new HSSFWorkbook(input);
    initStyles();
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.poi.hssf.usermodel.HSSFWorkbook

bad.robot.excel.DateCellTest

bad.robot.excel.matchers.StubCell

bg.smoc.web.servlet.ResultsServlet

com.asakusafw.testdriver.excel.Util

com.canoo.ant.table.ExcelPropertyTable

com.canoo.webtest.plugins.exceltest.AbstractExcelStep

com.dtrules.compiler.excel.util.ImportRuleSets

com.dtrules.compiler.excel.util.Rules2Excel

com.google.refine.importers.ExcelImporter

com.jfinal.ext.interceptor.excel.ExcelExporter

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.