org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>()方法的使用及代码示例

x33g5p2x  于2022-01-20 转载在 其他  
字(8.2k)|赞(0)|评价(0)|浏览(484)

本文整理了Java中org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>()方法的一些代码示例，展示了HSSFWorkbook.<init>()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。HSSFWorkbook.<init>()方法的具体详情如下：
包路径：org.apache.poi.hssf.usermodel.HSSFWorkbook
类名称：HSSFWorkbook
方法名：<init>

HSSFWorkbook.<init>介绍

[英]Creates new HSSFWorkbook from scratch (start here!)
[中]从头开始创建新的HSSF工作簿（从这里开始！）

代码示例

代码示例来源：origin: stackoverflow.com

  1. Workbook wb = new HSSFWorkbook();
  2.  //Workbook wb = new XSSFWorkbook();
  3.  CreationHelper createHelper = wb.getCreationHelper();
  4.  Sheet sheet = wb.createSheet("new sheet");
  5.  // Create a row and put some cells in it. Rows are 0 based.
  6.  Row row = sheet.createRow((short)0);
  7.  // Create a cell and put a value in it.
  8.  Cell cell = row.createCell(0);
  9.  cell.setCellValue(1);
  10.  // Or do it on one line.
  11.  row.createCell(1).setCellValue(1.2);
  12.  row.createCell(2).setCellValue(
  13.     createHelper.createRichTextString("This is a string"));
  14.  row.createCell(3).setCellValue(true);
  15.  // Write the output to a file
  16.  FileOutputStream fileOut = new FileOutputStream("workbook.xls");
  17.  wb.write(fileOut);
  18.  fileOut.close();

代码示例来源：origin: stackoverflow.com

  1. public void getReportData() throws IOException {
  2.   HSSFWorkbook workbook = new HSSFWorkbook();
  3.   HSSFSheet sheet = workbook.createSheet();
  4.   HSSFRow row = sheet.createRow(0);
  5.   HSSFCell cell = row.createCell(0);
  6.   cell.setCellValue(0.0);
  8.   FacesContext facesContext = FacesContext.getCurrentInstance();
  9.   ExternalContext externalContext = facesContext.getExternalContext();
  10.   externalContext.setResponseContentType("application/vnd.ms-excel");
  11.   externalContext.setResponseHeader("Content-Disposition", "attachment; filename=\"my.xls\"");
  13.   workbook.write(externalContext.getResponseOutputStream());
  14.   facesContext.responseComplete();
  15. }

代码示例来源：origin: pentaho/pentaho-kettle

  1. private HSSFWorkbook createWorkbook( FileObject file ) throws Exception {
  2.  HSSFWorkbook wb = null;
  3.  OutputStream os = null;
  4.  try {
  5.   os = file.getContent().getOutputStream();
  6.   wb = new HSSFWorkbook();
  7.   wb.createSheet( SHEET_NAME );
  8.   wb.write( os );
  9.  } finally {
  10.   os.flush();
  11.   os.close();
  12.  }
  13.  return wb;
  14. }

代码示例来源：origin: stackoverflow.com

  1. FileInputStream fis = new FileInputStream("/somepath/test.xls");
  2. Workbook wb = new HSSFWorkbook(fis); //or new XSSFWorkbook("/somepath/test.xls")
  3. Sheet sheet = wb.getSheetAt(0);
  4. FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();

代码示例来源：origin: stackoverflow.com

  1. HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(file));
  2. HSSFSheet s = wb.getSheetAt(0);
  3. s.setActive(true);
  4. HSSFRow row = s.getRow(0);
  5. HSSFCell cell = row.getCell(0);
  6. cell.setAsActiveCell();
  7. FileOutputStream out = new FileOutputStream(file);

代码示例来源：origin: stackoverflow.com

  1. InputStream is = new FileInputStream(FILEPATH);
  2.   HSSFWorkbook wb = new HSSFWorkbook(is);
  3.   ByteArrayOutputStream out = new ByteArrayOutputStream();
  4.   wb.write(out);
  5.   HSSFWorkbook wb2 = new HSSFWorkbook(new ByteArrayInputStream(out.toByteArray()));

