dimanche 29 mars 2015

Excel and RabbitMQ - Process RabbitMQ Messages in Excel?

I would like to subscribe to a RabbitMQ message queue from Excel 2013.


The ultimate aim is to allow data contained within a MQ message to be processed within Excel and to also allow Excel to send a formatted message via a RabbitMQ message queue.


Is this possible?


The message which is sent down the message queue is comprised of 7 fields, each field is delimited by a ; symbol - however the message is sent as one string over the message queue...


e.g. "text;number;number;number;text,text,timestamp"


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


Can this be done?


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


Any pointers will be much appreciated, for example can this be done via VBA code or an Excel Add-In?


Thanks in advance...


Aucun commentaire:

Enregistrer un commentaire