7:
8: namespace Core.DarrenExcelHelper
9: {
10: /// <summary>
11: /// 描述:對 Excel 文件的創建表、讀取、寫入數據操作.
12: /// 程序員:谢堂文(Darren Xie)
13: /// 創建日期:
14: /// 版本:1.0
15: /// </summary>
16: public static class MyExcelUtls
17: {
18: #region 取文件的擴展名
19: /// <summary>
20: /// 取文件的擴展名
21: /// </summary>
22: /// <param name="FileName">文件名稱</param>
23: /// <returns>string</returns>
24: public static string GetExtFileTypeName(string FileName)
25: {
26: string sFile = FileName;// myFile.PostedFile.FileName;
27: sFile = sFile.Substring(sFile.LastIndexOf("\\") + 1);
28: sFile = sFile.Substring(sFile.LastIndexOf(".")).ToLower();
29: return sFile;
30: }
31: #endregion
32:
33: #region 檢查一個文件是不是 2007 版本的 Excel 文件
34: /// <summary>
35: /// 檢查一個文件是不是 2007 版本的 Excel 文件
36: /// </summary>
37: /// <param name="FileName">文件名稱</param>
38: /// <returns>bool</returns>
39: public static bool IsExcel2007(string FileName)
40: {
41: bool r;
42: switch (GetExtFileTypeName(FileName))
43: {
44: case ".xls":
45: r = false;
46: break;
47: case ".xlsx":
48: r = true;
49: break;
- 1
- 2
- 3
前往页