How to Export Issue overcome

public static DataTable ReadExcel(string inputPath, string sheetName)
{
     DataTable dtSheet = new DataTable();
     try
     {
          #region Read data from excel
          objApp.Visible = false;

	    //Open the Workbook
          objWrkbook = objApp.Workbooks.Open(inputPath, 0, false, 5, "",  "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);

	    //Get all sheets available under the workbook
          objSheets = (Excel.Sheets)objWrkbook.Worksheets;

	    // Get the particular sheet which you want to get the information
          objWrkSheet = (Microsoft.Office.Interop.Excel.Worksheet)objSheets.get_Item(sheetName);

	    //Get the column count of the sheet
          int colcnt = objWrkSheet.UsedRange.Columns.Count;
          //Get Row count of the sheet
    int rowcnt = objWrkSheet.UsedRange.Rows.Count;



                         #endregion

            }
	}
      catch (Exception ex)
      {
          throw;
      }
      finally
      {
           if (objWrkSheet != null)
        System.Runtime.InteropServices.Marshal.ReleaseComObject(objWrkSheet);
           if (objWrkbook != null)
               objWrkbook.Close(false, inputPath, Type.Missing);
           if (objApp != null)
               objApp.Quit();
       }
       return dtSheet;
}

This is the way you open the workbook. Check the last parameter, and set it to xlNormalLoad. Then, according to the documentation, 
Excel will not try to repair the file.
Open(filePath,			// The file name
0,						// Update links, 0 means no charts are created
true,					// Read only
5,						// Format, 5 means nothing
"",						// Password
"",						// WriteResPassword
true,					// Ignore read only recommended
XlPlatform.xlWindows,	// Origin
"\t",					// Delimiter
true,					// Editable for Excel 4.0 add-in
false,					// Notify
0,						// Converter
false,					// AddToMru
true,					// Local
true);					// CorruptLoad, can be: xlNormalLoad, xlRepairFile or xlExtractData

private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection cnn ;
            string connectionString = null;
            string sql = null;
            string data = null;
            int i = 0;
            int j = 0; 

            Excel.Application xlApp ;
            Excel.Workbook xlWorkBook ;
            Excel.Worksheet xlWorkSheet ;
            object misValue = System.Reflection.Missing.Value;

            xlApp = new Excel.Application();
            xlWorkBook = xlApp.Workbooks.Add(misValue);
            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

            connectionString = "data source=servername;initial catalog=databasename;user id=username;password=password;";
            cnn = new SqlConnection(connectionString);
            cnn.Open();
            sql = "SELECT * FROM Product";
            SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn);
            DataSet ds = new DataSet();
            dscmd.Fill(ds);

            for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
            {
                for (j = 0; j <= ds.Tables[0].Columns.Count - 1; j++)
                {
                    data = ds.Tables[0].Rows[i].ItemArray[j].ToString();
                    xlWorkSheet.Cells[i + 1, j + 1] = data;
                }
            }

            xlWorkBook.SaveAs("csharp.net-informations.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
            xlWorkBook.Close(true, misValue, misValue);
            xlApp.Quit();

            releaseObject(xlWorkSheet);
            releaseObject(xlWorkBook);
            releaseObject(xlApp);

            MessageBox.Show("Excel file created ");
        }