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