diff --git a/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/Excel/XLWorkbook_Load.cs index 4021d7a..cf84f81 100644 --- a/ClosedXML/Excel/XLWorkbook_Load.cs +++ b/ClosedXML/Excel/XLWorkbook_Load.cs @@ -629,6 +629,10 @@ foreach (var anchor in drawingsPart.WorksheetDrawing.ChildElements) { var imgId = GetImageRelIdFromAnchor(anchor); + + //If imgId is null, we're probably dealing with a TextBox (or another shape) instead of a picture + if (imgId == null) continue; + var imagePart = drawingsPart.GetPartById(imgId); using (var stream = imagePart.GetStream()) { diff --git a/ClosedXML_Tests/ClosedXML_Tests.csproj b/ClosedXML_Tests/ClosedXML_Tests.csproj index 93106ce..1542b4d 100644 --- a/ClosedXML_Tests/ClosedXML_Tests.csproj +++ b/ClosedXML_Tests/ClosedXML_Tests.csproj @@ -1,296 +1,297 @@ - - - - Debug - AnyCPU - - - 2.0 - {09B066ED-E4A7-4545-A1A4-FF03DD524BDF} - Library - Properties - ClosedXML_Tests - ClosedXML_Tests - v4.5.2 - 512 - {3AC096D0-A1C2-E12C-1390-A8335801FDAB};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC} - ..\ - true - - - true - full - false - bin\Debug\ - DEBUG;TRACE;$(AppVeyor) - prompt - 4 - false - - - pdbonly - true - bin\Release\ - TRACE;$(AppVeyor) - prompt - 4 - false - - - true - - - ClosedXML.snk - - - - ..\packages\DocumentFormat.OpenXml.2.7.2\lib\net40\DocumentFormat.OpenXml.dll - True - - - - ..\packages\NUnit.3.7.1\lib\net45\nunit.framework.dll - True - - - - - 3.5 - - - - - - - - - - - Properties\AssemblyVersionInfo.cs - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - {BD5E6BFE-E837-4A35-BCA9-39667D873A20} - ClosedXML - - - {03A518D0-1CB7-488E-861C-C4E782B27A46} - ClosedXML_Examples - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - .editorconfig - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + + + + Debug + AnyCPU + + + 2.0 + {09B066ED-E4A7-4545-A1A4-FF03DD524BDF} + Library + Properties + ClosedXML_Tests + ClosedXML_Tests + v4.5.2 + 512 + {3AC096D0-A1C2-E12C-1390-A8335801FDAB};{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC} + ..\ + true + + + true + full + false + bin\Debug\ + DEBUG;TRACE;$(AppVeyor) + prompt + 4 + false + + + pdbonly + true + bin\Release\ + TRACE;$(AppVeyor) + prompt + 4 + false + + + true + + + ClosedXML.snk + + + + ..\packages\DocumentFormat.OpenXml.2.7.2\lib\net40\DocumentFormat.OpenXml.dll + True + + + + ..\packages\NUnit.3.7.1\lib\net45\nunit.framework.dll + True + + + + + 3.5 + + + + + + + + + + + Properties\AssemblyVersionInfo.cs + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + {BD5E6BFE-E837-4A35-BCA9-39667D873A20} + ClosedXML + + + {03A518D0-1CB7-488E-861C-C4E782B27A46} + ClosedXML_Examples + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + .editorconfig + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/ClosedXML_Tests/Excel/Loading/LoadingTests.cs b/ClosedXML_Tests/Excel/Loading/LoadingTests.cs index a932317..218ae90 100644 --- a/ClosedXML_Tests/Excel/Loading/LoadingTests.cs +++ b/ClosedXML_Tests/Excel/Loading/LoadingTests.cs @@ -26,7 +26,8 @@ @"Misc\ExcelProducedWorkbookWithImages.xlsx", @"Misc\InvalidPrintTitles.xlsx", @"Misc\ExcelProducedWorkbookWithImages.xlsx", - @"Misc\EmptyCellValue.xlsx" + @"Misc\EmptyCellValue.xlsx", + @"Misc\AllShapes.xlsx" }; foreach (var file in files) diff --git a/ClosedXML_Tests/Resource/Misc/AllShapes.xlsx b/ClosedXML_Tests/Resource/Misc/AllShapes.xlsx new file mode 100644 index 0000000..2c5b324 --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/AllShapes.xlsx Binary files differ