A disk error occurred during a write operation. (Exception from HRESULT: 0x8003001D (STG_E_WRITEFAULT))

15.1k views Asked by At

I am using EPPlus to read .csv file in vb.net. When I run this code, I get the error "A disk error occurred during a write operation.

(Exception from HRESULT: 0x8003001D (STG_E_WRITEFAULT))"

Here is my code :

Public Function ImportExcelSheet(ByVal filePath As String) As DataTable
    Dim dtImportData As New DataTable()
    Try
        'If csv file have header then "true" else "false"
        Dim hasHeader As Boolean = True
        Using pck = New OfficeOpenXml.ExcelPackage()
            Using stream = File.OpenRead(filePath)
                pck.Load(stream)
            End Using

What should I do to fix this error?

2

There are 2 answers

0
Cyborg On

I had the same error with a plugin I had created to import from excel. Originally I had saved the import file as .xls.

I opened this excel spreadsheet and resaved as .xlsx.

This solved the problem.

So maybe it is the file format that the csv was saved as.

0
Raymond Anderson On

I get the same error reading xls file. It turns out the workbook had hidden rows on the first sheet. I inspected the document and removed the hidden rows and it worked perfectly