package cn.flightfeather.supervision.docx4j.demo;
|
|
import org.docx4j.openpackaging.exceptions.Docx4JException;
|
import org.docx4j.openpackaging.packages.SpreadsheetMLPackage;
|
import org.docx4j.openpackaging.parts.SpreadsheetML.WorkbookPart;
|
import org.docx4j.openpackaging.parts.SpreadsheetML.WorksheetPart;
|
import org.xlsx4j.org.apache.poi.ss.usermodel.DataFormatter;
|
import org.xlsx4j.sml.Cell;
|
import org.xlsx4j.sml.Row;
|
import org.xlsx4j.sml.SheetData;
|
import org.xlsx4j.sml.Worksheet;
|
|
public class Teddd {
|
public static void main(String[] args) throws Exception {
|
|
String inputfilepath = System.getProperty("user.dir") + "/content.xlsx";
|
|
// Open a document from the file system
|
|
SpreadsheetMLPackage xlsxPkg = SpreadsheetMLPackage.load(new java.io.File(inputfilepath));
|
WorkbookPart workbookPart = xlsxPkg.getWorkbookPart();
|
WorksheetPart sheet = workbookPart.getWorksheet(0);
|
|
DataFormatter formatter = new DataFormatter();
|
|
// Now lets print the cell content
|
displayContent(sheet, formatter);
|
}
|
|
|
private static void displayContent(WorksheetPart sheet, DataFormatter formatter) throws Docx4JException {
|
|
Worksheet ws = sheet.getContents();
|
SheetData data = ws.getSheetData();
|
|
for (Row r : data.getRow() ) {
|
System.out.println("row " + r.getR() );
|
|
for (Cell c : r.getC() ) {
|
|
// CellReference cellRef = new CellReference(row.getRowNum(), cell.getColumnIndex());
|
// System.out.print(cellRef.formatAsString());
|
// System.out.print(" - ");
|
|
// get the text that appears in the cell by getting the cell value and applying any data formats (Date, 0.00, 1.23e9, $1.23, etc)
|
String text = formatter.formatCellValue(c);
|
System.out.println(c.getR() + " contains " + text);
|
|
}
|
}
|
|
}
|
|
|
|
}
|
