EPPlus 是.net的一个操作Excel的插件，封装了针对Excel的读取、写入等操作，并且该项目还是开源的。关于EPPlus的更多介绍我就不赘述了，可查看：http://epplus.codeplex.com/
这里我简单的介绍如何将Excel的Sheet转换成DataTable，关于安装和其他的相关操作请谷歌或者百度下。
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 |
using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Text; using System.Threading.Tasks; using EPPlus.Extensions; using OfficeOpenXml; using System.IO; namespace ManageSys.Utility { /// <summary> /// 使用 EPPlus 第三方的组件读取Excel /// </summary> public class EPPlusHelper { private static string GetString(object obj) { try { return obj.ToString(); } catch (Exception ex) { return ""; } } /// <summary> ///将指定的Excel的文件转换成DataTable （Excel的第一个sheet） /// </summary> /// <param name="fullFielPath">文件的绝对路径</param> /// <returns></returns> public static DataTable WorksheetToTable(string fullFielPath) { try { FileInfo existingFile = new FileInfo(fullFielPath); ExcelPackage package = new ExcelPackage(existingFile); ExcelWorksheet worksheet = package.Workbook.Worksheets[1];//选定 指定页 return WorksheetToTable(worksheet); } catch (Exception) { throw; } } /// <summary> /// 将worksheet转成datatable /// </summary> /// <param name="worksheet">待处理的worksheet</param> /// <returns>返回处理后的datatable</returns> public static DataTable WorksheetToTable(ExcelWorksheet worksheet) { //获取worksheet的行数 int rows = worksheet.Dimension.End.Row; //获取worksheet的列数 int cols = worksheet.Dimension.End.Column; DataTable dt = new DataTable(worksheet.Name); DataRow dr = null; for (int i = 1; i <= rows; i++) { if (i > 1) dr = dt.Rows.Add(); for (int j = 1; j <= cols; j++) { //默认将第一行设置为datatable的标题 if (i == 1) dt.Columns.Add(GetString(worksheet.Cells[i, j].Value)); //剩下的写入datatable else dr[j - 1] = GetString(worksheet.Cells[i, j].Value); } } return dt; } } } |
发布者：柚子，转转请注明出处：https://ityouzi.com/archives/2373.html
微信扫一扫 
支付宝扫一扫 
