Java中操作Excel表格方法

本文格式为Word版，下载可任意编辑——Java中操作Excel表格方法Java中操作Excel表格方法

引导语：我们都知道Excel可以举行各种数据的处理、统计分析和辅佐决策操作，那么在Java中又是如何操作Excel表格的呢，以下是我共享给大家的Java中操作Excel表格方法，接待阅读!

利用JavaExcelAPI,下载地址：jexcelapi.rar

下面给出一段读取数据的例子代码：

/*

*Tochangethistemplate,chooseTools|Templates

*andopenthetemplateintheeditor.

*/

packageexcel;

importjava.io.FileInputStream;

importjava.io.FileNotFoundException;

importjava.io.IOException;

importjava.io.InputStream;

importjava.util.logging.Level;

importjava.util.logging.Logger;

importjxl.Cell;

importjxl.Sheet;

importjxl.Workbook;

importjxl.read.biff.BiffException;

/**

*

*@authorWei.Liu

*/

publicclassMain

/**

*@paramargsthecommandlinearguments

*/

publicstaticvoidmainString[]args

try

InputStreamis=newFileInputStreamd:\\test.xls;

jxl.Workbookrwb=Workbook.getWorkbookis;

Sheetrs=rwb.getSheet0;

//取第一行，第一列的元素

Cellc00=rs.getCell0,0;

Stringstrc00=c00.getContents;

//取第一行，其次列的元素

Cellc10=rs.getCell1,0;

Stringstrc10=c10.getContents;

System.out.printlnstrc00++c00.getType.toString;

System.out.printlnstrc10++c10.getType.toString;

//获取sheet的个数

System.out.printlnrwb.getNumberOfSheets;

Sheet[]sheets=rwb.getSheets;

forinti=0;i

System.out.printlnrwb.getSheeti.getName;

//获得列数

System.out.printlnrwb.getSheet0.getColumns;

//获得每列的.元素

Cell[]cell=rwb.getSheet0.getColumn0;

//获得总行数

System.out.printlnrwb.getSheet0.getRows;

//获得行元素

Cell[]cell2=rwb.getSheet0.getRow0;

//关闭对象

rwb.close;

catchExceptionex

Logger.getLoggerMain.class.getName.logLevel.SEVERE,null,ex;

再给出一段，创造Excel表格的代码：

/*

*Tochangethistemplate,chooseTools|Templates

*andopenthetemplateintheeditor.

*/

packageexcel;

importjava.io.File;

importjava.util.logging.Level;

importjava.util.logging.Logger;

importjxl.Workbook;

importjxl.write.Label;

importjxl.write.WritableCellFormat;

importjxl.write.WritableFont;

importjxl.write.WritableSheet;

importjxl.write.WritableWorkbook;

importjxl.write.Number;

/**

*

*@authorWei.Liu

*/

publicclassMain

/**

*@paramargsthecommandlinearguments

*/

publicstaticvoidmainString[]args

try

//创造EXCEL表格

WritableWorkbookwwb=Workbook.createWorkbooknewFiled:\\test.xls;

//创造工作表

WritableSheetws=wwb.createSheetLiu.Wei,0;

//创造单元格

ws.addCellnewLabel0,0,HelloWorld;

//添加设置字体格式的单元格

WritableFontwfc=newWritableFontWritableFont.ARIAL,15,WritableFont.BOLD,true;

WritableCellFormatwcff=newWritableCellFormatwfc;

Labellabelcf=newLabel1,0,Formattext,wcff;

ws.addCelllabelcf;

//向单元格中写入数字

NumberlabelN=newNumber0,1,12345;

ws.addCelllabelN;

wwb.write;

wwb.close;

catchExceptionex

Logger.getLoggerMain.class.getName.logLevel.SEVERE,null,ex;

结果给出一段更新表格的代码：

/*

*Tochangethistemplate,chooseTools|Templates

*andopenthetemplateintheeditor.

*/

packageexcel;

importjava.io.File;

importjava.io.IOException;

importjava.util.logging.Level;

importjava.util.logging.Logger;

importjxl.CellType;

importjxl.Workbook;

importjxl.read.biff.BiffException;

importjxl.write.Label;

importjxl.write.WritableCell;

importjxl.write.WritableSheet;

importjxl.write.WritableWorkbook;

/**

*

*@authorWei.Liu

*/

publicclassMain

/**

*@paramargsthecommandlinearguments

*/

publicstaticvoidmainString[]args

try

Workbookrw=Workbook.getWorkbooknewFiled:\\test.xls;

WritableWorkbookwwb=Workbook.createWorkbooknewFiled:\\test.xls,rw;

//修改单元格的值

WritableSheetws=wwb.getSheet0;

WritableCellwc=ws.getWritableCell0,0;

ifwc.g