Em Andamento

Excel MS Message Queue 3 integration

I need an application with Excel integration:

The application ([url removed, login to view] 2.0) should be able to read a text file which consists of news headlines, and feed this information through using Microsoft Message Queuing 3 into Excel. Each headline should be passed individually to the queue. Each headline consist of several fields:

headine_id

? ? ? ? ? ? ? ? ? ? ? source? category

? ? ? ? ? ? ? ? ? ? ? tickers

? ? ? ? ? ? ? ? ? ? ? pub_date_time

? ? ? ? ? ? ? ? ? ? ? date_added

? ? ? ? ? ? ? ? ? ? ? time_OFFSET?

HL_CONTENT? ? ? ? ? ? ? ? ? ?

STORY_id

Filtername

story_body

ts

The whole process has to work asynchronously.

Excel should get an event when there is a new headline in the queue and retrieve the content into cells on a sheet.

Excel itself is running a macro related to another activity (every x seconds), which could interfere with events raised from the message queue.

I have attached a sample text file with news headlines for input into the message queue (the columns are TAB delimited), and an Excel spreadsheet which simulates running a macro every x seconds.

Important is that the latency from when the news headlines are inserted into the message queue to when Excel should have the headline in the cells is minimized (sub 100 milliseconds is required for when NO macro in Excel is running). Of course, when Excel is running its own marco every x seconds, a higher latency will result.

?

The message queue has to be implemented with Microsoft Message Queuing 3

The queue writer has to be implemented in [url removed, login to view] 2.0

?

Habilidades: PHP

Ver mais: microsoft excel spreadsheet, microsoft macro, vb excel, queuing, queue, minimized, message queue, tab delimited text, activity spreadsheet, event spreadsheet, sample visual basic excel, sheet excel visual basic, queue php, php excel read, microsoft marco, php excel macro, excel macro php, excel input required, excel text columns, excel basic content, microsoft excel macro, read excel file sheet, php excel application, excel input sheet, excel integration

Acerca do Empregador:
( 60 comentários ) Netherlands

ID do Projeto: #2977822

Premiar a:

nskprogrammereu

See private message.

$85 USD em 3 dias
(101 Avaliações)
6.3

4 freelancers estão ofertando em média $68 para este trabalho

DebasisB

See private message.

$85 USD in 3 dias
(144 Comentários)
7.0
alienwebsl

See private message.

$59.5 USD in 3 dias
(6 Comentários)
2.7
fluentcoder

See private message.

$42.5 USD in 3 dias
(0 Comentários)
2.9