Method exportTableToExcel

src/main/java/plugins/FofaPlugin.java:311–374

(JTable table)

    }

    public static void exportTableToExcel(JTable table) {
        XSSFWorkbook workbook = new XSSFWorkbook();

        // 创建一个包含整个表的工作表
        XSSFSheet completeSheet = workbook.createSheet("Complete Table");

        // 创建表头
        XSSFRow headerRow = completeSheet.createRow(0);
        for (int i = 0; i < table.getColumnCount(); i++) {
            headerRow.createCell(i).setCellValue(table.getColumnName(i));
        }

        // 写入整个表的数据
        for (int i = 0; i < table.getRowCount(); i++) {
            XSSFRow dataRow = completeSheet.createRow(i + 1);
            for (int j = 0; j < table.getColumnCount(); j++) {
                Object value = table.getValueAt(i, j);
                String text = (value == null) ? "" : value.toString();
                dataRow.createCell(j).setCellValue(text);
            }
        }

        // 为每一列创建单独的工作表并写入非空数据
        for (int columnIndex = 0; columnIndex < table.getColumnCount(); columnIndex++) {
            XSSFSheet sheet = workbook.createSheet(sanitizeSheetName(table.getColumnName(columnIndex)));

            // 创建表头
            XSSFRow columnHeaderRow = sheet.createRow(0);
            columnHeaderRow.createCell(0).setCellValue(table.getColumnName(columnIndex));

            // 写入该列的非空数据
            int dataRowIndex = 1;
            for (int rowIndex = 0; rowIndex < table.getRowCount(); rowIndex++) {
                Object value = table.getValueAt(rowIndex, columnIndex);
                if (value != null) {
                    XSSFRow dataRow = sheet.createRow(dataRowIndex++);
                    dataRow.createCell(0).setCellValue(value.toString());
                }
            }
        }

        // 将工作簿保存到文件
        try {
            SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMdd_HHmmss");
            String timestamp = dateFormat.format(new Date());

            String directoryName = "exportdata";
            File directory = new File(directoryName);

            if (!directory.exists()) {
                directory.mkdirs(); // Use mkdirs() instead of mkdir() to create any necessary parent directories
            }

            String fileName = directoryName + "/TableData_" + timestamp + ".xlsx";
            FileOutputStream output = new FileOutputStream(fileName);
            workbook.write(output);
            output.close(); // Close the file output stream
            workbook.close(); // Close the workbook