|
使用java操作Excel文件(10) File testfile1 = chooser.getSelectedFile(); if (result == chooser.CANCEL_OPTION) { System.exit(0); } try { DataOutputStream out = new DataOutputStream(new FileOutputStream( testfile1)); String fileName = testfile.getName(); byte[] b = xls.getBytes("gbk"); out.write(b); out.close(); } catch (Exception ex) { ex.printStackTrace(); } } //----------------------------------------------------------- public String generateinsertsql(String[][] content) { String fieldContent=""; int ilength=0; String sql=""; for (int i = 1; i < content.length; i++) { fieldContent="'"+content[i][0]+"'"; for(int j=1;j<content[i].length;j++) { fieldContent=fieldContent+",'"+content[i][j]+"'"; } sql=sql+"insert"+tbName+"("+Field+") values("+fieldContent+")\r\n";
|