.xlsb file in DocumentFormat.OpenXml.Packaging throwing error of OpenXmlPackageException: 'The specified package is not valid.'

MahidaMahenoor-7372 20 Reputation points
2023-04-05T13:06:31.1566667+00:00

.xlsb file in DocumentFormat.OpenXml.Packaging throwing error of OpenXmlPackageException: 'The specified package is not valid.'

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,684 questions
Office Open Specifications
Office Open Specifications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Open Specifications: Technical documents for protocols, computer languages, standards support, and data portability. The goal with Open Specifications is to help developers open new opportunities to interoperate with Windows, SQL, Office, and SharePoint.
127 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
0 comments
Accepted answer
  1. Tom Jebo 1,991 Reputation points Microsoft Employee
    2023-04-06T17:15:42.0833333+00:00

    Hi @Mahenoor Mahida

    The Open XML SDK is better discussed on the following sites:

    https://stackoverflow.com/questions/tagged/openxml-sdk
    https://github.com/dotnet/Open-XML-SDK/issues

    Your question is specifically answered on:

    https://github.com/dotnet/Open-XML-SDK/issues/617

    The .xlsb file extension is an ISO 29500-2 OPC (Open Packaging Convention) package like the .xlsx, .docx and .pptx, however, the contents of the workbook, worksheet, etc... parts is not SpreadsheetML (i.e. XML) but Excel's binary format. Therefore it is not supported by the Open XML SDK which only supports WordprocessingML, SpreadsheetML and PresentationML (and DrawingML). Files with the .xlsb extension follow this file format specification:

    [MS-XLSB]: Excel (.xlsb) Binary File Format

    Hope this helps.

    Best regards,
    Tom Jebo
    Microsoft Open Specifications Support

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest