read data from excel to gridview and store excel file in ftp

See more:

ASP.NET

Hai all,

I used the below code for renaming after the file uploaded to particular folder,but its working fine locally but its giving runtime error in server

try
                    {
                        object oMissing = System.Reflection.Missing.Value;
                        Microsoft.Office.Interop.Excel.ApplicationClass xl = new Microsoft.Office.Interop.Excel.ApplicationClass();
                        Microsoft.Office.Interop.Excel.Workbook xlBook;
                        Microsoft.Office.Interop.Excel.Worksheet xlSheet;
                        xlBook = (Microsoft.Office.Interop.Excel.Workbook)xl.Workbooks.Open(fileLocation, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
                        xlSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlBook.Worksheets.get_Item(1);
                        xlSheet.Name = "New_LITM -" + 12;
                        xlBook.Save();
                        xl.Application.Workbooks.Close();
                    }
                    catch (Exception ex)
                    {
                        lblStatus.Visible = true;
                        lblStatus.Text = ex.Message;
                        lblStatus.ForeColor = System.Drawing.Color.Red;
                    }

please help me out this....