標籤

4GL (1) 人才發展 (10) 人物 (3) 太陽能 (4) 心理 (3) 心靈 (10) 文學 (31) 生活常識 (14) 光學 (1) 名句 (10) 即時通訊軟體 (2) 奇狐 (2) 音樂 (2) 產業 (5) 郭語錄 (3) 無聊 (3) 統計 (4) 新聞 (1) 經濟學 (1) 經營管理 (42) 解析度 (1) 遊戲 (5) 電學 (1) 網管 (10) 廣告 (1) 數學 (1) 機率 (1) 雜趣 (1) 證券 (4) 證券期貨 (1) ABAP (15) AD (1) agentflow (4) AJAX (1) Android (1) AnyChart (1) Apache (14) BASIS (4) BDL (1) C# (1) Church (1) CIE (1) CO (38) Converter (1) cron (1) CSS (23) DMS (1) DVD (1) Eclipse (1) English (1) excel (5) Exchange (4) Failover (1) FI (57) File Transfer (1) Firefox (2) FM (2) fourjs (1) gladiatus (1) google (1) Google Maps API (2) grep (1) Grub (1) HR (2) html (23) HTS (8) IE (1) IE 8 (1) IIS (1) IMAP (3) Internet Explorer (1) java (3) JavaScript (22) jQuery (6) JSON (1) K3b (1) LED (3) Linux (112) Linux Mint (4) Load Balance (1) Microsoft (2) MIS (2) MM (51) MSSQL (1) MySQL (27) Network (1) NFS (1) Office (1) Oracle (125) Outlook (3) PDF (6) Perl (59) PHP (33) PL/SQL (1) PL/SQL Developer (1) PM (3) Postfix (2) postfwd (1) PostgreSQL (1) PP (50) python (1) QM (1) Red Hat (4) Reporting Service (28) ruby (11) SAP (234) scp (1) SD (16) sed (1) Selenium-WebDriver (5) shell (5) SQL (4) SQL server (8) SQuirreL SQL Client (1) SSH (2) SWOT (3) Symantec (2) T-SQL (7) Tera Term (2) tip (1) tiptop (22) Tomcat (6) Trouble Shooting (1) Tuning (5) Ubuntu (33) ufw (1) utf-8 (1) VIM (11) Virtual Machine (2) vnc (3) Web Service (2) wget (1) Windows (19) Windows (1) WM (6) youtube (1) yum (2)

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


//上傳按鈕觸發事件
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);//插入數據
            }
        }
    }
}

沒有留言:

張貼留言