title: Inserting data from c# textbox to excel
body: <p>Hi im unsing Oledb to insert data to an excel sheet from multiple textboxes. The issue i have is that it is not going into excel as a number type but string, so a grpah can no be automated off the date. 
  How would i insert values into excel as number type? ive tried converting the textboxes to int with no luck.</p>
  
  <p>My code is as below.</p>
  
  <pre><code> string szConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=L://Metrics_gen.xlsx;Extended Properties='Excel 8.0;HDR=YES;'";
              OleDbConnection conn = new OleDbConnection(szConn);
              int v1 = Convert.ToInt32(textBox1.Text);
              int v2 = Convert.ToInt32(textBox2.Text);
              int v3 = Convert.ToInt32(textBox3.Text);
              int v4 = Convert.ToInt32(textBox4.Text);
              int v5 = Convert.ToInt32(textBox5.Text);
  
  
              conn.Open();
              OleDbCommand cmd = new OleDbCommand("INSERT INTO [Sheet1$]([Total],[Closed],[Issues],[Cancelled],[Back out]) VALUES('" + v1 + "','" + v2 + "','" + v3 + "','" + v4 + "','" + v5 + "')", conn);
              cmd.ExecuteNonQuery();
  
  
              conn.Close();
              MessageBox.Show("complete");
  </code></pre>