//上傳按鈕觸發事件 Form.openUploadFileWin("D:\\AgentflowShare\\", "strExcelName"); //導入按鈕觸發事件 //採用 POI? 取 Excel 工作薄 var workbook = new Packages.org.apache.poi.hssf.usermodel.HSSFWorkbook(new Packages.java.io.FileInputStream("D:\\AgentflowShare\\" + strFileName)); var sheet = workbook.getSheet(workbook.getSheetName(0));//獲取 EXCEL 工作薄 var rows = sheet.getPhysicalNumberOfRows();//獲取行數 if (rows > 0) { sheet.getMargin(sheet.TopMargin); for (var r = 1; r < rows; r++) { //首行取出標題欄 var row = sheet.getRow(r); //獲得單行 if (row != null) { var cells = row.getLastCellNum();//?得列? for (var c = 0; c < cells; c++) { row.getCell(c); var cell = row.getCell(c);//獲得單列 cmpExcelTable.setValueAt(cell, r - 1, c);//插入數據 } } } }
This man is too old to remember everything in his brain. Right now, he needs a place to write down what he has studied.
2013年8月7日 星期三
將 excel 文件傳輸至 server 端,再 poi 解析導入 table 中
http://forum.flowring.com/post/view?bid=34&id=12246&sty=3&age=0&tpg=1&ppg=1#12246
沒有留言:
張貼留言