Java XSSFSheet類代碼示例

本文整理匯總了Java中org.apache.poi.xssf.usermodel.XSSFSheet類的典型用法代碼示例。如果您正苦於以下問題：Java XSSFSheet類的具體用法？Java XSSFSheet怎麽用？Java XSSFSheet使用的例子？那麽, 這裏精選的類代碼示例或許可以為您提供幫助。

XSSFSheet類屬於org.apache.poi.xssf.usermodel包，在下文中一共展示了XSSFSheet類的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Java代碼示例。

示例1: writeXLSXFile

import org.apache.poi.xssf.usermodel.XSSFSheet; //導入依賴的package包/類
public static void writeXLSXFile() throws IOException {

			// @SuppressWarnings("resource")
			XSSFWorkbook wbObj = new XSSFWorkbook();
			XSSFSheet sheet = wbObj.createSheet(sheetName);
			for (int row = 0; row < tableData.size(); row++) {
				XSSFRow rowObj = sheet.createRow(row);
				rowData = tableData.get(row);
				for (int col = 0; col < rowData.size(); col++) {
					XSSFCell cell = rowObj.createCell(col);
					cell.setCellValue(rowData.get(col));
					logger.info("Writing " + row + " " + col + "  " + rowData.get(col));
				}
			}
			FileOutputStream fileOut = new FileOutputStream(excelFileName);
			wbObj.write(fileOut);
			wbObj.close();
			fileOut.flush();
			fileOut.close();
		}

開發者ID:sergueik，項目名稱:SWET，代碼行數:21，代碼來源:TableEditorEx.java

示例2: readXlsx

import org.apache.poi.xssf.usermodel.XSSFSheet; //導入依賴的package包/類
public static ArrayList readXlsx(String path) throws IOException {
    XSSFWorkbook xwb = new XSSFWorkbook(path);
    XSSFSheet sheet = xwb.getSheetAt(0);
    XSSFRow row;
    String[] cell = new String[sheet.getPhysicalNumberOfRows() + 1];
    ArrayList<String> arrayList = new ArrayList<>();
    for (int i = sheet.getFirstRowNum() + 1; i < sheet.getPhysicalNumberOfRows(); i++) {
        cell[i] = "";
        row = sheet.getRow(i);
        for (int j = row.getFirstCellNum(); j < row.getPhysicalNumberOfCells(); j++) {
            cell[i] += row.getCell(j).toString();
            cell[i] += " | ";
        }
        arrayList.add(cell[i]);
    }
    return arrayList;
}

開發者ID:inkss，項目名稱:hotelbook-JavaWeb，代碼行數:18，代碼來源:ExportExcel.java

示例3: setColumWidth

import org.apache.poi.xssf.usermodel.XSSFSheet; //導入依賴的package包/類
private static void setColumWidth(ExcelFileType type,ExportInfo exportInfo,
		List<Field> availableFields,Sheet sheet) {
	Map<Field, ExportFieldInfo> fieldInfoMap = exportInfo.getFieldInfoMap();
	for(int i = 0 ; i < availableFields.size() ; i++){
		Field field = availableFields.get(i);
		ExportFieldInfo excelFieldInfo = fieldInfoMap.get(field);
		if (excelFieldInfo.getWidth() != null) {
			sheet.setColumnWidth(i, excelFieldInfo.getWidth()*256);	
			continue;
		}
		if(excelFieldInfo.getAutoWidth() != null){
			if(ExcelFileType.XLS == type){
				HSSFSheet hSheet = (HSSFSheet) sheet;
				hSheet.autoSizeColumn(i);
			}else if(ExcelFileType.XLSX == type){
				XSSFSheet xSheet = (XSSFSheet) sheet;
				xSheet.autoSizeColumn(i);
			}
		}
	}
}

開發者ID:long47964，項目名稱:excel-utils，代碼行數:22，代碼來源:ExcelExportUtil.java

示例4: parseExcel

import org.apache.poi.xssf.usermodel.XSSFSheet; //導入依賴的package包/類
@SuppressWarnings("resource")
private List<Map<String,Object>> parseExcel(InputStream stream) throws Exception {
	List<Map<String,Object>> mapList=new ArrayList<Map<String,Object>>();
	XSSFWorkbook wb = new XSSFWorkbook(stream);
	for (int i = 0; i < wb.getNumberOfSheets(); i++) {
		XSSFSheet sheet = wb.getSheetAt(i);
		if (sheet == null) {
			continue;
		}
		String name = sheet.getSheetName();
		Map<String,Object> map=new HashMap<String,Object>();
		map.put("name",name);
		map.put("data", buildVariables(sheet));
		mapList.add(map);
	}
	return mapList;
}

