Java操作xls

原创

wx5fe09855cf382 2021-01-07 19:45:19 ©著作权

文章标签 java 文章分类 Java 后端开发

©著作权归作者所有：来自51CTO博客作者wx5fe09855cf382的原创作品，请联系作者获取转载授权，否则将追究法律责任

package fuck;

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;  
import jxl.Cell;   
import jxl.CellType;   
import jxl.Sheet;   
import jxl.Workbook;   
import jxl.write.Label; 

public class ExcelOperater    
{   
  
    public static void main(String[] args)    
    {   
  
        jxl.Workbook readwb = null;   
        try    
        {   
  
            //构建Workbook对象, 只读Workbook对象   
  
            //直接从本地文件创建Workbook   
  
            InputStream instream = new FileInputStream("D:/input_data.xls");   //这个jar包只支持xls的文件
  
            readwb = Workbook.getWorkbook(instream);   
            //Sheet的下标是从0开始   
  
            //获取第一张Sheet表   
  
            Sheet readsheet = readwb.getSheet(0);   
  
            //获取Sheet表中所包含的总列数   
  
            int rsColumns = readsheet.getColumns();   
  
            //获取Sheet表中所包含的总行数   
  
            int rsRows = readsheet.getRows();   
  
            //获取指定单元格的对象引用   
  
            for (int i = 0; i < rsRows; i++)   
            {   
                for (int j = 0; j < rsColumns; j++)   
                {   
                    Cell cell = readsheet.getCell(j, i);   
                    System.out.print(cell.getContents() + " ");   
                }   
                System.out.println();   
            }   
        } 
	    catch (Exception e) 
	       {   
	            e.printStackTrace();   
	       } 
	    finally 
	       {   
	            readwb.close();   
	       }
    }   
}