代码示例来源：origin: stackoverflow.com

  1. HSSFWorkbook wb;
  2. HSSFSheet sheet;
  3. if(file.exists()) {//The workbook has been created already
  4.   wb = (HSSFWorkbook) WorkbookFactory.create(new FileInputStream(file));//Line 1
  5.   sheet = wb.getSheetAt(0);
  6. } else {//No workbook exists at the location the "file" specifies
  7.   wb = new HSSFWorkbook();
  8.   sheet = wb.createSheet();
  9. }

代码示例来源：origin: org.apache.poi/poi-examples

  1. public static void main(String[] args) throws IOException {
  2.     try (HSSFWorkbook wb = new HSSFWorkbook()) {
  3.       try (FileOutputStream fileOut = new FileOutputStream("workbook.xls")) {
  4.         wb.write(fileOut);
  5.       }
  6.     }
  7.   }
  8. }

代码示例来源：origin: stackoverflow.com

  1. HSSFWorkbook workbook=new HSSFWorkbook();
  2.      HSSFSheet sheet =  workbook.createSheet("FirstSheet");  
  3.      HSSFRow rowhead=   sheet.createRow((short)0);
  4.      HSSFCellStyle style = workbook.createCellStyle();
  5.      style.setWrapText(true);
  6.      row.setRowStyle(style);
  7.      row.getCell(0).setCellStyle(style);

代码示例来源：origin: stackoverflow.com

  1. HSSFWorkbook wb = new HSSFWorkbook();
  2. HSSFSheet sheet = wb.createSheet("Sheet1");
  3. sheet = wb.getSheetAt(0);
  5. for (Row myrow : sheet) {
  6.   for (Cell mycell : myrow) {
  7.     //set foreground color here
  8.   }
  9. }

代码示例来源：origin: stackoverflow.com

  1. HSSFWorkbook hwb = new HSSFWorkbook();
  2. ...
  3. OutputStream outStream = response.getOutputStream();
  4. hwb.write(outputStream);
  5. ....

