ASP.NET

if (filMyFile.PostedFile != null)
        {
            // Get a reference to PostedFile object
            HttpPostedFile myFile = filMyFile.PostedFile;

            // Get size of uploaded file
            int nFileLen = myFile.ContentLength;

            // make sure the size of the file is > 0
            if (nFileLen > 0)
            {
                // Allocate a buffer for reading of the file
                byte[] myData = new byte[nFileLen];

                string strff = Path.GetFileName(myFile.FileName);
                //WriteToFile((Server.MapPath(strff)), ref myData);
                // initialize the Excel Application class
                
                ApplicationClass app = new ApplicationClass();
                Workbook workBook = app.Workbooks.Open(strff,
                                                     0,
                                                     true,
                                                     5,
                                                     "",
                                                     "",
                                                     true,
                                                     XlPlatform.xlWindows,
                                                     "\t",
                                                     false,
                                                     false,
                                                     0,
                                                     true,
                                                     1,
                                                     0);
                // get the active worksheet using sheet name or active sheet
                Worksheet workSheet = (Worksheet)workBook.ActiveSheet;
                int index = 0;
                // This row,column index should be changed as per your need.
                // i.e. which cell in the excel you are interesting to read.
                object rowIndex = 2;
                object colIndex1 = 1;
                object colIndex2 = 2;
                object colIndex3 = 3;
                object colIndex4 = 4;
                object colIndex5 = 5;
                object colIndex6 = 6;
                object colIndex7 = 7;
                object colIndex8 = 8;
                object colIndex9 = 9;


                try
                {
                    while (((Range)workSheet.Cells[rowIndex, colIndex1]).Value2.ToString()!= string.Empty)
                    {
                        string OrderNumber = ((Range)workSheet.Cells[rowIndex, colIndex1]).Value2.ToString();
                        string FullName = ((Range)workSheet.Cells[rowIndex, colIndex2]).Value2.ToString();
                        string[] arrayFullName = FullName.Split(' ');
                        string FirstName = arrayFullName[0].ToString();
                        string Surname = arrayFullName[1].ToString();
                        string CustomerID = ((Range)workSheet.Cells[rowIndex, colIndex3]).Value2.ToString();
                        string VoucherNumber = ((Range)workSheet.Cells[rowIndex, colIndex4]).Value2.ToString();
                        string Address = ((Range)workSheet.Cells[rowIndex, colIndex5]).Value2.ToString();
                        string CustomerCellNumber = ((Range)workSheet.Cells[rowIndex, colIndex6]).Value2.ToString();
                        string CustomerTellNumber = ((Range)workSheet.Cells[rowIndex, colIndex7]).Value2.ToString();
                        string ConsignmentNumber = ((Range)workSheet.Cells[rowIndex, colIndex8]).Value2.ToString();
                        string HardwareDesc = ((Range)workSheet.Cells[rowIndex, colIndex9]).Value2.ToString();