開發者ID:youseries，項目名稱:urule，代碼行數:18，代碼來源:PackageServletHandler.java

示例5: readExcelFile

import org.apache.poi.xssf.usermodel.XSSFSheet; //導入依賴的package包/類
/**
 * Método que se encarga de leer el libro de excel
 * cuya ruta recibimos en el constructor y devuelve una lista 
 * de ciudadanos
 * @return lista de Usuarios de la base de datos
 */
public List<CitizenDB> readExcelFile(){
	List<CitizenDB> citizens = new ArrayList<CitizenDB>(); 
	// para cada una de las hojas presentes en el documento de excel
	for(int i=0;i < workbook.getNumberOfSheets();i++){
		XSSFSheet sheet = this.workbook.getSheetAt(i);
		Iterator<Row> rowIterator = sheet.iterator();
		Row row;
		int counter = 0;
		//para cada fila de la hoja
		while(rowIterator.hasNext()){
			row = rowIterator.next();
			if (counter > 0) { //omitimos la cabecera (hay que mirar si hay un metodo de la API)
				Iterator<Cell> cellIterator = row.cellIterator();
				int j = 0;
				CitizenDB user = new CitizenDB();
				while (cellIterator.hasNext()) 	
					this.insertCitizenField(user, j++, cellIterator.next());	
				user.setPassword(new GenerationPassword().passwordGenerator());
				citizens.add(user);
			}
			counter++;
		}
	}
	return citizens;
}

開發者ID:Arquisoft，項目名稱:dashboard1b，代碼行數:32，代碼來源:AdapterPoi.java

示例6: export

import org.apache.poi.xssf.usermodel.XSSFSheet; //導入依賴的package包/類
/**
 * Exports a single sheet to a file
 *
 * @param sheet
 * @throws FactoryConfigurationError
 * @throws XMLStreamException
 * @throws UnsupportedEncodingException
 * @throws FileNotFoundException
 */
private void export(final XSSFSheet sheet, final XMLStreamWriter out)
		throws UnsupportedEncodingException, XMLStreamException, FactoryConfigurationError, FileNotFoundException {
	boolean isFirst = true;
	final Map<String, String> columns = new HashMap<String, String>();
	final String sheetName = sheet.getSheetName();
	System.out.print(sheetName);
	out.writeStartElement("sheet");
	out.writeAttribute("name", sheetName);
	Iterator<Row> rowIterator = sheet.rowIterator();
	while (rowIterator.hasNext()) {
		Row row = rowIterator.next();
		if (isFirst) {
			isFirst = false;
			this.writeFirstRow(row, out, columns);
		} else {
			this.writeRow(row, out, columns);
		}
	}
	out.writeEndElement();
	System.out.println("..");
}

開發者ID:Stwissel，項目名稱:Excel2XML，代碼行數:31，代碼來源:E2xCmdline.java

示例7: parse

import org.apache.poi.xssf.usermodel.XSSFSheet; //導入依賴的package包/類
/**
 * Parses an inputstream containin xlsx into an outputStream containing XML
 * 
 * @param inputStream
 *            the source
 * @param outputStream
 *            the result
 * @throws IOException
 * @throws XMLStreamException
 */
public void parse(final InputStream inputStream, final OutputStream outputStream)
		throws IOException, XMLStreamException {
	XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
	XMLStreamWriter out = this.getXMLWriter(outputStream);
	out.writeStartDocument();
	out.writeStartElement("workbook");
	int sheetCount = workbook.getNumberOfSheets();
	for (int i = 0; i < sheetCount; i++) {
		final XSSFSheet sheet = workbook.getSheetAt(i);
		try {
			this.export(sheet, out);
		} catch (UnsupportedEncodingException | FileNotFoundException | XMLStreamException
				| FactoryConfigurationError e) {
			e.printStackTrace();
		}
	}
	out.writeEndElement();
	out.writeEndDocument();
	out.close();
	workbook.close();
}

