Embed RFA in 32bit .Net addin
Hi,
I am working on a project to embed the RFA library in an existing 32-bit .NET Excel addin so that users can query Reuters data straight from their spreadsheet.
The addin is compiled for 32 bits as our users have either Excel 2010 or 2016 32 bit versions installed on their machines.
What is the recommended way of embedding the RFA library version 8 into a 32 bit application? As far as I can tell, the .Net wrapper only exists in the 64 bit flavour. According to what I've read elsewhere, the RFA v7 library, which has a 32 bit version, is considered obsolete.
I can't believe Reuters decided to drop the support for 32 bit applications with no fallback plan. What's the workaround that I'm missing here?
Thanks!
RFA.NET 8.x only provides 64 bit libraries so it will not work as an addin for Excel 32 bit.
Therefore, you need to run a RFA.NET 64 bit application as a separated process, such as Windows service and then use inter-process communication to send and receive data between the Excel and RFA.NET process.