Currently i have the codes for exporting data in a datagrid into Microsoft Excel spreadsheet. The codes are placed inside a button event. The codes are : -

dgData.HeaderStyle.ForeColor = dgData.HeaderStyle.ForeColor.Black
Response.Clear()
Response.AddHeader("content-disposition", "attatchment;filename=filename.xls")
Response.Charset = ""
Response.Cache.SetCacheability(HttpCacheability.NoCache)
Response.ContentType = "application/vnd.xls"


Dim stringWrite As System.IO.StringWriter = New System.IO.StringWriter
Dim htmlwrite As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(stringWrite)
dgData.RenderControl(htmlwrite)
Response.Write(stringWrite.ToString)
Response.End()
Currently what it does is it creates a new filename.xls everytime a user clicks on the export button. What i hope that could be done is that there can be a templated excel spreadsheet stored in the server and everytime a user clicks on the export button, they will download the templated excel spreadsheet together with the data aligned nicely according to the template.

Basically to achieve this, i will need to know if it is possible to :-
1. Is there a way to export the data in the datagrid into the excel spreadsheet and specify which cell the data should start the flow. (For example, the datagrid has "Title" as the start of all the columns - at the top right hand cell of the datagrid - and when it is exported into the excel, "Title" would appear at cell A1 of the excel spreadsheet. Is it possible to let the "Title" appear at cell C3?)

2. Is there a way to command the computer to use a templated excel spreadsheet stored in the server instead of always creating a new filename.xls?

MANY THANKS!!!!!

Hi, you can easily convert DataGrid to Excel with GemBox.Spreadsheet Excel VB.NET library.

Here is a code snippet how to do it in your ASP.NET Excel app:
' Get DataTable that DataGrid is bound to.
Dim dataTable = DirectCast(dataGrid.DataSource, DataTable)

' Create new ExcelFile.
Dim ef = New ExcelFile()
' Add new worksheet to the file.
Dim ws = ef.Worksheets.Add(dataTable.TableName)
' Insert the data from DataTable to the worksheet starting at cell "A1".
ws.InsertDataTable(dataTable, "A1", True)

' Stream file to browser.
Response.Clear()
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("Content-Disposition", "attachment; filename=Employee.xls")
ef.SaveXls(Response.OutputStream)
Response.End()

For live web demo see:
http://www.gemboxsoftware.com/WebDemo/Index.aspx

Recommend another Excel VB.NET Component: Spire.XLS for .NET

____________________________
jason rle