title: How i ready null cell in Google Spreadsheet Using C#?
body: <p>I have a table where your data is changed every week, and in some cells it is null, 
  occasionally it is bringing me an error because apparently it can only read values ​​that are not null, I would like to know how I can read it anyway, even if it doesn't bring me any data.</p>
  
  <p><a href="https://i.stack.imgur.com/oPIbn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oPIbn.png" alt="the null cells is E1 for example"></a></p>
  
  <p>i want to read the E2 null cell for example.</p>
  
  <p>what i have did so far in my project</p>
  
  <pre><code> {
          UserCredential credential;
  
          using (var stream = new FileStream("credentials.json", FileMode.Open, FileAccess.Read))
          {
              string creadPath = "token.json";
              credential = GoogleWebAuthorizationBroker.AuthorizeAsync(
                  GoogleClientSecrets.Load(stream).Secrets,
                  Scopes,
                  "user",
                  CancellationToken.None,
                  new FileDataStore(creadPath, true)).Result;
              label1.Text = "Conected with sheet";
  
  
          }
          var service = new SheetsService(new BaseClientService.Initializer()
          {
              HttpClientInitializer = credential,
              ApplicationName = ApplicationName
          });
          {
              var LimiteOP = $"{sheet}!B3:E3";
              SpreadsheetsResource.ValuesResource.GetRequest request = service.Spreadsheets.Values.Get(SpreadSheetId, LimiteOP);
              var response = request.Execute();
  
              IList&lt;IList&lt;Object&gt;&gt; values = response.Values;
  
              if (values.Count &gt; 0)
              {
                  foreach (var row in values)
                  {
  
                      Console.WriteLine(row[0]+" "+ row[1]+" " + row[2]);
                  }
               }
                else
               {
                  Console.WriteLine("Nothing");
               }
  </code></pre>
  
  <p><strong>Update</strong> (from comments): <em>"the consolewrite give the exception"</em></p>
  
  <p><strong>EDIT</strong></p>
  
  <p>to solve the problem that was the way as a simple process, transform the <code>object</code> to a <code>string</code> and then use a <code>Split</code> to remove the null spaces</p>
  
  <pre><code>  String[] str = row[0].ToString().Split(null);
    Console.WriteLine(str[0]);
  </code></pre>