excelhandle.java

留学生信息管理系统 我的工程实习的项目

package Xl;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.Date;

import org.xml.sax.InputSource;

import jxl.*;
import jxl.format.UnderlineStyle;
import jxl.write.Boolean;
import jxl.write.DateFormat;
import jxl.write.DateTime;
import jxl.write.Label;
import jxl.write.NumberFormat;
import jxl.write.WritableCell;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class ExcelHandle {

	//读取excel
	public static void readExcel(String filePath){
		try{
			InputStream is =new FileInputStream(filePath);
			Workbook rwb=Workbook.getWorkbook(is);
			Sheet st=rwb.getSheet("sheet1");
			Cell c00=st.getCell(0,0);
			String strc00=c00.getContents();
			if(c00.getType()==CellType.LABEL){
				LabelCell labelc00=(LabelCell)c00;
				strc00=labelc00.getString();
			}
			System.out.println(strc00);
			rwb.close();
		}
		catch(Exception e){
			e.printStackTrace();
		}
	}
	
	//输出excel
	public static void writeExcel(OutputStream os){
		try{
			WritableWorkbook wwb=Workbook.createWorkbook(os);
			WritableSheet ws=wwb.createSheet("Test Sheet 1", 0);
			
			Label label =new Label(0,0,"this is a label test");
			ws.addCell(label);
			
			WritableFont wf=new WritableFont(WritableFont.TIMES,18,WritableFont.BOLD,true);
			WritableCellFormat wcf=new WritableCellFormat(wf);
			Label labelcf=new Label(1,0,"this is a label test ",wcf);
			ws.addCell(labelcf);
			
			WritableFont wfc=new WritableFont(WritableFont.ARIAL,10,
					WritableFont.BOLD,false,UnderlineStyle.NO_UNDERLINE,
					jxl.format.Colour.RED);
			WritableCellFormat wcfFC=new WritableCellFormat(wfc);
			Label labelCF=new Label(1,0,"this is a Label Cell",wcfFC);
			ws.addCell(labelCF);
			
			
			jxl.write.Number labelN=new jxl.write.Number(0,1,3.1415926);
			ws.addCell(labelN);
			
			NumberFormat nf= new NumberFormat("#.##");
			WritableCellFormat wcfN=new WritableCellFormat(nf);
			jxl.write.Number labelNF=new jxl.write.Number(1,1,3.1415926,wcfN);
			ws.addCell(labelNF);
			
			
			Boolean labelB=new Boolean(0,2,false);
			ws.addCell(labelB);
			
			DateTime labelDT=new DateTime(0,3,new Date());
			ws.addCell(labelDT);
			
			DateFormat df = new DateFormat("dd MM yyyy hh:mm:ss");
	           WritableCellFormat wcfDF = new WritableCellFormat(df);
	           DateTime labelDTF = new DateTime(1,3,new java.util.Date(),wcfDF);
	           ws.addCell(labelDTF);
	           
	           
	          wwb.write();
	          wwb.close();
			
		}catch(Exception e){
			
			e.printStackTrace();
		}
	}
	
	public static void modifyExcel(File file1,File file2){
		try{
			Workbook rwb=Workbook.getWorkbook(file1);
			WritableWorkbook wwb= Workbook.createWorkbook(file2,rwb);
			WritableSheet ws =wwb.getSheet(0);
			WritableCell wc=ws.getWritableCell(0,0);
			
			if(wc.getType()==CellType.LABEL){
				Label label=(Label)wc;
				label.setString("the value has been modified");
			}
			wwb.write();
			wwb.close();
			rwb.close();
		}catch(Exception e){
			
			e.printStackTrace();
		}
	}
	
	public static void main(String [] args){
		try{
//			ExcelHandle.readExcel("E:/test.xls");
			java.io.File fileWrite=new File("E:/test123.xls");
			fileWrite.createNewFile();
			OutputStream os=new FileOutputStream(fileWrite);
			ExcelHandle.writeExcel(os);
//			ExcelHandle.modifyExcel(new File("E:/test.xls"), new File("E:/xx.xls"));
		}catch(Exception e){
			e.printStackTrace();
		}
		finally{
			System.out.println("s执行完毕!");
		}
	}
}