- package org.ml.excel;
- import java.io.File;
- import java.io.IOException;
- import jxl.Sheet;
- import jxl.Workbook;
- import jxl.read.biff.BiffException;
- import jxl.write.Label;
- import jxl.write.WritableSheet;
- import jxl.write.WritableWorkbook;
- import jxl.write.WriteException;
- import jxl.write.biff.RowsExceededException;
- public class ExcelTest {
- public static void main(String[] args) {
- String data[][] = { { "ml", "穆岭", "22岁" },
- { "gzdx", "贵州大学", "100多年的历史" }, { "jxxy", "计信学院", "不知道" } };
- File f = new File("D:" + File.separator + "ml.xls");
- WritableWorkbook workbook = null;
- try {
- workbook = Workbook.createWorkbook(f);
- } catch (IOException e) {
- e.printStackTrace();
- }
- WritableSheet sheet[] = new WritableSheet[3];
- Label lab = null;
- for (int i = 0; i < sheet.length; i++) {
- sheet[i] = workbook.createSheet("资料" + i, 0);
- for (int j = 0; j < data.length; j++) {
- for (int k = 0; k < data[j].length; k++) {
- lab = new Label(k, j, data[j][k]);
- try {
- sheet[i].addCell(lab);
- } catch (RowsExceededException e) {
- e.printStackTrace();
- } catch (WriteException e) {
- e.printStackTrace();
- }
- }
- }
- }
- try {
- workbook.write();
- } catch (IOException e) {
- e.printStackTrace();
- }
- try {
- workbook.close();
- System.out.println("数据写入成功!");
- } catch (WriteException e) {
- e.printStackTrace();
- } catch (IOException e) {
- e.printStackTrace();
- }
- System.out.println("下面开始读取数据");
- Workbook readworkbook = null;
- try {
- readworkbook = Workbook.getWorkbook(f);
- } catch (BiffException e) {
- e.printStackTrace();
- } catch (IOException e) {
- e.printStackTrace();
- }
- Sheet readsheet[] = readworkbook.getSheets();
- for (int i = 0; i < readsheet.length; i++) {
- System.out.println(readsheet[i].getName());
- for (int j = 0; j < readsheet[i].getRows(); j++) {
- for (int k = 0; k < readsheet[i].getColumns(); k++) {
- String content = readsheet[i].getCell(k, j).getContents();
- System.out.print(content + "\t\t");
- }
- System.out.println();
- }
- }
- System.out.println("数据读取完毕!");
- }
- }