代码示例来源：origin: org.apache.poi/poi

  1. } else {
  2.   System.out.print("reading " + filename + "...");
  3.   FileInputStream is = new FileInputStream(filename);
  4.   HSSFWorkbook wb = new HSSFWorkbook(is);
  5.   try {
  6.     System.out.println("done");
  7.       String outputFile = filename.replace(".xls", "-saved.xls");
  8.       System.out.print("saving to " + outputFile + "...");
  9.       os = new FileOutputStream(outputFile);
  10.       wb.write(os);
  11.     } finally {
  12.       os.close();

代码示例来源：origin: org.apache.poi/poi

  1. is = System.in;
  2. } else {
  3.   is = new FileInputStream(cmdArgs.getInputFile());
  4. HSSFWorkbook wb = new HSSFWorkbook(is);
  5. is.close();

代码示例来源：origin: stackoverflow.com

  1. import java.io.*;
  2. import org.apache.poi.hssf.usermodel.HSSFWorkbook;
  3. import org.apache.poi.ss.usermodel.*;
  4. import au.com.bytecode.opencsv.CSVReader;
  6. class Test {
  7.   public static void main(String[] args) throws IOException {
  8.     Workbook wb = new HSSFWorkbook();
  9.     CreationHelper helper = wb.getCreationHelper();
  10.     Sheet sheet = wb.createSheet("new sheet");
  12.     CSVReader reader = new CSVReader(new FileReader("data.csv"));
  13.     String[] line;
  14.     int r = 0;
  15.     while ((line = reader.readNext()) != null) {
  16.       Row row = sheet.createRow((short) r++);
  18.       for (int i = 0; i < line.length; i++)
  19.         row.createCell(i)
  20.           .setCellValue(helper.createRichTextString(line[i]));
  21.     }
  23.     // Write the output to a file
  24.     FileOutputStream fileOut = new FileOutputStream("workbook.xls");
  25.     wb.write(fileOut);
  26.     fileOut.close();
  27.   }
  28. }

代码示例来源：origin: stackoverflow.com

  1. HSSFWorkbook workbook = new HSSFWorkbook();
  2. HSSFSheet    sheet    = new HSSFSheet();
  4. Header header = sheet.getHeader() //get header from workbook's sheet
  5. header.setCenter(HSSFHeader.font("COURIER", "Normal")+ HSSFHeader.fontSize((short) 15) + "Hello world" +new Date()); // set header with desire font style 
  7. FileOutputStream fileOut = new FileOutputStream("C:\\book.xls");
  8. workbook.write(fileOut);

代码示例来源：origin: stackoverflow.com

  1. // Set up a rudimentary worksheet with a cell in it
  2. HSSFWorkbook wb = new HSSFWorkbook();
  3. HSSFSheet sheet = wb.createSheet(“sheet1”);
  4. HSSFRow row = sheet.createRow(0);
  5. HSSFCell cell = row.createCell(0);
  7. // Set up fonts
  8. HSSFFont blueFont = workbook.createFont();
  9. blueFont.setColor(HSSFColor.BLUE.index);
  11. HSSFFont greenFont = workbook.createFont();
  12. greenFont.setColor(HSSFColor.GREEN.index);
  14. // create a cell style and assign the first font to it
  15. HSSFCellStyle style = workbook.createCellStyle();
  16. style.setFont(blueFont);
  18. // assign the style to the cell
  19. cell.setCellStyle(style);
  21. // override the parts of the text that you want to
  22. // color differently by applying a different font.
  23. HSSFRichTextString richString = new HSSFRichTextString("Hello, World!");
  24. richString.applyFont(6, 13, greenFont);
  25. cell.setCellValue(richString);

代码示例来源：origin: org.wicketstuff/wicket-poi

  1. /**
  2.  * Create the sheet in where component table data will be set
  3.  * 
  4.  * @return a new {@link Sheet} to receive the table component data
  5.  */
  6. protected Sheet newSheet()
  7. {
  8.   return new HSSFWorkbook().createSheet("data");
  9. }

代码示例来源：origin: stackoverflow.com

  1. HSSFWorkbook wb = new HSSFWorkbook();
  2. HSSFSheet sheet = wb.createSheet("new sheet");
  3. ...
  4. OutputStream out = response.getOutputStream();
  5. wb.write(out);
  6. out.close();

代码示例来源：origin: youseries/ureport

  1. private void doProduce(Report report, OutputStream outputStream,boolean withPaging,boolean withSheet) {
  2.   CellStyleContext cellStyleContext=new CellStyleContext();
  3.   HSSFWorkbook wb = new HSSFWorkbook();
  4.   CreationHelper creationHelper=wb.getCreationHelper();
  5.   Paper paper=report.getPaper();
  6.     wb.write(outputStream);			
  7.   }catch(Exception ex){
  8.     throw new ReportComputeException(ex);

代码示例来源：origin: stackoverflow.com

  1. HSSFWorkbook workbook = new HSSFWorkbook();
  2. HSSFSheet realSheet = workbook.createSheet("Sheet xls");
  3. HSSFSheet hidden = workbook.createSheet("hidden");
  4. for (int i = 0, length= countryName.length; i < length; i++) {
  5.   String name = countryName[i];
  6.   HSSFRow row = hidden.createRow(i);
  7.   HSSFCell cell = row.createCell(0);
  8.   cell.setCellValue(name);
  9.  }
  10.  Name namedCell = workbook.createName();
  11.  namedCell.setNameName("hidden");
  12.  namedCell.setRefersToFormula("hidden!$A$1:$A$" + countryName.length);
  13.  DVConstraint constraint = DVConstraint.createFormulaListConstraint("hidden");
  14.  CellRangeAddressList addressList = new CellRangeAddressList(0, 0, 0, 0);
  15.  HSSFDataValidation validation = new HSSFDataValidation(addressList, constraint);
  16.  workbook.setSheetHidden(1, true);
  17.  realSheet.addValidationData(validation);
  18.  FileOutputStream stream = new FileOutputStream("c:\\range.xls");
  19.  workbook.write(stream);
  20.  stream.close();

内容来源于网络，如有侵权，请联系作者删除！

HSSFWorkbook

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    HSSFWorkbook类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com