title: how to get column from Excel Sheet,if Excel sheet name contain space character i.e."Person Details"
body: <p>here i m using ADO.Net for connect to Excel file using specified connectionString that work fine, my only concern is if sheet name has space character than its not return column names form corresponding sheet.
  my code :</p>
  
  <pre><code>        if (extension == ".xls")
          {
              connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
              "Data Source=" + Server.MapPath("~\\ExcelUpload\\Excelsheets\\temp.xls") + ";" +
              @"Extended Properties=" + "\"Excel 8.0;HDR=YES;\"";
          }
          else if (extension == ".xlsx")
          {
              connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;" +
              "Data Source=" + Server.MapPath("~\\ExcelUpload\\Excelsheets\\temp.xlsx") + ";" +
              @"Extended Properties=" + "\"Excel 12.0;HDR=YES;\"";
          }
  
  
          DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb");
          DbConnection connection = factory.CreateConnection();
          connection.ConnectionString = connectionString;
          connection.Open();
  
          DataTable dt;
          String[] restrection = { null, null, sheetName + "$", null };
          dt = connection.GetSchema("Columns", restrection);
  </code></pre>
  
  <p>so how can we paas excelsheet name that has space character?</p>