Question

有人知道怎样在netbeans通过JTable往指定的Excel文件(不是数据库)添加数据吗?

只要告诉我方案和通过什么做就行,谢谢了

Answer 1

核心代码如下，自己多试试看，不难的
try {
String excelFileName="myTable.xls";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
excelFileName = "myAuthors.xls";
excelDatabase= "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=";
excelDatabase+= excelFileName.trim() + ";DriverID=278;READONLY=false}";
excelCon = DriverManager.getConnection(excelDatabase,"","");
if(!excelCon.isClosed())
System.out.println("Successfully Connected To Excel !!");

Statement excelStat;
excelStat=excelCon.createStatement();

for(rowI=0;rowI<table.getRowCount();rowI++)
{
sqlInsert="Insert into `Sheet1$` values("+table.getValueAt(rowI,0))+","+table.getValueAt(rowI,1)+")";
excelStat.executeUpdate(sqlInsert);

}