package blogic;
import jxl.Cell;
import jxl.DateCell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import java.io.IOException;
import java.io.InputStream;
 import java.text.SimpleDateFormat;
import java.io.FileInputStream;
import java.io.File;
/**
* <概要描述> 倒入考勤表
*
* @author xx
* @version 1.0 2008/01/0７
*/
public class readExcel {
/**
* <概要描述> ｅｘｃｌｅ文件中時間類型數(shù)據格式轉換
*
* @param ｅｘｃｌｅ文件中時間類型數(shù)據
* @return String
* @throws 無
*/
public static String FormateTime(Cell formatecell) {
try {
java.util.Date mydate = null;
DateCell datecll = (DateCell) formatecell;
mydate = datecll.getDate();
long time = (mydate.getTime() / 1000) - 60 * 60 * 8;
mydate.setTime(time * 1000);
SimpleDateFormat formatter = new SimpleDateFormat("HH:mm");
return formatter.format(mydate);
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
/**
* <概要描述> 讀ｅｘｃｌｅ文件
*
* @param 文件路徑
* @return 動態(tài)數(shù)組
* @throws IOException
* @throws BiffException
* @throws 無
*/
public void ReadExcelToDb(String filePath) {
Workbook rwb = null;
boolean flag = true;
String OndutyDate=null;
String onTime=null;
String offTime = null;
String Remark = null;
String WorkTime = null;
String OverTime = null;
String WorkFlag = null;
int rowStart = 7;//cc.NUMBER_7;// 程序從文件的第幾行開始讀
try {
InputStream is = new FileInputStream(filePath);
rwb = Workbook.getWorkbook(is);
rwb = Workbook.getWorkbook(new File(filePath));
// 取得文件的第一個 sheet;
Sheet rs = rwb.getSheet(0);
//讀取文件中數(shù)據
String year = rs.getCell(4, 2).getContents();
String month = rs.getCell(5, 2).getContents();
// 上面條件都符合后開始讀取文件
for (int k = rowStart; k < rs.getRows(); k++) {
if (flag == false) {
break;
}
String day = rs.getCell(0, k).getContents();
// 當文件的日期列,數(shù)據為空時停止操作
if (day.equals("")) {
break;
}
// 將日期轉換成YYYY-MM-DD格式
OndutyDate = year + "-" + month + "-" + day;
Cell onTimeCell = rs.getCell(2, k);
onTime = String.valueOf(FormateTime(onTimeCell));
Cell offTimeCell = rs.getCell(3, k);
offTime = String.valueOf(FormateTime(offTimeCell));
Remark = rs.getCell(4, k).getContents();
WorkTime = rs.getCell(5, k).getContents();
OverTime = rs.getCell(6, k).getContents();
WorkFlag = rs.getCell(7, k).getContents();
System.out.println(OndutyDate);
System.out.println(onTime);
System.out.println(offTime);
System.out.println(Remark);
System.out.println(WorkTime);
System.out.println(OverTime);
System.out.println(WorkFlag);
}
rwb.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String args[]){
readExcel readexcel=new readExcel();
String filePath="C:/modual.xls";
readexcel.ReadExcelToDb(filePath);
}
}
|
