Excel and RabbitMQ - handle RabbitMQ messages in Excel?

Question

I want to subscribe to the RabbitMQ message queue from Excel 2013.

The ultimate goal is to provide the data contained in the MQ message, be processed in Excel, and also allow Excel to send a formatted message through the RabbitMQ message queue.

Is it possible?

A message sent to the message queue consists of 7 fields, each field is separated by a; character - however, the message is sent as one line above the message queue ...

eg. "text;number;number;number;text,text,timestamp"

I would like to be able to split the raw message, as stated above, into formatted cells in Excel 2013.

Can this be done?

I have limited coding experience and am trying to learn, so please forgive me if this is a "stupid" question.

Any pointers would be much appreciated, for example, can this be done using VBA code or an Excel add-in?

Thanks in advance...

Answer 1

First, the bad news : there is no easy way to do this.

Now the good news is : if you really want it, you can probably do it in at least two different ways.

, , , () , , . , , , , , . .

:

• Excel .NET / . , Visual Studio, .NET. : https://msdn.microsoft.com/en-us/library/bb157876.aspx -- https://www.rabbitmq.com/tutorials/tutorial-one-dotnet.html.
  • : ,
  • : , , , , .
• COM Interop .NET, DLL- RabbitMQ.NET. .NET, , . , () : .NET DLL COM?. COM- Excel/Office, DLL VBA.
  • : , RabbitMQ Excel VBA Excel.
  • : .
• STOMP RabbitMQ ( , /sys admin) VBA. , - .NET voodoo, ActiveX MSWINSCK.OCX . StackOverflow : MSWinsock.Winsock VisualBasic
  • : ( , )
  • : , ActiveX. RabbitMQ, .

, , , , , , , , . , , ...

Answer 2

MQTT AddIn for Excel MQTT. - , : Excel MQTT Addin

Answer 3

, Excel MQTT http://cdn.ebridge.io/downloads/ExcelMQTT.zip " ." Chrome Internet Explorer...