import org.apache.poi.ss.usermodel.*; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import java.io.FileOutputStream; import java.io.IOException; public class ExcelTemplateGenerator { public static void main(String[] args) { Workbook workbook = new XSSFWorkbook(); Sheet sheet = workbook.createSheet("Sheet1"); Row titleRow = sheet.createRow(0); Cell titleCell = titleRow.createCell(0); Row headerRow = sheet.createRow(1); Cell headerCell1 = headerRow.createCell(0); Cell headerCell2 = headerRow.createCell(1); Row dataRow1 = sheet.createRow(2); Cell dataCell1_1 = dataRow1.createCell(0); Cell dataCell1_2 = dataRow1.createCell(1); dataCell1_2.setCellValue(20); Row dataRow2 = sheet.createRow(3); Cell dataCell2_1 = dataRow2.createCell(0); Cell dataCell2_2 = dataRow2.createCell(1); dataCell2_2.setCellValue(22); try (FileOutputStream fos = new FileOutputStream("template.xlsx")) { workbook.write(fos); } catch (IOException e) { e.printStackTrace(); } } }


上一篇:
下一篇:
切换中文