当前位置:软件学习 > Excel >>

java 解析 excel数据excel

[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
补充:软件开发 , Java ,
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,