NPOI导入数据

一杯浊酒笑风尘

已于 2022-03-04 16:36:12 修改

阅读量391

点赞数

分类专栏： C# 文章标签： c#

于 2021-11-01 18:20:59 首次发布

本文为博主原创文章，未经博主允许不得转载。

本文链接：https://blog.csdn.net/qq_41630695/article/details/121085534

版权

C# 专栏收录该内容

63 篇文章 2 订阅

订阅专栏

前面得到excel后，转化为字节数据

 using (FileStream fileStream = new FileStream(dlg.FileName, FileMode.Open, FileAccess.Read))
                        {
                            byte[] upBytes = new byte[fileStream.Length];
                            fileStream.Read(upBytes, 0, upBytes.Length);
                            fileStream.Close();
                            multiFileUpByte.Add(upBytes);
                        }

得到字节数据后，在服务器

 foreach (var item in bytes)
            {
                Stream stream = new MemoryStream(item);
                IWorkbook workBook = WorkbookFactory.Create(stream);

                ISheet sheet = workBook.GetSheet("Sheet1");
                if (sheet == null) return;
                IRow firstRow = sheet.GetRow(0);

                int colCount = firstRow.LastCellNum;
                int rowCount = sheet.LastRowNum;
                object value;
                string error = "";
                for (int i = rowCount; i > 0; i--)
                {
                    IRow row = sheet.GetRow(i);
                    if (row == null || row.Cells == null || row.Cells.Count == 0)
                        continue;
                   string Name,Name1,Name2;
                    value = SheetHelper.GetCellValue(row.GetCell(SheetHelper.ColumnNameToIndex("A")));
                    if (value != DBNull.Value && !string.IsNullOrEmpty(value.ToString()))
                        Name= value.ToString();
                    value = SheetHelper.GetCellValue(row.GetCell(SheetHelper.ColumnNameToIndex("B")));
                    if (value != DBNull.Value && !string.IsNullOrEmpty(value.ToString()))
                        Name1 = value.ToString();
                    value = SheetHelper.GetCellValue(row.GetCell(SheetHelper.ColumnNameToIndex("C")));
                    if (value != DBNull.Value && !string.IsNullOrEmpty(value.ToString()))
                    {
                        Name2= value.ToString();
                    }                   
                }
            }