import java.io.File;//引入類import java.io.IOException;import java.util.Scanner;import jxl.Cell;import jxl.Sheet;import jxl.Workbook;import jxl.format.UnderlineStyle;import jxl.write.DateFormat;import jxl.write.DateTime;import jxl.write.Label;import jxl.write.NumberFormat;import jxl.write.WritableCellFormat;import jxl.write.WritableFont;import jxl.write.WritableSheet;import jxl.write.WritableWorkbook;

public class TextOperatorExcel {// 操作Excel文件的類

/** * 生成一個Excel文件 */public static void writeExcel(String fileName) {WritableWorkbook wwb = null;try {//創建一個可寫入的工作薄(Workbook)對象wwb = Workbook.createWorkbook(new File(fileName));} catch (IOException e) {// 捕獲流異常e.PRintStackTrace();}if (wwb != null) {// 創建一個可寫入的工作表// Workbook的createSheet方法有兩個參數，第一個是工作表的名稱，第二個是工作表在工作薄中的位置WritableSheet ws = wwb.createSheet("sheet1", 0);for (int i = 0; i < 10; i++) {// 循環添加單元格for (int j = 0; j < 5; j++) {Label labelC = new Label(j, i, "這是第" + (i + 1) + "行，第"+ (j + 1) + "列");try {ws.addCell(labelC);// 將生成的單元格添加到工作表中} catch (Exception e) {// 捕獲異常e.printStackTrace();}

}}try {wwb.write();// 從內存中寫入文件中wwb.close();// 從內存中寫入文件中} catch (Exception e) {// 捕獲異常e.printStackTrace();}}System.out.println("生成一個Excel文件："+fileName+"成功!");}/** * 將內容寫入 * @param fileName * @throws Exception */public static void writeContentToExcel(String fileName) throws Exception{File tempFile=new File(fileName);WritableWorkbook workbook = Workbook.createWorkbook(tempFile);WritableSheet sheet = workbook.createSheet("TestCreateExcel", 0); //一些臨時變量，用于寫到excel中Label l=null;jxl.write.Number n=null;jxl.write.DateTime d=null;

//預定義的一些字體和格式，同一個Excel中最好不要有太多格式 字形 大小 加粗 傾斜 下劃線 顏色WritableFont headerFont = new WritableFont(WritableFont.ARIAL, 12, WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLUE); WritableCellFormat headerFormat = new WritableCellFormat (headerFont);

WritableFont titleFont = new WritableFont(WritableFont.ARIAL, 10, WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.RED); WritableCellFormat titleFormat = new WritableCellFormat (titleFont);

WritableFont detFont = new WritableFont(WritableFont.ARIAL, 10, WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK); WritableCellFormat detFormat = new WritableCellFormat (detFont);

NumberFormat nf=new NumberFormat("0.00000"); //用于Number的格式WritableCellFormat priceFormat = new WritableCellFormat (detFont, nf);

DateFormat df=new DateFormat("yyyy-MM-dd");//用于日期的WritableCellFormat dateFormat = new WritableCellFormat (detFont, df);

l=new Label(0, 0, "用于測試的Excel文件", headerFormat);//創建一些單元格，再加到sheet中sheet.addCell(l);//添加標題int column=0;l=new Label(column++, 2, "標題", titleFormat);sheet.addCell(l);l=new Label(column++, 2, "日期", titleFormat);sheet.addCell(l);l=new Label(column++, 2, "貨幣", titleFormat);sheet.addCell(l);l=new Label(column++, 2, "價格", titleFormat);sheet.addCell(l);//添加內容int i=0;column=0;l=new Label(column++, i+3, "標題 "+i, detFormat);sheet.addCell(l);d=new DateTime(column++, i+3, new java.util.Date(), dateFormat);sheet.addCell(d);l=new Label(column++, i+3, "CNY", detFormat);sheet.addCell(l);n=new jxl.write.Number(column++, i+3, 5.678, priceFormat);sheet.addCell(n);i++;column=0;l=new Label(column++, i+3, "標題 "+i, detFormat);sheet.addCell(l);d=new DateTime(column++, i+3, new java.util.Date(), dateFormat);sheet.addCell(d);l=new Label(column++, i+3, "SGD", detFormat);sheet.addCell(l);n=new jxl.write.Number(column++, i+3, 98832, priceFormat);sheet.addCell(n);//設置列的寬度column=0;sheet.setColumnView(column++, 20);sheet.setColumnView(column++, 20);sheet.setColumnView(column++, 10);sheet.setColumnView(column++, 20);workbook.write();workbook.close();System.out.println("內容寫入"+fileName+"成功");}

public static void readExcelInfo(String fileName) throws Exception {// 獲得Excel文件多少行多少列Workbook book = Workbook.getWorkbook(new File(fileName));// 構造Workbook（工作薄）對象Sheet sheet = book.getSheet(0);// 得到第一列第一行的單元格// 獲得第一個工作表對象int columnum = sheet.getColumns(); // 得到列數int rownum = sheet.getRows(); // 得到行數System.out.println(columnum);System.out.println(rownum);for (int i = 0; i < rownum; i++) // 循環進行讀寫{for (int j = 0; j < columnum; j++) {Cell cell1 = sheet.getCell(j, i);String result = cell1.getContents();System.out.print(result);System.out.print(" /t ");}System.out.println();}book.close();//關閉（工作薄）對象}public static void main(String[] args) {// java程序主入口處try {System.out.println("1.創建Excel文件，輸入Excel文件名稱（包括路徑和后綴）");Scanner scan = new Scanner(System.in);final String fileName = scan.next();//獲得鍵盤值writeExcel(fileName);//調用生成Excel方法System.out.println("2.將內容寫入Excel文件");writeContentToExcel(fileName);//調用將內容寫入Excel方法System.out.println("3.讀取Excel文件");readExcelInfo(fileName);} catch (Exception e) {//捕獲異常e.printStackTrace();}}}