OpenXml SpreadsheetDocument.Open(...) get exception - The main part is missing

c# .net excel xls openxml-sdk
Shir picture Shir · Apr 23, 2014 · Viewed 12.8k times · Source

I have an xlsx doc with headers and it is located in my project path. I want to insert data using OpenXML but I get an exception while opening the file:

using (SpreadsheetDocument myDoc = SpreadsheetDocument.Open(MyxlsFileName, true))
{
    // ...
}

The exception:

"The specified package is invalid. The main part is missing"

What is the meaning of the exception and what is wrong?

Thank in advance!

Answer

tom_imk picture tom_imk · Oct 6, 2015

While this might be very obvious, it happened to me: Another situation that might trigger the excact same error is when you get the name of the file wrong. So check that you really have the path right, for me I ended up with a newly created file (with the wrong spelling) but still got the very same error.

Related questions

Autofit column in ClosedXML.Excel

I understand that the question stupid and from FAQ, but i cant set auto width in excel columns (using ClosedXML.Excel library) my code: var wb = new XLWorkbook(); var wsDep = wb.Worksheets.Add("MyWorksheet"); wsDep.Columns("A").AdjustToContents(); wsDep.Columns("…

Read More
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?

How can I create an Excel spreadsheet with C# without requiring Excel to be installed on the machine that's running the code?

Read More
Reading Excel files from C#

Is there a free or open source library to read Excel files (.xls) directly from a C# program? It does not need to be too fancy, just to select a worksheet and read the data as strings. So far, I've …

Read More