facebooktwittermenuarrow-up

GemBox Support Forum

File not found error while loading

Hi, I am trying to read in a file I just saved.
I can confirm that the file does exist.
However, I am wondering if it’s an issue with the fact that we are using .Netcore50

The stack trace is:

Stack Trace

Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware[1]
An unhandled exception has occurred while executing the request.
System.IO.FileNotFoundException: Could not load file or assembly ‘System.IO.Packaging, Version=0.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’. The system cannot find the file specified.
File name: ‘System.IO.Packaging, Version=0.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a’
at GemBox.Spreadsheet.ZipBuilder…ctor(Stream , FileAccess )
at GemBox.Spreadsheet.XlsxLoadOptions.(ExcelFile , Stream )
at GemBox.Spreadsheet.XlsxLoadOptions.LoadCore(ExcelFile excelFile, Stream stream, String path)
at GemBox.Spreadsheet.LoadOptions.(ExcelFile , Stream , String )
at GemBox.Spreadsheet.LoadOptions.(ExcelFile , Stream , String , Boolean)
at GemBox.Spreadsheet.LoadOptions.Load(String )
at GemBox.Spreadsheet.ExcelFile.Load(String path, LoadOptions options)
at GemBox.Spreadsheet.ExcelFile.Load(String path)
at HostingCostPortal.TenKeyHelper.ShuckDataFromExcelFileIntoDb(String filePath) in C:\Git\panorama\PanoramaCore\TenKeyless\HostingCostPortal\Helpers\TenKeyHelper.cs:line 96
at Panorama.Controllers.TestController.FileUpload(IFormFile file) in C:\Git\panorama\PanoramaCore\Panorama\Controllers\HostingCostPortal\TestController.cs:line 87
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|24_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|19_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|17_0(ResourceInvoker invoker, Task task, IDisposable scope)
at Microsoft.AspNetCore.Routing.EndpointMiddleware.g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
at Microsoft.AspNetCore.Authorization.Policy.AuthorizationMiddlewareResultHandler.HandleAsync(RequestDelegate next, HttpContext context, AuthorizationPolicy policy, PolicyAuthorizationResult authorizeResult)
at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext)
at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider)
at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context)

Hi Brian,

What version of GemBox.Spreadsheet are you using, can you write what value you get for SpreadsheetInfo.FullVersion?

Note, the newer versions of GemBox.Spreadsheet no longer use System.IO.Packaging for reading (and writing) XLSX files.
Nevertheless, perhaps you could try installing System.IO.Packaging NuGet.

Does this solve your issue?

Regards,
Mario

Hi it looks like we are using:
39.3.30.1048

Installing that package fixed the problem. thanks!