Færdiggjort

Excel Spreadsheet Update Service

I need a Windows Service that updates an Excel object called "QueryTable" inside many? Excel Spreadsheets.

Once a day, this service must update the "Url" value of "QueryTable" object inside the Excel Spreadsheet and save the change in the spreadsheet to disk.

The Windows Service will run on its own server and will update approximately 500 spreadsheets per night.

We tried creating a similar app several years ago using COM to Excel Version 2003 and were not sucessful.? The server would run for a while, then crash.? Maybe now the latest version of Excel has new functionality that will allow it to work. Maybe you know of a 3rd party component that will perform this functionality.

Please do not respond unless you already have implemented a? Windows Service application like this.?

FYI -? QueryTable Object in Excel is described here:

<[url removed, login to view]>

The code to modify the QueryTable is as follows:

Set sheet1 = Workbooks(1).Worksheets(1)

Set qtData = [url removed, login to view] _

? ? ? .Add(Connection := "URL;http://datasvr/98q1/[url removed, login to view]", _

? ? ? ? ? ? ? Destination := [url removed, login to view](1,1))

With qtData

? ? ? .WebFormatting = xlNone

? ? ? .WebSelectionType = xlSpecifiedTables

? ? ? **.WebTables** = "1,2"

? ? ? .Refresh

End With

We will provide the service code.? You provide the component code to update the Spreadsheet and save it.

## Deliverables

We are looking for proof of concept only.

If the Windows Service you create is able to load a single Excel Spreadsheet into memory (you can create your own spreadsheet), update the "[url removed, login to view]" property, then save the Excel Spreadsheet to disk 500 times, each file with a different filename (so we end up with 500 files), without crashing, and with reasonable performance (ie., not all night and not excessive memory consumption), then you are done.

* * *This broadcast message was sent to all bidders on Friday Oct 17, 2008 6:34:15 PM:

It is the end of the day here. I will get back to you again tomorrow morning. Thank you for your interest.

* * *This broadcast message was sent to all bidders on Monday Oct 20, 2008 3:49:07 PM:

I am close to accepting one of the existing bids. I expect to get approval today. Please discontinue any further analysis of this project until you have been notified that your bid has been selected. Thank you for your submissions!

Evner: C# Programmering, Ingeniørarbejde, Microsoft, MySQL, PHP, Projekt Ledelse, Software Arkitektur, Software Testning, Windows Skrivebord

Se mere: service spreadsheet, new spreadsheet app, microsoft excel spreadsheet, en save, microsoft spreadsheets, windows service, service http windows, save to excel, load 500 url, friday night, excel work today, excel to app, excel spreadsheet, excel service, excel app, en excel, create spreadsheet, analysis excel, analysis excel spreadsheet, update url

Om arbejdsgiveren:
( 1 bedømmelse ) United States

Projekt ID: #3317836

Tildelt til:

StanDotNet

See private message.

$1700 USD in 14 dage
(298 bedømmelser)
8.1

9 freelancere byder i gennemsnit $1048 på dette job

ShamilS

See private message.

$509.15 USD in 14 dage
(120 bedømmelser)
8.3
MicroXpress

See private message.

$595 USD in 14 dage
(100 bedømmelser)
7.3
rahulrastogi2

See private message.

$1530 USD in 14 dage
(4 bedømmelser)
4.6
uponheaven

See private message.

$935 USD in 14 dage
(12 bedømmelser)
3.5
arkotechvw

See private message.

$1700 USD in 14 dage
(4 bedømmelser)
3.6
nanocomputer

See private message.

$1530 USD in 14 dage
(9 bedømmelser)
3.5
vbguru1vw

See private message.

$425 USD in 14 dage
(1 bedømmelse)
1.1
vw7066068vw

See private message.

$510 USD in 14 dage
(0 bedømmelser)
0.0