Demonstrating a simple web service to export/import data into Excel sheet

$30-250 USD

Completed

Posted

over 8 years ago

$30-250 USD

Paid on delivery

My company has a proprietary Excel macro-based spreadsheet that makes complex calculations locally on the sheet. I would like to create a simple prototype that demonstrates how a Excel spreadsheet can export about 20 variables to a secure web-based program, and have that program return a solution matrix of about 30 variables (some as an array). This provides my company new options for maintenance and security of our proprietary code. We require that the program be written in a simple language easy for an engineer to code. Currently, functions are in Visual Basic for Applications, but any similar language is acceptable. We will write the proprietary engineering program, but need help with the export/import demonstration. I propose to create a simple demo sheet in Excel with 20 exporting variables from cells, and require the prototype to populate a 30 variable matrix back into other cells. (Prototype program can return arbitrary values.) Provider must help identify suitable secure hosting platform. I currently have access to both a PHP based wordpress server, a ASP (ASP.NET) Microsoft web hosting server, a Windows workstation permanently connected to the net, or can lease a low-cost service from a secure independent provider. Looking for a simple demonstration prototype with an affordable cost.

Excel

Microsoft

Web Services

Project ID: 9248374

About the project

3 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@bspanovic

Hello You can look and test one of mine application's on this link: [login to view URL] Log on as jrellsve , paswword is jrellsve I'm Microsoft Certified Database Developer. My Microsoft transcript you can check on this link: [login to view URL] I have 20+ years experience with Access and 15+ with SQL Server. With work I could start immediately. If needed I will adjust my working hour's to your time zone. RGD's Borut Spanovic

$200 USD in 5 days

5.0

(5 reviews)

0.0

3 freelancers are bidding on average $195 USD for this job

@mattsrinc

Hi, Matt here and can help you (software developer for 21 years). What you need is a simple PHP script on your web server that will act as a web service - your desired automation can not be done within Excel or Windows itself. So you need to provide working PHP interpreter with CURL library so that: 1. VBA macro calls your custom PHP script that will visit your web page, log in, open a table, post a value and retrieve resulted table. 2. Resulted table is returned to Excel (VBA) as a formatted string. 3. VBA function parses the returned string, counts the number of elements (to get a cell range) and fills values into a range of cells with a defined first cell. That's what I can do (haven't for some time). Is this solution workable for you? Or you would rather have pure client e.g. desktop solution without requiring a web server script? Then it would be possible to automate your process with automation software (proposing Sikuli or AutoIT). The issue here is how to integrate this into Excel e.g. it would be the other way around - calling the automation script via at (scheduler in Windows) that visits the web page, retrieves the data, opens an Excel file and fills it with returned data. No costly security options are needed - PHP script is protected (source) by default while you can easily restrict access to your website script if you are using fixed IP address in your company. That might limit access from anywhere though. Looking forward to hear your opinion, Matt

$220 USD in 4 days