jxlreader.java

一款少见的用swt写的彩票软件

package com.dc.test;

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

public class JxlReader {

	/**
	 * <p>
	 * java读取Excel表格，拷贴心、更新Excel工作薄
	 * </p>
	 */
	public static void main(String[] args) {
		jxl.Workbook rwb = null;
		try {
			// 构建Workbook对象 只读Workbook对象
			// 直接从本地文件创建Workbook
			// 从输入流创建Workbook

			InputStream is = new FileInputStream(
			"F:\\eclipse\\workspace\\Dodugo\\resource\\shuangsheqiu.xls");
			rwb = Workbook.getWorkbook(is);
			// Sheet(术语：工作表)就是Excel表格左下角的Sheet1,Sheet2,Sheet3但在程序中
			// Sheet的下标是从0开始的
			// 获取第一张Sheet表
			Sheet rs = rwb.getSheet(0);
			// 获取Sheet表中所包含的总列数
			int rsColumns = rs.getColumns();
			// 获取Sheet表中所包含的总行数
			int rsRows = rs.getRows();
			// 获取指这下单元格的对象引用
			// for (int i = 0; i < rsRows; i++) {
			// for (int j = 0; j < rsColumns; j++) {
			// Cell cell = rs.getCell(j, i);
			// cell.getContents();
			// System.out.print(cell.getContents() + " ");
			// }
			// System.out.println();
			// }

			String[] temp_red = new String[256000];
			for (int i = rsRows - 1; i > 0; i--) {
				Cell cell = rs.getCell(1, i);
				// System.out.println(cell.getContents());
				temp_red[i] = cell.getContents();

				// System.out.println(temp_red[i]);
			}
			try {
				for (int i = 1; i < rsRows; i++) {
					// System.out.println(serveripList[j]);
					String[] serveripList = temp_red[i].split(" ");
					int len = temp_red[i].length();
					if (len == 0) {
						continue;
					} else {
						System.out.print("长度为:" + len);
						System.out.println();
						for (int j = 0; j < 6; j++) {
							System.out.print(serveripList[j]+"|");
						}
						System.out.println();
					}

				}
			} catch (Exception e) {
				e.printStackTrace();
			}

			// 利用已经创建的Excel工作薄创建新的可写入的Excel工作薄
			jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File(
			"F:\\eclipse\\workspace\\Dodugo\\resource\\new.xls"), rwb);
			// 读取第一张工作表
			jxl.write.WritableSheet ws = wwb.getSheet(0);

			// 获取第一个单元格对象
			jxl.write.WritableCell wc = ws.getWritableCell(0, 0);
			// 决断单元格的类型，做出相应的转化
			if (wc.getType() == CellType.LABEL) {
				Label l = (Label) wc;
				l.setString("The value has been modified.");
			}
			// 写入Excel对象
			wwb.write();
			wwb.close();

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			// 操作完成时，关闭对象，翻译占用的内存空间
			rwb.close();

		}
	}
}