DataSet to Excel via OWC

[tony]

Hello,

I have a problem outputting a dataset from a sp to an excel spreadsheet.

I am looping through the dataset and populating the spreadsheet cell by cell.

foreach ( DataRow dr in ds.Tables[0].Rows )
{
iCol = 1;
foreach ( DataColumn dc in ds.Tables[0].Columns )
{
oSheet.Cells[iRow,iCol]= dr[dc.ColumnName].ToString();
iCol++;
}
iRow++;
}

While this works for most of my scenarios, I have a couple of datasets that
take over 15 mins to generate and create a 7 mb spreadsheet.

Question: Is there a faster method of populating the spreadsheet than I am
presently using. I am new to the OWC so any help would be appreciated.

Thanks, Tony


From http://www.developmentnow.com/g/8_20...ork-aspnet.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

[Alvin Bruney [MVP - ASP.NET]]

There are a number of approaches presented in the black book. One good
approach is to use a stylesheet. Unfortunately, 7mb is really large for the
spreadsheet in general and you may continually experience errors or
significan lag times.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"tony" <no****@developmentnow.com> wrote in message
news:e2**********************************@msnews.m icrosoft.com...

Hello,

I have a problem outputting a dataset from a sp to an excel spreadsheet.

I am looping through the dataset and populating the spreadsheet cell by
cell.

foreach ( DataRow dr in ds.Tables[0].Rows )
{
iCol = 1;
foreach ( DataColumn dc in ds.Tables[0].Columns )
{
oSheet.Cells[iRow,iCol]= dr[dc.ColumnName].ToString();
iCol++;
}
iRow++;
}

While this works for most of my scenarios, I have a couple of datasets
that
take over 15 mins to generate and create a 7 mb spreadsheet.

Question: Is there a faster method of populating the spreadsheet than I am
presently using. I am new to the OWC so any help would be appreciated.

Thanks, Tony


From
http://www.developmentnow.com/g/8_20...ork-aspnet.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com