package DAO.Sys;

import  java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.Date;



import jxl.Cell;
import jxl.Sheet;
import  jxl.Workbook;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableCell;
import  jxl.write.WritableSheet;
import  jxl.write.WritableWorkbook;
import jxl.write.WriteException;

public   class  EXCELReader  {
	
	public String[][] getpersons() {
		try {
			Workbook book = Workbook.getWorkbook(new File("person.xls"));
			int length = book.getNumberOfSheets()-1;
			  String[][] data = new String[length][];
			 Sheet sheet  =  book.getSheet( 0 );
			 int k=0;
			  for (int i=1;i<=length;i++){
	               Cell cell1  =  sheet.getCell( 0 ,  i );
	               Cell cell2  =  sheet.getCell( 1 ,  i );
	               Cell cell3  =  sheet.getCell( 2 ,  i );
	               Cell cell4  =  sheet.getCell( 3 ,  i );
	               String name  =  cell1.getContents();
	               String phone=cell2.getContents();
	               String group=cell3.getContents();
	               String smsnum=cell4.getContents();
	               String[] button = {name, phone, group, smsnum};
	               data[k]=button;
	               k++;
	           }
			 
			  
	           book.close();
	           return data;
			  
		} catch (Exception e) {
			System.out.println(e);
		}
		return null;
	}
	
	public String[][] getSMScontents() {
		try {
			Workbook book = Workbook.getWorkbook(new File("SMScontents.xls"));
			int length = book.getNumberOfSheets();
			String[][] data = new String[length][];
			Sheet sheet  =  book.getSheet( 0 );
			for (int i=1;i<=length;i++){
				Cell cell1  =  sheet.getCell( 0 ,  i );
				Cell cell2  =  sheet.getCell( 1 ,  i );
				Cell cell3  =  sheet.getCell( 2 ,  i );
				Cell cell4  =  sheet.getCell( 3 ,  i );
				String name  =  cell1.getContents();
				String phone=cell2.getContents();
				String group=cell3.getContents();
				String smsnum=cell4.getContents();
				String[] button = {name, phone, group, smsnum};
				data[i-1]=button;
				
			}
			
			
			book.close();
			return data;
			
		} catch (Exception e) {
//			log.error(e);
		}
		return null;
	}
	
	
	public void Modifypersons(int rows,int hour) {
		try{
	Workbook book = Workbook.getWorkbook(new File("person.xls"));
	jxl.write.WritableWorkbook wbe= Workbook.createWorkbook(new File("person.xls"), book);//创建workbook的副本
	WritableSheet sheet  = wbe.getSheet(0); //获取第一个sheet
	WritableCell cell =sheet.getWritableCell(3, rows);//获取第一个单元格
	jxl.format.CellFormat cf = cell.getCellFormat();//获取第一个单元格的格式
	jxl.write.Label lbl = new jxl.write.Label(3, rows, hour+"");//将第一个单元格的值改为“修改後的值”
	lbl.setCellFormat(cf);//将修改后的单元格的格式设定成跟原来一样
	sheet.addCell(lbl);//将改过的单元格保存到sheet
	wbe.write();//将修改保存到workbook --》一定要保存
	wbe.close();//关闭workbook，释放内存 ---》一定要释放内存
} catch (Exception e) {
	e.printStackTrace();
}

}
  
	
}