Excel .CSV problem with save

[S_K]

Hi,

I have a problem when I try to save a .CSV file from an ASP.NET web
page and the client has Excel open already. The symptoms are:

1) The web page is currently displaying the Excel spreadsheet with the
accurate data.
2) The .CSV file is saved from the server to the local hard drive of
the client.
3) An Excel spreadsheet is already running on the client (version 2002
of excel).
4) After the file is saved on the local (client) hard drive we notice
that another spreadsheet has been opened in the currently running
excel application. The name of the newly created file is "Object.csv ".
5) The currently running spreadsheet data displays its own data under
it's own name.
6) When the Excel application has been killed and the saved .csv file
is opened the spreadsheet displays the data of the previously open
spreadsheet. In other words, the web page .CSV data has been replaced
by the open spreadsheet data!
7) When we try to save the web page .CSV file without Excel running it
saves fine.

This is a weird one! Is there anyway to save the .CSV file without
having it try to open in the Excel spreadsheet?

Thanks so much for your help!

Steve

[Mark Rae [MVP]]

"S_K" <st***********@ yahoo.comwrote in message
news:11******** *************@v 2g2000hsf.googl egroups.com...

This is a weird one! Is there anyway to save the .CSV file without
having it try to open in the Excel spreadsheet?

Show your code.
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[S_K]

On Nov 13, 3:24 pm, "Mark Rae [MVP]" <m...@markNOSPA Mrae.netwrote:

"S_K" <steve_kers...@ yahoo.comwrote in message

news:11******** *************@v 2g2000hsf.googl egroups.com...

This is a weird one! Is there anyway to save the .CSV file without
having it try to open in the Excel spreadsheet?

Show your code.

--
Mark Rae
ASP.NET MVPhttp://www.markrae.net

Sorry,

Thanks for your help.

Here is my code:

protected void SaveExcel(objec t sender, EventArgs e)
{
int iColumnCount;

FileStream fs = new FileStream("C:/ExcellFiles/
exl.csv",FileMo de.Create, FileAccess.Writ e);

StreamWriter sw = new StreamWriter(fs );
sw.BaseStream.S eek(0,SeekOrigi n.End);

// get the column count
iColumnCount = GridView1.Colum ns.Count;

// fill the header
WriteHeader(sw) ;

foreach (GridViewRow row in GridView1.Rows)
{
WriteThisLine(i ColumnCount, row, sw);
}
sw.Flush();
fs.Close();

Response.Redire ct("https://mudotnet/ExcellFiles/exl.csv", false);
}

I hope that helps.

Steve

[=?Utf-8?B?QnJhdWxpbyBEaWV6?=]

Mmm...

There is a cleaner way to do this, instead of creating a file on the
server side, you could create the file in memory and send it as an stream to
the client using the Response object.

I have used this approach with Excel XMLSS files without any issue, about
how to do this using CSV:
http://www.keithrull.com/PermaLink,g...a0fad159e.aspx

(may be you will need to register to this site).
http://discuss.fogcreek.com/dotnetqu...ow&ixPost=1485

http://blogs.msdn.com/adamhems/archi...11/573458.aspx

Good luck
Braulio

/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"S_K" wrote:

On Nov 13, 3:24 pm, "Mark Rae [MVP]" <m...@markNOSPA Mrae.netwrote:

"S_K" <steve_kers...@ yahoo.comwrote in message

news:11******** *************@v 2g2000hsf.googl egroups.com...

This is a weird one! Is there anyway to save the .CSV file without
having it try to open in the Excel spreadsheet?

Show your code.

--
Mark Rae
ASP.NET MVPhttp://www.markrae.net

Sorry,

Thanks for your help.

Here is my code:

protected void SaveExcel(objec t sender, EventArgs e)
{
int iColumnCount;

FileStream fs = new FileStream("C:/ExcellFiles/
exl.csv",FileMo de.Create, FileAccess.Writ e);

StreamWriter sw = new StreamWriter(fs );
sw.BaseStream.S eek(0,SeekOrigi n.End);

// get the column count
iColumnCount = GridView1.Colum ns.Count;

// fill the header
WriteHeader(sw) ;

foreach (GridViewRow row in GridView1.Rows)
{
WriteThisLine(i ColumnCount, row, sw);
}
sw.Flush();
fs.Close();

Response.Redire ct("https://mudotnet/ExcellFiles/exl.csv", false);
}

I hope that helps.

Steve