testexcel.java

一个具有读写Excel功能的小程序。它使用的是get sheets()的方法来获取每张sheet表的内容。

import jxl.*;
import java.io.*;
import jxl.write.*;

public class TestExcel
{
	public static void main(String []args)
	{
		try
		{
			File outputWorkbook = new File("D:/Test1.xls");
			System.out.println("FileName丗"+outputWorkbook.getName());
			Workbook wb = Workbook.getWorkbook(outputWorkbook);
			Sheet[] sheet=wb.getSheets();
			
		/*	for(int si=0;si<sheet.length;si++)
			{
				sheet[si] = wb.getSheet(si);
				System.out.println("Wookbook:"+sheet[si].getName());
				int column=sheet[si].getColumns();
				for(int i=0;i<column;i++)
				{
					Cell[] c=sheet[si].getColumn(i);
					for(int j=0;j<c.length;j++)
					{
						System.out.print(c[j].getContents()+"    ");
					}
					System.out.println();	
				}
			}*/
		
			for(int si=0;si<sheet.length;si++)
			{
				sheet[si] = wb.getSheet(si);
				System.out.println(sheet[si].getName());
				int row=sheet[si].getRows();
				for(int i=0;i<row;i++)
				{
					Cell[] c=sheet[si].getRow(i);
					for(int j=0;j<c.length;j++)
					{
						System.out.print(c[j].getContents()+"    ");
					}
					System.out.println();
				}
			}
			WritableWorkbook wwb = Workbook.createWorkbook(new File("D:/Test2.xls"),wb);  
			WritableSheet ws = wwb.createSheet("TestCreateExcel", 0);
			Label label=new Label(0,0,"test");     
			ws.addCell(label); 
		
			/*WritableSheet ws1=wwb.getSheet(1);
			WritableCell wc = ws1.getWritableCell(0, 0);
			if(wc.getType() == CellType.LABEL)
			{
				Label l = (Label)wc;   
				l.setString("The value has been modified.");
			}*/
	
			wwb.write();
			wwb.close();
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
}