我正在嘗試使用EPPlus導(dǎo)出Excel文件 if (FileUpload1.HasFile && Path.GetExtension(FileUpload1.FileName) == ".xlsx") { bo.ExcelFile = txtFileName.Text; bo.ExcelFileBranch = txtBranchName.Text; bo.ExcelFileFromDate = txtValidFrom.Text; bo.ExcelFileToDate = txtValidTo.Text; using (var excel = new ExcelPackage(FileUpload1.PostedFile.InputStream)) { var tbl = new DataTable(); var ws = excel.Workbook.Worksheets.First(); var hasHeader = false; // adjust accordingly // add DataColumns to DataTable foreach (var firstRowCell in ws.Cells[1, 1, 1, ws.Dimension.End.Column]) tbl.Columns.Add(hasHeader ? String.Format("Column {0}", firstRowCell.Start.Column) : firstRowCell.Text); // add DataRows to DataTable int startRow = hasHeader ? 1 : 2; for (int rowNum = startRow; rowNum <= ws.Dimension.End.Row; rowNum++) { var wsRow = ws.Cells[rowNum, 1, rowNum, ws.Dimension.End.Column]; DataRow row = tbl.NewRow(); foreach (var cell in wsRow) row[cell.Start.Column - 1] = cell.Text; tbl.Rows.Add(row); }但是我收到以下錯(cuò)誤:(來自HRESULT的異常:0x8003001D(STG_E_WRITEFAULT))“-寫入操作期間發(fā)生磁盤錯(cuò)誤
1 回答

一只萌萌小番薯
TA貢獻(xiàn)1795條經(jīng)驗(yàn) 獲得超7個(gè)贊
不確定,但嘗試使用空白密碼讀取excel文件:
new ExcelPackage(FileUpload1.PostedFile.InputStream, ""))
- 1 回答
- 0 關(guān)注
- 511 瀏覽
添加回答
舉報(bào)
0/150
提交
取消