In actually, It has a lot of sample code on the internet. http://www.google.com/search?q=vb.net+export+excel&rls=com.microsoft:th&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1&rlz=1I7GGLD_th
On Apr 3, 9:36 pm, "*nixtechno" <[email protected]> wrote: > Here is a simple code if you wish which can get you off to the right > start if required: > > Excel.ApplicationClass excel = new ApplicationClass(); > > excel.Application.Workbooks.Add(true); > DataTable table = DATASETNAME.Tables[0]; > int ColumnIndex=0; > foreach(Datacolumn col in table.Columns) > { > ColumnIndex++; > excel.Cells[1,ColumnIndex]=col.ColumnName;} > > int rowIndex=0; > foreach(DataRow row in table.Row) > { > rowIndex++; > ColumnIndex=0; > foreach(DataColumn col in table.Columns) > { > ColumnIndex++; > excel.Cells[rowIndex+1,ColumnIndex]=row.Cells > [col.ColumnName].Text; > }} > > excel.Visible = true; > Worksheet worksheet = (Worksheet)excel.ActiveSheet; > worksheet.Activate(); > ) > > On Apr 3, 2:08 am, [email protected] wrote: > > > > > Hi > > > I want to export data from dataset to excel in windows application (.Net > > 2005) using xslt. Can any one help me. > > > Note:- Please provide solution for Windows Application not for web > > application. > > > Thanks In Advance. > > > Regards > > Kapil- Hide quoted text - > > - Show quoted text -