開發者ID:Stwissel，項目名稱:Excel2XML，代碼行數:32，代碼來源:E2xCmdline.java

示例8: getSpan

import org.apache.poi.xssf.usermodel.XSSFSheet; //導入依賴的package包/類
private Span getSpan(XSSFSheet sheet,int row ,int column){
	int sheetMergeCount = sheet.getNumMergedRegions(); 
	for (int i = 0; i < sheetMergeCount; i++) {
		CellRangeAddress range = sheet.getMergedRegion(i);
		int firstColumn = range.getFirstColumn();
		int lastColumn = range.getLastColumn();
		int firstRow = range.getFirstRow();
		if(row == firstRow && column==firstColumn){  
			int lastRow = range.getLastRow();
			int rowSpan=lastRow-firstRow;
			if(rowSpan>0){
				rowSpan++;
			}
			int colSpan=lastColumn-firstColumn;
			if(colSpan>0){
				colSpan++;
			}
			return new Span(rowSpan,colSpan);
		}
	}
	return new Span(0,0);
}

開發者ID:youseries，項目名稱:ureport，代碼行數:23，代碼來源:XSSFExcelParser.java

示例9: isMergedRegion

import org.apache.poi.xssf.usermodel.XSSFSheet; //導入依賴的package包/類
private boolean isMergedRegion(XSSFSheet sheet, int row, int column) {
	int sheetMergeCount = sheet.getNumMergedRegions();
	for (int i = 0; i < sheetMergeCount; i++) {
		CellRangeAddress range = sheet.getMergedRegion(i);
		int firstColumn = range.getFirstColumn();
		int lastColumn = range.getLastColumn();
		int firstRow = range.getFirstRow();
		int lastRow = range.getLastRow();
		if (row > firstRow && row < lastRow) {
			if (column > firstColumn && column < lastColumn) {
				return true;
			}
		}
	}
	return false;
}

開發者ID:youseries，項目名稱:ureport，代碼行數:17，代碼來源:XSSFExcelParser.java

示例10: getSheetPictrues07

import org.apache.poi.xssf.usermodel.XSSFSheet; //導入依賴的package包/類
/**
 * 獲取Excel2007圖片
 * 
 * @param sheet
 *            當前sheet對象
 * @param workbook
 *            工作簿對象
 * @return Map key:圖片單元格索引（1_1）String，value:圖片流PictureData
 */
public static Map<String, PictureData> getSheetPictrues07(XSSFSheet sheet,
                                                          XSSFWorkbook workbook) {
    Map<String, PictureData> sheetIndexPicMap = new HashMap<String, PictureData>();
    for (POIXMLDocumentPart dr : sheet.getRelations()) {
        if (dr instanceof XSSFDrawing) {
            XSSFDrawing drawing = (XSSFDrawing) dr;
            List<XSSFShape> shapes = drawing.getShapes();
            for (XSSFShape shape : shapes) {
                XSSFPicture pic = (XSSFPicture) shape;
                XSSFClientAnchor anchor = pic.getPreferredSize();
                CTMarker ctMarker = anchor.getFrom();
                String picIndex = ctMarker.getRow() + "_" + ctMarker.getCol();
                sheetIndexPicMap.put(picIndex, pic.getPictureData());
            }
        }
    }
    return sheetIndexPicMap;
}

開發者ID:rushingpig，項目名稱:poix，代碼行數:28，代碼來源:PoiPublicUtil.java

示例11: main

