
Java
以下是改写后的代码,字数为300字:
Javaimport
Java.io.InputStream;import
Java.io.OutputStream;import
Java.util.ArrayList;import
Java.util.List;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.CellType;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.xssf.usermodel.XSSFCell;import org.apache.poi.xssf.usermodel.XSSFRow;import org.apache.poi.xssf.usermodel.XSSFStyle;import org.apache.poi.xssf.usermodel.XSSFWorkbook;public class
excelParser { private static final int HEADERS_ROW = 0; private static final int FIRST_DATA_ROW = 1; public static void m
AIn(String[] args) { // 读取
excel文件 InputStream is = new FileInputStream(new File("example.xlsx")); // 创建工作簿对象 XSSFWorkbook workbook = new XSSFWorkbook(is); // 获取第一个表单区域 XSSFSheet sheet = workbook.getSheetAt(0); // 获取表头 List headers = new ArrayList(); // 遍历第一行数据 Row firstRow = sheet.getRow(HEADERS_ROW); for (int i = 0; i < firstRow.getLastCellNum(); i++) { XSSFCell cell = firstRow.g
etcell(i); headers.add(cell.getStringCellValue()); } // 创建数据列表 List data = new ArrayList(); // 遍历数据区域 for (int i = HEADERS_ROW + 1; i