67,513
社区成员
发帖
与我相关
我的任务
分享
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");
}
}