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

4

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?

asp.net
vb.net
opencsv
asked on Stack Overflow Jun 16, 2015 by Margaretha • edited Jun 16, 2015 by bytecode77

2 Answers

7

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.

answered on Stack Overflow Aug 17, 2016 by Cyborg
1

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

answered on Stack Overflow Jul 29, 2016 by Raymond Anderson

User contributions licensed under CC BY-SA 3.0