怎么用java将一个excel里头数据读出并写入另一个excel?

excel

要将一个excel文件中数据读出并写入另一个excel文件，可以使用Java中的Apache POI库。下面是一个简单的示例代码：Javaimport Java.io.FileOutputStream;import Java.util.Iterator;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.CellValue;import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFDataFormat;import org.apache.poi.xssf.usermodel.XSSFDataValidationHelper;import org.apache.poi.xssf.usermodel.XSSFRow;import org.apache.poi.xssf.usermodel.XSSFSheet;import org.apache.poi.xssf.usermodel.XSSFWorkbook;import org.apache.poi.xssf.eventusermodel.XSSFEventUserModel;import org.apache.poi.xssf.eventusermodel.XSSFEventUserModelListener;import org.apache.poi.xssf.eventusermodel.XSSFException;public class excelReaderWriter {public static void mAIn(String[] args) {// 读取excel文件FileInputStream fis = new FileInputStream("input.xlsx");XSSFWorkbook workbook = new XSSFWorkbook(fis);XSSFSheet sheet = workbook.getSheetAt(0);Iterator rowIterator = sheet.rowIterator();while (rowIterator.hasNext()) {Row row = rowIterator.next();for (Iterator cellIterator = row.cellIterator(); cellIterator.hasNext();) {Cell cell = cellIterator.next();switch (cell.getcellType()) {case Cell.CELL_TYPE_NUMERIC:cell.setcellType(Cell.CELL_TYPE_NUMERIC);break;case Cell.CELL_TYPE_STRING:cell.setcellType(Cell.CELL_TYPE_STRING);break;case Cell.CELL_TYPE_ERROR:case Cell.CELL_TYPE_BLANK:cell.setcellType(Cell.CELL_TYPE_ERROR);break;}}}fis.close();// 写入excel文件FileOutputStream fos = new FileOutputStream("output.xlsx");XSSFWorkbook workbookOut = new XSSFWorkbook();XSSFSheet sheetOut = workbookOut.createSheet("Sheet1");for (int i = 1; i