使用JXL读取Excel表格,拷贝、更新Excel工作薄

《使用JXL读取Excel表格,拷贝、更新Excel工作薄》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、/***

读取Excel表格,拷贝、更新Excel工作薄

Description:可以读取Excel文件的内容,更新Excel工作薄*

Copyright:Copyright(c)Corparation2005

程序开发环境为eclipse

2、tStream;importjava.util.Vector;importcn.com.yitong.ChartImg;importcn.com.yitong.VireObj;importcn.com.yitong.platform.log.YTLogger;importjxl.CellType;importjxl.Workbook;importjxl.format.CellFormat;importjxl.format.Colour;importjxl.format.UnderlineStyle;importjxl.write

3、.Formula;importjxl.write.Label;importjxl.write.Number;importjxl.write.WritableCell;importjxl.write.WritableCellFormat;importjxl.write.WritableFont;importjxl.write.WritableImage;importjxl.write.WritableSheet;importjxl.write.WritableWorkbook;importjxl.write.WriteExcept

4、ion;importjxl.write.biff.RowsExceededException;publicclassXLSDemo{    privatestaticfinalintTITLE_LENGTH=7;    privatestaticfinalintSHEET_WIDTH=32;    privatestaticfinalintSHEET_HEIGHT=116;        /**     *创建Excel     */    privatevoidmakeXls()    {        Workbookwor

5、kbook=null;        try        {            //构建Workbook对象,只读Workbook对象            //直接从本地文件创建Workbook,从输入流创建Workbook            InputStreamins=newFileInputStream("D:/Workspace/testproj/source.xls");            workbook=Workbook.getWorkbook(ins);            //利用已经创建的E

6、xcel工作薄创建新的可写入的Excel工作薄            FileoutFile=newFile("D:/Workspace/testproj/test.xls");            WritableWorkbookwwb=Workbook.createWorkbook(outFile,workbook);            //读取第一张工作表            WritableSheetdataSheet=wwb.getSheet(0);            //  设置冻结单元格        

7、    dataSheet.getSettings().setVerticalFreeze(7);            dataSheet.getSettings().setHorizontalFreeze(2);                        //测试模拟数据            VectorvecData=newVector();            for(inti=0;i<50;i++)            {                VireObjobj=newVireObj();    

8、            obj.setOrgNo("00"+i+"0");                obj.setOrgName("机构"+(i+1));                obj.setOpenAcc((int)(100*Math.rando