Cancelled

Excel files from a web page

I have a an ASP.NET site that can provide a Excel file as a web link for example http://sitename/resolver/[url removed, login to view]

This brings back a bytestream from an API and a file name e.g. "[url removed, login to view]".

I would like the url to be something like http://sitename/resolver/ref/123 or http://sitename/resolver/ref/123/rates.xlsx.

The ure needs to be able to resolve in Excel (2010 preferably) so it can be used in an external reference in an other spreadsheet. For example the other spreadsheet will have a formula like:

='http://sitename/resolver/ref/123/[[url removed, login to view]]Sheet1'!$D$16

So far I have the following code:

[url removed, login to view]([url removed, login to view]);

string recno = [url removed, login to view]["ref"];

IStream s = [url removed, login to view](null, false, null);

[url removed, login to view]();

[url removed, login to view]("Content-Disposition", "filename=" + [url removed, login to view]);

[url removed, login to view]("Content-Length", [url removed, login to view]());

[url removed, login to view] = false;

[url removed, login to view] = GetContentType([url removed, login to view]); // [url removed, login to view] returns the file extention.

// GetContentType resolves to "application/octet-stream" for xlsx

uint BufferSize = 10000;

uint DocumentLength = (uint) [url removed, login to view];

byte[] buffer = new byte[BufferSize];

uint bytesread;

uint totalread = 0;

Stream outstream = [url removed, login to view];

while (totalread < DocumentLength)

{

[url removed, login to view](out buffer[0], 10000, out bytesread);

if (bytesread < 10000)

{

for (uint i = 0; i < bytesread; i++)

{

[url removed, login to view](buffer[i]);

}

}

else

{

[url removed, login to view](buffer, 0, 10000);

}

totalread += bytesread;

}

[url removed, login to view]();

[url removed, login to view]();

return;

I need an ASP.NET site written for .Net 3.5 that can use the required URL and that URL can be used in an Excel spreadsheet as an external reference. I also need a few lines of instruction to install on IIS 7

Please respond with your proposed URL in a private message.

Thank you for considering this project.

Skills: C# Programming

See more: web page spreadsheet, spreadsheet web page, spreadsheet to web application, spreadsheet on web page, spreadsheet in web page, programming instruction, programming in excel 2010, programming in excel, iis web application, excel to application, cache programming, excel spreadsheet formula, web page programming, spreadsheet API, net excel programming, excel formula spreadsheet spreadsheet, programming iis, iis api, excel use api, content disposition, web page net, aspx resolve, excel excel 2010, instruction page, web api required

About the Employer:
( 6 reviews ) Sydney, Australia

Project ID: #5799984

7 freelancers are bidding on average $434 for this job

AlexMDumitru

Hi, You don't need to write code to change the form of your URL. All you have to do is to install URL Rewrite Module on IIS an then just write regular expressions for the form of the URL. You can see a example here: More

$555 AUD in 3 days
(6 Reviews)
4.5
AEGLESol

Hi there, I have 4+ years experience in .Net web development. I have studied the project description and I can do it with in time and budget. Please respond to discuss it further so that I can start working on it imme More

$777 AUD in 10 days
(3 Reviews)
3.7
gjinfotech004

hello sir, Experienced asp.net developer here. I have 5+ year experience in asp.net and i can complete your project. thank you.

$333 AUD in 10 days
(4 Reviews)
3.7
QingSong083

Dear sir! Please check my job history. I am talented developer can help you perfectly I can start your job immediately and complete with high quality. Thanks.

$777 AUD in 10 days
(2 Reviews)
3.1
quicksoftprovw

Greetings, I am top rated on freelancer with 100% completion rate. I have very good experience (10+ years) in c# and Web development. I am founder of quicksoftpro and provide software services to customers acros More

$722 AUD in 20 days
(1 Review)
3.0
talhamunir2002

A proposal has not yet been provided

$666 AUD in 10 days
(0 Reviews)
0.0
bishnupaul

Dear sir we have gone through your project and also discussed with our expert team. we are happy to inform you that we will solve and deliver your project in 15 days. thank you regards Bishnu

$316 AUD in 15 days
(0 Reviews)
0.0
rajeevmax12

A proposal has not yet been provided

$555 AUD in 10 days
(0 Reviews)
0.0
sabulgp

A proposal has not yet been provided

$250 AUD in 10 days
(0 Reviews)
0.0
duncan1382

Although I have no history on this site, I am trying to get my reputation up. I have confidence that I can complete this project in the specified time for the minimum price offering. I graduated Michigan State Unive More

$250 AUD in 10 days
(0 Reviews)
0.0