import org.apache.poi.xssf.usermodel.XSSFSheet; //導入依賴的package包/類
public static void main(String[] args) {
        //Create Workbook instance holding reference to .xlsx file
        try (FileInputStream file = new FileInputStream(
                new File("Sample.xlsx"))) {
            //Create Workbook instance holding reference to .xlsx file
            XSSFWorkbook workbook = new XSSFWorkbook(file);

            //Get first/desired sheet from the workbook
            XSSFSheet sheet = workbook.getSheetAt(0);

            //Iterate through each rows one by one
//            Iterator<Row> rowIterator = sheet.iterator();
            for(Row row : sheet) {
                for (Cell cell : row) {
                    //Check the cell type and format accordingly
                    switch (cell.getCellType()) {
                        case Cell.CELL_TYPE_NUMERIC:
                            out.print(cell.getNumericCellValue() + "\t");
                            break;
                        case Cell.CELL_TYPE_STRING:
                            out.print(cell.getStringCellValue() + "\t");
                            break;
                    }
                }
                out.println();
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

開發者ID:PacktPublishing，項目名稱:Java-for-Data-Science，代碼行數:31，代碼來源:ReadExcelExample.java

示例12: xlsxToClassifiableTexts

import org.apache.poi.xssf.usermodel.XSSFSheet; //導入依賴的package包/類
List<ClassifiableText> xlsxToClassifiableTexts(File xlsxFile, int sheetNumber) throws IOException, EmptySheetException {
  if (xlsxFile == null ||
      sheetNumber < 1) {
    throw new IllegalArgumentException();
  }

  try (XSSFWorkbook excelFile = new XSSFWorkbook(new FileInputStream(xlsxFile))) {
    XSSFSheet sheet = excelFile.getSheetAt(sheetNumber - 1);

    // at least two rows
    if (sheet.getLastRowNum() > 0) {
      return getClassifiableTexts(sheet);
    } else {
      throw new EmptySheetException("Excel sheet (#" + sheetNumber + ") is empty");
    }
  } catch (IllegalArgumentException e) {
    throw new EmptySheetException("Excel sheet (#" + sheetNumber + ") is not found");
  }
}

開發者ID:RusZ，項目名稱:TextClassifier，代碼行數:20，代碼來源:ExcelFileReader.java

示例13: getClassifiableTexts

import org.apache.poi.xssf.usermodel.XSSFSheet; //導入依賴的package包/類
private List<ClassifiableText> getClassifiableTexts(XSSFSheet sheet) {
  List<Characteristic> characteristics = getCharacteristics(sheet);
  List<ClassifiableText> classifiableTexts = new ArrayList<>();

  // start from second row
  for (int i = 1; i <= sheet.getLastRowNum(); i++) {
    Map<Characteristic, CharacteristicValue> characteristicsValues = getCharacteristicsValues(sheet.getRow(i), characteristics);

    // exclude empty rows
    if (!sheet.getRow(i).getCell(0).getStringCellValue().equals("")) {
      classifiableTexts.add(new ClassifiableText(sheet.getRow(i).getCell(0).getStringCellValue(), characteristicsValues));
    }
  }

  return classifiableTexts;
}

開發者ID:RusZ，項目名稱:TextClassifier，代碼行數:17，代碼來源:ExcelFileReader.java

示例14: createWageringHeaderRow

import org.apache.poi.xssf.usermodel.XSSFSheet; //導入依賴的package包/類
public static XSSFRow createWageringHeaderRow(XSSFSheet sheet, int row, int col) {
    XSSFRow headerRow = sheet.createRow(row++);

    col = seedCols(col, headerRow);

    List<String> columns = Arrays.asList("winPayoff", "placePayoff",
            "showPayoff", "totalWpsPool", "doublePayoff", "doublePool", "exactaPayoff",
            "exactaPool", "trifectaPayoff", "trifectaPool", "superfectaPayoff",
            "superfectaPool", "pick3Payoff", "pick3Pool", "pick4Payoff", "pick4Pool",
            "pick5Payoff", "pick5Pool");
    for (String column : columns) {
        CellUtil.createCell(headerRow, col++, column);
    }

    return headerRow;
}

開發者ID:robinhowlett，項目名稱:handycapper，代碼行數:17，代碼來源:ThreeTypeSummary.java

示例15: createMergedRegionIfNotPresent

import org.apache.poi.xssf.usermodel.XSSFSheet; //導入依賴的package包/類
@SuppressWarnings("deprecation")
>>>>>>> fe2012a7f8558d8df36b789847bdc41c788d6eaf
	public static void createMergedRegionIfNotPresent(XSSFSheet sheet,int firstRow, int lastRow, int firstCol, int lastCol){
		String message="XSSFSheet must not be null!";
		Objects.requireNonNull(sheet, () -> message);
		sheet.addMergedRegion(new CellRangeAddress(firstRow,  lastRow,  firstCol,  lastCol)); 
	}

開發者ID:gp15237125756，項目名稱:PoiExcelExport2.0，代碼行數:8，代碼來源:XSSFCellUtil.java

注：本文中的org.apache.poi.xssf.usermodel.XSSFSheet類示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。