C# 将excel导入到datatable

最新推荐文章于 2024-01-19 16:36:54 发布

ゞ瀟灑亾眚ゞ

最新推荐文章于 2024-01-19 16:36:54 发布

阅读量1.3k

点赞数

本文链接：https://blog.csdn.net/qq_41078088/article/details/116239094

版权

本文介绍如何使用C#将Excel文件内容导入到DataTable，并详细说明了如何在过程中修改列名。适用于MVC项目的Excel上传操作。

摘要由CSDN通过智能技术生成

将excel导入到datatable ,并修改列名

   /// <summary>
    /// 将excel导入到datatable
    /// </summary>
    /// <param name="fs">Stream文件流</param>
    /// <param name="isColumnName">第一行是否是列名</param>
    /// <param name="isReplace">是否替换表头</param>
    /// <returns>返回datatable</returns>
    public static DataTable ExcelToDataTable(this Stream fs, bool isColumnName = true, Dictionary<string, string> list = null, bool isReplace = false)
    {
        DataTable dataTable = null;
        DataColumn column = null;
        DataRow dataRow = null;
        IWorkbook workbook = null;
        ISheet sheet = null;
        IRow row = null;
        ICell cell = null;
        int startRow = 0;
        try
        {
            workbook = new HSSFWorkbook(fs);

            if (workbook != null)
            {
                sheet = workbook.GetSheetAt(0);//读取第一个sheet，当然也可以循环读取每个sheet
                dataTable = new DataTable();
                if (sheet != null)
                {
                    int rowCount = sheet.LastRowNum;//总行数
                    if (rowCount > 0)
                    {
                        IRow firstRow = sheet.GetRow(0);//第一行
                        int cellCount = firstRow.LastCellNum;//列数

                        //构建datatable的列
                        if (isColumnName)
                        {
                            start