java读取xls表格(提供免费下载jar包)

我不是女神ヾ 2022-05-09 07:40 536阅读 0赞

有一张这个表格，路径是  H:/Desk/web/tt.xls

![70][]

现在要用java解析这样的表格，先来开下效果，最后输出如下

![70 1][]

好了，现在来进行读取白哦个内容吧！

先下载jxl.jar这个jar包

下面是下载地址

csdn下载(当然我希望能赚点积分)[https://download.csdn.net/download/qq\_40881680/10701483][https_download.csdn.net_download_qq_40881680_10701483]

提供免费下载地址: [jxl.jar免费下载-点击下载][jxl.jar_-]

导入这个jar包

![70 2][]

导入之后如下java代码，运行就可以了

import java.io.File;
    import jxl.Cell;
    import jxl.Sheet;
    import jxl.Workbook;
    
    public class XLS{
    	public static void main(String[] args) {
    		try {
    			//创建workbook
    			Workbook workbook = Workbook.getWorkbook(new File("H:/Desk/web/tt.xls"));
    		
    			//获取第一个工作表sheet
    			Sheet sheet = workbook.getSheet(0);
    			
    			for (int i = 0; i <sheet.getRows(); i++) {
    				for (int j = 0; j < sheet.getColumns(); j++) {
    					Cell cell = sheet.getCell(j, i);
    					System.out.print(cell.getContents()+" ");
    				}
    				System.out.println();
    			}
    			workbook.close();
    				
    			
    		} catch (Exception e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    
    	}
    }

[70]: /images/20220509/8e3dffdb5c8142419e3be9ea1b046d6d.png
[70 1]: /images/20220509/9b35c7f67c424def998d92c1694747a1.png
[https_download.csdn.net_download_qq_40881680_10701483]: https://download.csdn.net/download/qq_40881680/10701483
[jxl.jar_-]: https://csdn-1256109420.cos.ap-beijing.myqcloud.com/jxl/jxl%E5%8C%85%E5%92%8C%E4%BD%BF%E7%94%A8%E6%96%B9%E6%B3%95.zip?q-sign-algorithm=sha1&q-ak=AKIDwBOdpo0ccir4hBhmgoK8cNJnBjuwRrr7&q-sign-time=1541678600;1541680400&q-key-time=1541678600;1541680400&q-header-list=&q-url-param-list=&q-signature=f04296013e48be7906c6ba56fd4e4fe7390e65ad&x-cos-security-token=bee954f36396fd5375424ac773281b4d5ca1ca3d10001&response-content-disposition=attachment
[70 2]: /images/20220509/3716e19db86f4673a31633ea4e7454ae.png