Creating and Opening an Excel file client side. 1

[NatGreen]

Creating and Opening an Excel file, in a seperate window client side.

Any good examples/Articles out there?

I having trouble finding a good article/example on the best way to accomplish this task. All of my users do have Microsoft Excel on their machines.

Thanks for you help.
NatGreen

 

[Alcar]

strName = "c:\whatever\myfile.xls";
Response.ContentType = "application/vnd.ms-excel";
Response.WriteFile(strName);
Response.Flush();
Response.Close();

the myfile.xls should exist. If you create it with nothing on it it would do the trick. I believe this is what you asked...

hth Daren J. Lahey
Just another computer guy...
If you are unsure of forum etiquette check here FAQ796-2540

 

[qwert231]

You could probably do a <input type=&quot;file&quot;> control that intstead of sending the file just sends the name to strName. Course, I haven't worked with that control myself, but just a thought.

 

[NatGreen]

Actually I would like to export my data from a data grid to Excel. I do not want to create a physical file on the web server. Is there any way I could do a straight data dump to Excel?

 

[Alcar]

What you are probably talking about is to &quot;dump&quot; the dataset into a stream object and send it to the Response object...
I'm not sure if that is possible though... Daren J. Lahey
Just another computer guy...
If you are unsure of forum etiquette check here FAQ796-2540