I have a an ASP.NET site that can provide a Excel file as a web link for example http://sitename/resolver/[login to view URL]
This brings back a bytestream from an API and a file name e.g. "[login to view URL]".
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/[[login to view URL]]Sheet1'!$D$16
So far I have the following code:
[login to view URL]([login to view URL]);
string recno = [login to view URL]["ref"];
IStream s = [login to view URL](null, false, null);
[login to view URL]();
[login to view URL]("Content-Disposition", "filename=" + [login to view URL]);
[login to view URL]("Content-Length", [login to view URL]());
[login to view URL] = false;
[login to view URL] = GetContentType([login to view URL]); // [login to view URL] returns the file extention.
// GetContentType resolves to "application/octet-stream" for xlsx
uint BufferSize = 10000;
uint DocumentLength = (uint) [login to view URL];
byte[] buffer = new byte[BufferSize];
uint bytesread;
uint totalread = 0;
Stream outstream = [login to view URL];
while (totalread < DocumentLength)
{
[login to view URL](out buffer[0], 10000, out bytesread);
if (bytesread < 10000)
{
for (uint i = 0; i < bytesread; i++)
{
[login to view URL](buffer[i]);
}
}
else
{
[login to view URL](buffer, 0, 10000);
}
totalread += bytesread;
}
[login to view URL]();
[login to view URL]();
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.
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 immediately.
Regards,
AegleSol
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.
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 across the world.
I have developed multiple small to enterprise level software using these technologies.
I am available on skype as avakojha for more discussions.
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
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 University with a major in computer science and I've had over two years of experience in .NET enterprise development.