CREATING AUTONUMBER COLUMN IN EXCEL
-
HI CODEPROJECT TEAM. SOMEONE KNOW HOW INSERT A AUTONUMBER COLUMN IN EXCEL USING OLEDB?. CONNECTION STRING EXAMPLE:
string cst; //Connection String cst="Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=c:\\file.xls;" + "Extended Properties=\"Excel 8.0;IMEX=1;MaxScanRows=0;" + "HDR=YES\""; OleDbConnection conn = new OleDbConnection(cst); conn.Open();I NEED DO SOMETHING LIKE:string SQL; SQL="ALTER TABLE [sheet1$] ADD [row_id] NUMBER NOT NULL AUTONUMBER"; OleDbCommand cmd = new OleDbCommand(SQL, conn); cmd.ExecuteNonQuery();THANKS IN ADVANCED.SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?
-
HI CODEPROJECT TEAM. SOMEONE KNOW HOW INSERT A AUTONUMBER COLUMN IN EXCEL USING OLEDB?. CONNECTION STRING EXAMPLE:
string cst; //Connection String cst="Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=c:\\file.xls;" + "Extended Properties=\"Excel 8.0;IMEX=1;MaxScanRows=0;" + "HDR=YES\""; OleDbConnection conn = new OleDbConnection(cst); conn.Open();I NEED DO SOMETHING LIKE:string SQL; SQL="ALTER TABLE [sheet1$] ADD [row_id] NUMBER NOT NULL AUTONUMBER"; OleDbCommand cmd = new OleDbCommand(SQL, conn); cmd.ExecuteNonQuery();THANKS IN ADVANCED.SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?
-
HI CODEPROJECT TEAM. SOMEONE KNOW HOW INSERT A AUTONUMBER COLUMN IN EXCEL USING OLEDB?. CONNECTION STRING EXAMPLE:
string cst; //Connection String cst="Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=c:\\file.xls;" + "Extended Properties=\"Excel 8.0;IMEX=1;MaxScanRows=0;" + "HDR=YES\""; OleDbConnection conn = new OleDbConnection(cst); conn.Open();I NEED DO SOMETHING LIKE:string SQL; SQL="ALTER TABLE [sheet1$] ADD [row_id] NUMBER NOT NULL AUTONUMBER"; OleDbCommand cmd = new OleDbCommand(SQL, conn); cmd.ExecuteNonQuery();THANKS IN ADVANCED.SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?
AFAIK, Excel doesn't support autonumber columns. You'll have to use a database that does, like Access or SQL Server.
Dave Kreskowiak Microsoft MVP - Visual Basic
-
HI CODEPROJECT TEAM. SOMEONE KNOW HOW INSERT A AUTONUMBER COLUMN IN EXCEL USING OLEDB?. CONNECTION STRING EXAMPLE:
string cst; //Connection String cst="Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=c:\\file.xls;" + "Extended Properties=\"Excel 8.0;IMEX=1;MaxScanRows=0;" + "HDR=YES\""; OleDbConnection conn = new OleDbConnection(cst); conn.Open();I NEED DO SOMETHING LIKE:string SQL; SQL="ALTER TABLE [sheet1$] ADD [row_id] NUMBER NOT NULL AUTONUMBER"; OleDbCommand cmd = new OleDbCommand(SQL, conn); cmd.ExecuteNonQuery();THANKS IN ADVANCED.SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?
You may have to *fake* an autonumbered column with a formula incrementing the value of the preceding cell. imho, a person should stay away from anything complex in Excel. The next version may well break all your work -- and impose costs neither you or your clients are prepared to swallow. The more glorious your work, the more costly the *probable* catastrophe.