C# 使用ExcelReader 上传excel

最新推荐文章于 2024-08-09 07:10:35 发布

_iorilan

最新推荐文章于 2024-08-09 07:10:35 发布

阅读量1.5k

点赞数 1

分类专栏： c# 编程

本文链接：https://blog.csdn.net/lan_liang/article/details/79178013

版权

c# 编程专栏收录该内容

294 篇文章 4 订阅

订阅专栏

C# 使用ExcelReader 上传excel

using (var reader = ExcelReaderFactory.CreateReader(stream))
            {
                if (reader.ResultsCount > 50)
                {
                    TempData["error"] = "The maximum row while uploading is 50";
                    return RedirectToAction("UploadResult");
                }
                else
                {
                    var list = new List<Sample>();
                    var service = new YourService();
                    do
                    {
                        while (reader.Read())
                        {
                             by pass column name row
                            if (isReadingColumn)
                            {
                                continue;
                            }


                            var obj = service.GetObjFromReader(reader);
                            list.Add(obj);
                        }
                    } while (reader.NextResult());
		}
	   }


     public Sample GetObjFromReader(IExcelDataReader reader)
        {
            // those are the columns specified in excel template
            // ************* must follow the sequence **************
	    // Field1
	    // Field2
	    // DateField
	    // ...
            try
            {
                var obj = new Sample();
                obj.Field1 = reader.GetString(0);
                obj.Field2 = reader.GetString(1);
		var dtStr = FromExcelDate(reader.GetDouble(2));
                obj.DOB = dtStr;
              ...
                return obj;
            }
            catch (Exception ex)
            {
		...
            }
        }
        private static DateTime FromExcelDate(double value)
        {
            return new DateTime(1899, 12, 30).AddDays(value);
        }