<div>
I would thing that you would have to go down to a pretty granular level: some ideas below. 
 
Dim oApp as new Excel.Application 
Dim oWS as Excel.Worksheet = oApp.Worksheets(1) 
 
Then inside your recordset loop you could use s 
while not rs.eof 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; i = i + 1 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;oWorksheet.Cells(i,&quot;A&quot;) = rs.fields(0).value 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;oWorksheet.Cells(i,&quot;B&quot;) = rs.fields(1).value 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;oWorksheet.Cells(i,&quot;C&quot;) = rs.fields(2).value 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;oWorksheet.Cells(i,&quot;D&quot;) = rs.fields(3).value 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;rs.movenext 
end while 
 
Does this help?
</div>

<div>
Create Dynamic ASP.NET Excel Workbooks In C# 
 
By Peter A. Bromberg, Ph.D. 
 
<a href="http://www.eggheadcafe.com/articles/20021012.asp" rel="ugc">http://www.eggheadcafe.com/articles/20021012.asp</a> 

<pre><code class="code-10 nolinks" id="code-263627">private void CreateExcelWorkbook(string spName, SqlParameter[] parms)
{
string strCurrentDir = Server.MapPath(&quot;.&quot;) + &quot;\\&quot;;
RemoveFiles(strCurrentDir); // utility method to clean up old files
Excel.Application oXL;
Excel._Workbook oWB;
Excel._Worksheet oSheet;
Excel.Range oRng;
 
try
{
GC.Collect();// clean up any other excel guys hangin' around...
oXL = new Excel.Application();
oXL.Visible = false;
//Get a new workbook.
oWB = (Excel._Workbook)(oXL.Workbooks.Add( Missing.Value ));
oSheet = (Excel._Worksheet)oWB.ActiveSheet;
//get our Data
 
string strConnect = System.Configuration.ConfigurationSettings.AppSettings[&quot;connectString&quot;];
SPGen sg = new SPGen(strConnect,spName,parms);
SqlDataReader myReader = sg.RunReader();
// Create Header and sheet...
int iRow =2;
for(int j=0;j&lt;myReader.FieldCount;j++)
{
oSheet.Cells[1, j+1] = myReader.GetName(j).ToString();
}
// build the sheet contents
while (myReader.Read())
{
for(int k=0;k &lt; myReader.FieldCount;k++)
{
oSheet.Cells[iRow,k+1]= myReader.GetValue(k).ToString();
}
iRow++;
}// end while
myReader.Close();
myReader=null;
//Format A1:Z1 as bold, vertical alignment = center.
oSheet.get_Range(&quot;A1&quot;, &quot;Z1&quot;).Font.Bold = true;
oSheet.get_Range(&quot;A1&quot;, &quot;Z1&quot;).VerticalAlignment =Excel.XlVAlign.xlVAlignCenter;
//AutoFit columns A:Z.
oRng = oSheet.get_Range(&quot;A1&quot;, &quot;Z1&quot;);
oRng.EntireColumn.AutoFit();
oXL.Visible = false;
oXL.UserControl = false;
string strFile =&quot;report&quot; + System.DateTime.Now.Ticks.ToString() +&quot;.xls&quot;;
oWB.SaveAs( strCurrentDir + strFile,Excel.XlFileFormat.xlWorkbookNormal,
 null,null,false,false,Excel.XlSaveAsAccessMode.xlShared,false,false,null,null,null);
// Need all following code to clean up and extingush all references!!!
oWB.Close(null,null,null);
oXL.Workbooks.Close();
oXL.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject (oRng);
System.Runtime.InteropServices.Marshal.ReleaseComObject (oXL);
System.Runtime.InteropServices.Marshal.ReleaseComObject (oSheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject (oWB);
oSheet=null;
oWB=null;
oXL = null;
GC.Collect(); // force final cleanup!
string strMachineName = Request.ServerVariables[&quot;SERVER_NAME&quot;];
errLabel.Text=&quot;&lt;A href=http://&quot; + strMachineName +&quot;/ExcelGen/&quot; +strFile + &quot;&gt;Download Report&lt;/a&gt;&quot;;
 
}
catch( Exception theException )
{
String errorMessage;
errorMessage = &quot;Error: &quot;;
errorMessage = String.Concat( errorMessage, theException.Message );
errorMessage = String.Concat( errorMessage, &quot; Line: &quot; );
errorMessage = String.Concat( errorMessage, theException.Source );
errLabel.Text= errorMessage ;
}
</code></pre>
</div>

<div>
Another lovely solution at Code project i Have seen One click ASP.NET export button control for Excel/CSV file 
 
<a href="http://www.codeproject.com/KB/custom-controls/Excel_CSV_export_button.aspx" rel="ugc">http://www.codeproject.com/KB/custom-controls/Excel_CSV_export_button.aspx</a> 
 
There are various ways one can export data using ASP.NET. Usually, it is done by coding a separate page and adding various HTTP headers and responses. 
 

</div>

<div>
Hey mildurai &amp;&nbsp;PlatoConsultan, 
 
After creating &quot;excel.application&quot; object, how can we write to the Response? 
 
 
 
PlatoConsultant, 
 
The code you gave me seems to generate the excel file with all data in the 1st column as well. 
 
 
Thanks again! 
 
P.S. I can us 
 

</div>

<div>
When I use Exce.Application in my aspx page, I even got &quot;System.UnauthorizedAccess: Access is denied &quot;&nbsp;exceptopn.
</div>

<div>
cheny... 
just cooking dinner for my kids, can help later tonight after sending them off to sleep - I'm in the same timezone as you.
</div>

<div>
Thanks mildurai :-) 
 
I googled &amp;&nbsp;fixed the security issue.
</div>

<div>
Hi mildurait &amp;&nbsp;sybe, 
 
 
You are the legend! 
 
 
&nbsp;I have tried an example on my own PC.Tomorrow if I succeed as well in the office, I will add points for you. (I only need 1 worksheet.) 
 
 
Thanks heaps again! (also many thanks to PlatoConsultant)
</div>

<div>
Hey All, 
 
For reason, the XLS file I generated has no background grid line. Do you know how can I add it? 

</div>

<div>
I'd suggest that further research of xml approach will help you with this, else as sybe says, just format the table using css styles, including the style information the &lt;head&gt; section of of the html code.
</div>

<div>
Hey All again. 
 
I think if I use &quot;Response.AppendHeader(&quot;Content-type&quot;, &quot;application/vnd.ms-excel&quot;)&quot;, it is for M$ Excel 2003. When I try to use Excel 2007 open it, I got the alert message: 
 
&quot;The file you are trying to open is in a different format than specified by the file extension..............&quot;, and file_type becomes &quot;application&quot;, rather than &quot;excel spreadsheet&quot;.. 
 
 
What I am thinking is: 
 
1, &nbsp;Still using xls as extension name, rather than xlsx because 2007 can open 2003 document without conversion; 
 
2, There are some solution on web to sovle it by changing the registry of client PCs. But I can't do it; 
 
3, I also found something like changing the content-type to be: application/vnd.openxmlformats-officedocument.spreadsheetml. But it's still the same. 
 
 
Any ideas? Many thanks! 
 

</div>

<div>
Thanks all. I will oepn another thread
</div>

<div>
So far so good. I think I shall post another thread to continue with the Excel 2007 issue. 
 
 
Thanks all again!
</div>

<div>
<div class="content wysiwyg-content">
Hey All, 
 
I have a website which can generated CSV file on the fly. The thing is we want to let it generate excel file now. After I modified correspodning code, I found it did give me the xls file, but each line of data comes to the 1st grid of excel file. 
 
So if I want each field of data goes to each cell of excel spreadsheet, is there any quick solution I can use? 
 
P.S. I have used &quot;Microsoft Excel 11.0 Object&quot;, but it looks like I need to re-generate the whole stuff. Thinking of I already have CSV content on hand, is it possible to convert to excel spreadsheet easily? (I am using dot net 1.1) 
 
 
Thanks heaps all! 
 
&nbsp; 

<pre><code class="code-1 nolinks" id="code-263616">Response.AppendHeader(&quot;Content-type&quot;, &quot;application/vnd.ms-excel&quot;)
 Response.AppendHeader(&quot;Content-Disposition&quot;, &quot;attachment;filename=TEST.XLS&quot;)
 Response.AppendHeader(&quot;Pragma&quot;, &quot;no-cache&quot;)
 Response.AppendHeader(&quot;Expires&quot;, &quot;0&quot;)
</code></pre>
</div>
</div>

Hey All,

I have a website which can generated CSV file on the fly. The thing is we want to let it generate excel file now. After I modified correspodning code, I found it did give me the xls file, but each line of data comes to the 1st grid of excel file. 

So if I want each field of data goes to each cell of excel spreadsheet, is there any quick solution I can use?

P.S. I have used "Microsoft Excel 11.0 Object", but it looks like I need to re-generate the whole stuff. Thinking of I already have CSV content on hand, is it possible to convert to excel spreadsheet easily? (I am using dot net 1.1)


Thanks heaps all!

 

Generate Excel Spreadsheet On The Fly

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications