java 解析 excel數據excel – JAVA編程語言程序開發技術文章

[java] 
import java.io.FileInputStream; 
import java.io.IOException; 
import java.io.InputStream; 
 
import jxl.Cell; 
import jxl.Sheet; 
import jxl.Workbook; 
import jxl.read.biff.BiffException; 
 
public class AnalyticExcel2 { 
     
    public static void main(String[] args)  throws  BiffException, IOException { 
         
        InputStream is = new FileInputStream("D:\\Project6\\A\\src\\Analytic\\doc\\C.xls"); 
        try { 
             
            Workbook wb = Workbook.getWorkbook(is); 
            int wbNum = wb.getNumberOfSheets(); 
            for(int i = 0;i<wbNum;i++){ 
                Sheet sheet = wb.getSheet(i); 
                String sheetName = sheet.getName(); 
                System.out.println("sheetName="+sheetName); 
                if(sheet!=null){ 
                    // 獲取表格總列數 
                    int rsColumns = sheet.getColumns(); 
                    // 獲取表格總行數 
                    int rsRows = sheet.getRows(); 
                    //循環文件裡的數據 
                    for(int j=0;j<rsRows;j++){ 
                        Cell[] cells = sheet.getRow(j); 
                        for(int k=0;k<rsColumns;k++){ 
                            System.out.print(cells[k].getContents()+"—-"); 
                        } 
                        System.out.println(); 
                    } 
                } 
            } 
             
    } catch (Exception e) { 
            e.printStackTrace(); 
        } 
    } 
 

作者:Heng_Ji

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。 必填欄位標示為 *