欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

jxl操作excel 博客分类: java ExcelJ#工作 

程序员文章站 2024-02-03 14:08:10
...
package cn.com.zte.test;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;

import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

/**
 * 读写excel文件
 * @author huangshaojun
 *
 */
public class TestExcel
{

    /**
     * 写Excel文件
     * @param fileName
     */
    public void writeExcel(String fileName)
    {
        OutputStream outStream = null;  //输出流
        WritableWorkbook writeWork = null;  //写工作薄
        try
        {
            outStream = new FileOutputStream(fileName); //文件输出流
            writeWork = Workbook.createWorkbook(outStream); //新建工作薄
            WritableSheet outSheet = writeWork.createSheet("old", 0);   //新建工作页
            int k = 1;
            for(int i = 0 ; i < 10; i++)
            {
                for(int j = 0 ; j < 10 ; j++)
                {
                    Label lable = new Label(i , j , String.valueOf(k++)); //新建单元格
                    outSheet.addCell(lable);    //把单元格添加到工作页中
                }
            }
            outSheet.mergeCells(1, 1, 1, 5);    //合并单元格,参数格式(开始列,开始行,结束列,结束行)
            writeWork.write();
            writeWork.close();  //关闭
            outStream.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        
    }
    
    /**
     * 读Excel文件
     * @param fileName
     */
    public void readExcel(String fileName)
    {
        InputStream inStream = null;
        Workbook workBook = null;
        try
        {
            inStream = new FileInputStream(fileName);   //输入流
            workBook = Workbook.getWorkbook(inStream);  //工作薄
            Sheet inSheet = workBook.getSheet("old");   //sheet页
            
            int columns = inSheet.getColumns();
            int rows = inSheet.getRows();
            
            StringBuffer CellContent = new StringBuffer();
            for(int i = 0; i < columns; i++)
            {
                for(int j = 0 ; j < rows ; j++)
                {
                    CellContent.append(inSheet.getCell(i, j).getContents());    //读单元格内容
                    CellContent.append(" ");
                }
                System.out.println(CellContent);
                CellContent.delete(0, CellContent.length());
            }
                        
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }
    
    /**
     * @param args
     */
    public static void main(String[] args)
    {
        TestExcel te = new TestExcel();
        te.writeExcel("D:\\old.xls");
        te.readExcel("D:\\old.xls");
    }

}
 
相关标签: Excel J# 工作