Thanks for the reply sir.
I have acheived exactly what i need please see below
Missing mv = Missing.Value;
protected void btnExport_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.Application NewExcelApp = new Microsoft.Office.Interop.Excel.Application();
_Workbook wkb = NewExcelApp.Workbooks.Add(mv);
_Worksheet wks = wkb.Sheets[1] as Microsoft.Office.Interop.Excel.Worksheet;
for (int i = 1; i <= lstTest.Items.Count; i++)
{
((Range)wks.Cells[1, i]).Value = lstTest.Items[i - 1].Text;
}
object filePath = "F:\\test";
wkb.SaveAs(filePath, XlFileFormat.xlExcel8, mv, mv, mv, mv, XlSaveAsAccessMode.xlNoChange, mv, mv, mv, mv, mv);
wks = null;
wkb = null;
NewExcelApp.Quit();
}