getexceldata.java

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

package com.dc.common;

import jxl.*;

import java.io.*;

import jxl.write.*;

public class GetExcelData extends Thread{
	private static String[] temp_red = new String[256000];

	public void run() {
		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 = rsRows - 1; i > 0; i--) {
				Cell cell = rs.getCell(1, i);
				temp_red[i] = cell.getContents();
			}
			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();
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			// 操作完成时，关闭对象，翻译占用的内存空间
			rwb.close();
		}
		//return temp_red;
	}
	
	
	public String [] GetDataFromExcel(){
		return temp_red;
	}
}