JXL 和 Apache POI 解析带有附加图像对象的 excel

JXL 和 Apache POI 解析带有附加图像对象的 Excel

xml
    net.sourceforge.jexcelapi
    jxl
    2.6.12

java
import jxl.Workbook;
import jxl.Sheet;
import jxl.Cell;
import jxl.read.biff.BiffException;
import jxl.write.*;
import jxl.write.biff.RowsExceededException;
import java.io.File;
import java.io.IOException;
public class JXLExample {
    public static void main(String[] args) {
        try {
            Workbook workbook = Workbook.getWorkbook(new File("example.xls"));
            Sheet sheet = workbook.getSheet(0);
            
            for (int i = 0; i < sheet.getRows(); i++) {
                for (int j = 0; j < sheet.getColumns(); j++) {
                    Cell cell = sheet.getCell(j, i);
                    System.out.print(cell.getContents() + "\t");
                }
                System.out.println();
            }
            
            workbook.close();
        } catch (IOException | BiffException e) {
            e.printStackTrace();
        }
    }
}

xml
    org.apache.poi
    poi
    4.1.2
    org.apache.poi
    poi-ooxml
    4.1.2

java
import org.apache.poi.ss.usermodel.*;
import java.io.File;
import java.io.IOException;
public class ApachePOIExample {
    public static void main(String[] args) {
        try {
            Workbook workbook = WorkbookFactory.create(new File("example.xlsx"));
            Sheet sheet = workbook.getSheetAt(0);
            
            for (Row row : sheet) {
                for (Cell cell : row) {
                    switch (cell.getCellType()) {
                        case STRING:
                            System.out.print(cell.getStringCellValue() + "\t");
                            break;
                        case NUMERIC:
                            System.out.print(cell.getNumericCellValue() + "\t");
                            break;
                        case BOOLEAN:
                            System.out.print(cell.getBooleanCellValue() + "\t");
                            break;
                        default:
                            System.out.print("\t");
                            break;
                    }
                }
                System.out.println();
            }
            
            workbook.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}