java读取Excel代码

最新推荐文章于 2024-05-17 11:22:12 发布

大数据可视化网页设计模板分享

最新推荐文章于 2024-05-17 11:22:12 发布

阅读量187

点赞数

本文链接：https://blog.csdn.net/jian8182/article/details/107081716

版权

参考自：

https://blog.csdn.net/zhaols11/article/details/22191283?ops_request_misc=&request_id=&biz_id=102&utm_term=java%E8%AF%BB%E5%8F%96excel%E6%97%B6%E6%8A%A5%E9%94%99%EF%BC%9AException%20in%20th&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduweb~default-0-22191283

亲测，OK!

import java.io.*;

import jxl.*;
import jxl.read.biff.BiffException;
//import jxl.read.biff.*;
public class ReadExcel
{
       public static void main(String args[]) throws BiffException, IOException
       {
           String filepath = "D:\\交叉验证平台\\测试报告\\DRU出厂测试报告8.xls";
           File xlsFile = new File(filepath);
           // 获得工作簿对象
           Workbook workbook = Workbook.getWorkbook(xlsFile);
           // 获得所有工作表
           Sheet[] sheets = workbook.getSheets();
           // 遍历工作表
           if (sheets != null)
          {
               for (Sheet sheet : sheets)
              {
                   // 获得行数
                   int rows = sheet.getRows();
                   // 获得列数
                   int cols = sheet.getColumns();
                   // 读取数据
                   for (int row = 0; row < rows; row++)
               {
                       for (int col = 0; col < cols; col++)
                       {
                              Cell cell = sheet.getCell(col, row);
   System.out.print(cell.getContents() + " ");
                       }
               System.out.println();
               }
               }
           }
       workbook.close();
   }
}