Comments by Member 13818561 (Top 10 by date)

Actually the problem is references are not published while publishing the asp.net project. So what should I do?

I used this code.
Microsoft.Office.Interop.Excel.Application objXL = null;

//Workbook refrence

Microsoft.Office.Interop.Excel.Workbook objWB = null;

//DataSet ds = new DataSet();

//try
//{

//Instancing Excel using COM services

objXL = new Microsoft.Office.Interop.Excel.Application();

//Adding WorkBook
objWB = objXL.Workbooks.Open(path);

foreach (Microsoft.Office.Interop.Excel.Worksheet objSHT in objWB.Worksheets)

int rows = objSHT.UsedRange.Rows.Count;
int cols = objSHT.UsedRange.Columns.Count;
DataTable dt = new DataTable();
int noofrow = 1;
//If 1st Row Contains unique Headers for datatable include this part else remove it

//Start
for (int c = 1; c <= cols; c++)
{
string colname = objSHT.Cells[1, c].Text;
dt.Columns.Add(colname);
noofrow = 2;
}
//END
for (int r = noofrow; r <= rows; r++)
{
DataRow dr = dt.NewRow();

for (int c = 1; c <= cols; c++)
{

dr[c - 1] = objSHT.Cells[r, c].Text;
}

dt.Rows.Add(dr);
}

ds.Tables.Add(dt);}

Sir I have a doubt,
I wanted to convert from excel to dataTable. It works fine. But after publishing my project rest of all page works fine. But only this page code is not working. please give me suggestions.

Thank You so much sir. It works for me.