Read Excel file also content using ASP.net

Posted by Surya_appsdev under ASP.NET on 9/19/2011 | Points: 10 | Views : 2209 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi!

I am using an application, contains a textbox as input, in this textbox i give a file as "1234.xls". in that excel file contains all page numbers. I want to read all the page numbers from that excel file. Can anyone help me how to read the excel content. and place all page numbers in an array

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: SheoNarayan on: 9/19/2011 [Administrator] HonoraryPlatinum | Points: 25

0	Read below article http://www.dotnetfunda.com/articles/article1370-reading-opening-excel-file-in-csharp-using-microsoftofficeintropexcel-objec-.aspx and there are couple of Code Snippets as well http://www.dotnetfunda.com/codes/code259-read-data-from-excel-sheet.aspx http://www.dotnetfunda.com/codes/code972-read-a-excel-file-with-sheet-wise-into-dataset-using-csharp-.aspx Hope this helps. Thanks Regards, Sheo Narayan http://www.dotnetfunda.com Surya_appsdev, if this helps please login to Mark As Answer. \| Alert Moderator

Read below article
http://www.dotnetfunda.com/articles/article1370-reading-opening-excel-file-in-csharp-using-microsoftofficeintropexcel-objec-.aspx and there are couple of Code Snippets as well

http://www.dotnetfunda.com/codes/code259-read-data-from-excel-sheet.aspx
http://www.dotnetfunda.com/codes/code972-read-a-excel-file-with-sheet-wise-into-dataset-using-csharp-.aspx

Hope this helps.

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Surya_appsdev, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Surya_appsdev on: 9/20/2011 [Member] Starter | Points: 25

0	Hi! Here i am sending the form, In this form we enter filename. First we have to trace the file in the system. If it exists then we read the in the excel and that file information is again stored in excel. Ex: 1234.xls. In that file contains 1,2,3,4,5,6,7,8,9 data is available. All the data will moved separate excel files. Means 1.xls,2.xls like that. Please help me in this regard. Download source file Surya_appsdev, if this helps please login to Mark As Answer. \| Alert Moderator

Hi!

Here i am sending the form, In this form we enter filename. First we have to trace the file in the system. If it exists then we read the in the excel and that file information is again stored in excel. Ex: 1234.xls. In that file contains 1,2,3,4,5,6,7,8,9 data is available. All the data will moved separate excel files. Means 1.xls,2.xls like that.

Please help me in this regard.

Download source file

Surya_appsdev, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Priyagoel_24 on: 7/13/2013 [Member] Starter | Points: 25

0	Hi, In my application, i have one fileupload control which will take excel file. I want to read this excel file and want to store in datatable. How will i do this. I am using visual studio 2005. thanks you priya Surya_appsdev, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts