how to read a excel file in c#.net

[rohitkumar]

i have to read a excel file in fornt end essentially in asp/c#.net.
the row column value from the excel file has to be assigned to c# variable for further processing. i wanna know how to open connection to read the file and data.

[vinci]

i have to read a excel file in fornt end essentially in asp/c#.net.
the row column value from the excel file has to be assigned to c# variable for further processing. i wanna know how to open connection to read the file and data.

hi! welcome to TSDN!

u can access data from excel by using Microsoft.Office.Interop.Excel assembly..

u can research about this assembly and how to use it...

hope it helps!

[buhnik]

[You have to uesd
using Excel1 = Microsoft.Office.Interop.Excel;
Excel1.Application m_KeletoXL;
Excel1.Workbook m_KeletexcelWorkbook;
Excel1.Worksheet m_KeletoSheet;
Excel1.Range m_KeletRange;
Array m_myvalues;
m_oSheet[IndexShett].get_Range(rowStart, rowEnd).Font.Bold = true;
m_oSheet[IndexShett].get_Range(rowStart, rowEnd).Font.Color = ColorTranslator.ToWin32(m_ColorNumberOfProfiles[IndexShett]);

[rohitkumar]

hi! welcome to TSDN!

u can access data from excel by using Microsoft.Office.Interop.Excel assembly..

u can research about this assembly and how to use it...

hope it helps!

i m trying to declare an object of Application type using the code as below

 
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application()
 
 

it's giving me following error
UnauthorizedAccessException was handled
i tried resolving it by DCOMCNFG to set an ASPNET account,still i m getting the same error.
what to do/