Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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?

like image 549
Margaretha Avatar asked Feb 09 '23 20:02

Margaretha


1 Answers

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.

like image 103
Cyborg Avatar answered May 27 '23 07:05

Cyborg