Last post Sep 03, 2010 02:41 AM by alok_j10
Sep 03, 2010 01:03 AM|L.Lakshmana Perumal|LINK
Hi to all,
I have a data in Excel. but i want to show that data (as in Excel) in a button click event .
Have a nice day to all !
Sep 03, 2010 02:04 AM|bhavik.y.shah|LINK
Please clarify your answer you already have data in excel sheet?
or you want to export your data in excel sheet?
Sep 03, 2010 02:27 AM|L.Lakshmana Perumal|LINK
For example I have attendance report in excel sheet in "D" drive. In my application i want to open that excel through button click event
Sep 03, 2010 02:41 AM|alok_j10|LINK
You can read the excel using either interop.excel dll (http://www.codeproject.com/KB/office/fasterexcelaccesstoc.aspx)
or use oledb connection provider to read excel into one datatable and export the datatable into excel(http://www.codedigest.com/Articles/ASPNET/130_Export_to_Excel_in_ASPNet_20_%E2%80%93Gridview_to_Excel_DataTable_to_Excel.aspx).