generating excel report in web application from sql data

Question

hi guys, i have some data in sql data table. i fetch data from sql in asp.net controls now i want to generate a excel file with fetching data fom sql. help me in this topic. Thanks Ajay

arjun · Answer

hi, 1.add reference to u r project microsoft.office.interop.excel then follow the below code using excel=Microsoft.Office.Interop.Excel; excel. Application xlapp; excel. Workbook xlwb; excel. Worksheet xlws; object misvalue = System.Reflection. Missing .Value; xlapp = new excel. ApplicationClass (); xlwb = xlapp.Workbooks.Add(misvalue); xlws = (excel. Worksheet )xlwb.Worksheets.get_Item(1); //////////////////////////////////////////// /////////to save column names/////////////// ////////////////////////////////////////////// //for (int i = 0; i //{ // int x = i; // x = x + 1; // xlws.Cells[1, x] = (string)dataGridView1.Columns[i].Name; //} /////////////////////////////////////////////// //////////to save data from datagridview/////// /////////////////////////////////////////////// int q = 0; for ( int a = 2; a //take dataset table of row count to check loop condition { for ( int b = 1; b { xlws.Cells[a, b] = dataGridView1.Rows[0].Cells[q].Value.ToString(); //only columns are saves not rows q++; ///////////////////////////////////////////////////////////////////// ////convert any type of data to string type and save in excel file/// ///////////////////////////////////////////////////////////////////// } ///////////////////////////////////////////////////////////////// //take another value to increase row count then save rows data/// ///////////////////////////////////////////////////////////////// } //xlws.Cells[1, 2] = h2; //xlws.Cells[1, 3] = h3; //xlws.Cells[2, 1] = s; //xlws.Cells[2, 2] = s1; //xlws.Cells[2, 3] = s2; // xlwb.SaveAs("C:\Users\"+xxx +"\Desktop\excel\arjun.xls", excel.XlFileFormat.xlWorkbookNormal, misvalue, misvalue, misvalue, misvalue, excel.XlSaveAsAccessMode.xlExclusive, misvalue, misvalue, misvalue, misvalue, misvalue); xlwb.SaveAs( "" + saveFileDialog1.FileName + ".xls" , excel. XlFileFormat .xlWorkbookNormal, misvalue, misvalue, misvalue, misvalue, excel. XlSaveAsAccessMode .xlExclusive, misvalue, misvalue, misvalue, misvalue, misvalue); xlwb.Close( true , misvalue, misvalue); xlapp.Quit(); MessageBox .Show( "created" ); } fill datagridview with the data which u wanna store in excel

Satyapriya Nayak · Answer

http://www.c-sharpcorner.com/UploadFile/sushmita_kumari/Excel112192005051943AM/Excel1.aspx

generating excel report in web application from sql data

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)