请阅读有关JTable的教程,创建表模型和实现的数据类型,
JTable知道这些
ColumnClasses并返回
proper value输出
POI; 对于MS Excel中的大多数类型:
您也必须在当前行的单元格内循环
得格式输出为各种数据类型(
Date
,Double
,String
)然后您可以专注于创建
formula(s)
和coloring cell(s)
循环执行的代码
TableModel也可以使用standard生成MS Excel文件
windows delimiters:
public class ExcelCustomerReport { public ExcelCustomerReport() { } public void exportTable(JTable table, File file) throws IOException { TableModel model = table.getModel(); FileWriter out = new FileWriter(file); String groupExport = ""; for (int i = 0; i < (model.getColumnCount()); i++) {//* disable export from TableHeaders groupExport = String.valueOf(model.getColumnName(i)); out.write(String.valueOf(groupExport) + "t"); } out.write("n"); for (int i = 0; i < model.getRowCount(); i++) { for (int j = 0; j < (model.getColumnCount()); j++) { if (model.getValueAt(i, j) == null) { out.write("null" + "t"); } else { groupExport = String.valueOf(model.getValueAt(i, j)); out.write(String.valueOf(groupExport) + "t"); } } out.write("n"); } out.close(); }}


