Windows Forms

oXL.Workbooks.Open

neodeaths wrote:

which i drag into my workspace

using Excel = Microsoft.Office.Interop.Excel;


OleDbCommand cmd;
using (OleDbConnection con = new OleDbConnection(string.Format("Data Source={0};"   + "Provider=Microsoft.Jet.OLEDB.4.0;" + "Extended Properties=Excel 8.0;", fileName)))
{
    con.Open();
    string sqlToRun = "Create table [test] (Col1 int)";
    string insert = "insert into [test](col1) values (100)";
   
    cmd = new OleDbCommand(sqlToRun, con); // create table (worksheet)
    cmd.ExecuteNonQuery();

    cmd = new OleDbCommand(insert, con); // insert record
    cmd.ExecuteNonQuery();
}

A signing key is required in order to publish this project. Publishing from Visual Studio 2005 will automatically configure a signing key for this project.

Cannot publish because a project failed to build.

    private void Form1_FormClosing(object sender, FormClosingEventArgs e) {
        e.Cancel = true;
    }

    private void Form1_FormClosing(object sender, FormClosingEventArgs e) {
      if (e.CloseReason == CloseReason.WindowsShutDown) {
        e.Cancel = false;
      } else {
        e.Cancel = true;
      }
    }

Vishnu Nath wrote:

I have seen that you can cannot kill anti-virus processes from windows task manager.

Vishnu Nath wrote:

could not be killed by administrator of computer

I are troll

neodeaths wrote:

however i am trying to add values to it as well *e.g hidden values)