Issues with Azure.Storage.Blobs integration with ExcelDNA

[StervenMig]

Hi everyone,

I've work with ExcelDNA 1.9.0 and azure blobs connection for some years in Net framework, but the idea is to move to .Net 8.0 +, in order to update all the libraries on the project and some other requirements, but after the project was migrated, I've been facing an issue related to Azure, and every time I connect to azure and download/upload a blob file, after a few seconds I get this error.

{"Unable to read data from the transport connection: The I/O operation has been aborted because of either a thread exit or an application request.."}

I tried multiple things, like using threads, async functions, and even I tried Excel queueasmacro(because it is not used in a UDF), but there is no way to remove that exception caught by a FirstChanceException.

I would expect if someone has a better solution

[Govert van Drimmelen]

Could you perhaps post a small test example to GitHub that works with .NET Framework 4.8, but fails with .NET 8.0 ?

That would be a good start to debugging the issue.

 

-Govert

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/exceldna/397a895c-cb3a-453d-87fa-e21c3e3b559an%40googlegroups.com.

[StervenMig]

Hi Govert,

I was preparing an example for you, and here it is https://github.com/Stervang/Ribbon-ExcelDNA-Azure.git

It took long because in local environment like Azurite it works perfectly, using the same config except for the connection type, because in Azure is used DNS, and Azurite uses IPv4, but not sure if that impacts on that.

to get the exception, you just need to click on the button that calls the azurecontrol and then wait, or opening a file

let me know if you need something else.

Thanks,

Miguel

[Govert van Drimmelen]

Hi Miguel,

Thank you - I will have a look and see if I can reproduce and understand your error.

Regards,

Govert