C++ og Excel

ja

den mest primitive mulighed er at bruge ODBC kald

OK ?

Kan du f.eks sende et styke kode der åbner en Excel fil og skrive på det?

Book1.xls før:

1    A
2    BB

#include <stdio.h>
#include <stdlib.h>

#include <windows.h>
#include <sql.h>
#include <sqlext.h>

int main()
{
  SQLHENV Environment;
  SQLHDBC DataBaseConnect;
  SQLHSTMT stmt;
  SQLRETURN stat;
  char *constr = "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\\Book1.xls;READONLY=FALSE;FIRSTROWHASNAMES=0;";
  char outconstr[1024];
  int outconlen;
  char sqlstr[1000];
  int i;
  char s[50];
  int il,sl;
  stat = SQLAllocEnv(&Environment);
  stat = SQLAllocConnect(Environment,&DataBaseConnect);
  stat = SQLDriverConnect(DataBaseConnect,NULL,
                          (SQLCHAR *)constr,(SQLSMALLINT)strlen(constr),
                          (SQLCHAR *)outconstr, (SQLSMALLINT)sizeof(outconstr),
                          (SQLSMALLINT *)&outconlen,SQL_DRIVER_COMPLETE);
  stat = SQLAllocStmt(DataBaseConnect,&stmt);
  sprintf(sqlstr,"INSERT INTO [sheet1$] VALUES(%d,'%s')",3,"CCC");
  stat = SQLExecDirect(stmt,(SQLCHAR *)sqlstr,strlen(sqlstr));
  printf("stat=%d\n",stat);
  sprintf(sqlstr,"INSERT INTO [sheet1$] VALUES(%d,'%s')",4,"DDDD");
  stat = SQLExecDirect(stmt,(SQLCHAR *)sqlstr,strlen(sqlstr));
  printf("stat=%d\n",stat);
  SQLFreeStmt(stmt,SQL_DROP);
  SQLDisconnect(DataBaseConnect);
  SQLFreeConnect(DataBaseConnect);
  SQLFreeEnv(Environment); 
  return 0;
}

Book1.xls efter:

1    A
2    BB
3    CCC
4    DDDD

de 2:

printf("stat=%d\n",stat);

kan bare fjernes

Flot.