need to use C to create/edit excel spreadsheet

[jjd228]

is this ridiculously complicated?
does anyone know where there is a very simple, very basic example? or can someone post 1?

thank you

[jjd228]

ok then... answered that one myself. forget it

[Wraithan]

Well Excell can open delimited files as spreadsheets so you could create and edit via that, but a preexisting spreadsheet you would have to save as a delimited file.

EDIT:
@Bubba... so my spelling sucks... oh well. As long as I consistantly misspell it wont affect my programming!

[VirtualAce]

You mean delimited file?

[BobS0327]

very simple, very basic example

// Compile: cl.exe /MT excel.cpp /link /IGNORE:4089

#pragma comment( lib, "ole32.lib" )   // Search for ole32.lib while linking
#pragma warning(disable : 4995)   // Disable deprecated warning

#include <afxdb.h>
#include <iostream.h>

int  main(void)
{
    CDatabase database;
    CString sDriver = "MICROSOFT EXCEL DRIVER (*.XLS)"; // exactly the same name as in the ODBC-Manager
    CString sSql;
    CString sColumn1, sColumn2;
    CString sExcelFile = "MyExcel.XLS";  
    // Build the creation string for access without DSN
    sSql.Format("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s",
        sDriver, sExcelFile, sExcelFile);
    // Create the spreadsheet (i.e. Excel sheet)
    if( database.OpenEx(sSql,CDatabase::noOdbcDialog) )
    {
        // Create table structure
        sSql = "CREATE TABLE MYTABLE (Name1 TEXT(15), Name2 TEXT(15))";
        database.ExecuteSQL(sSql);
        // Add 3 records to excel table
        sSql.Format("INSERT INTO MYTABLE  VALUES ('%s','%s')","Bob", "Freddy" );
        database.ExecuteSQL(sSql);
        sSql.Format("INSERT INTO MYTABLE  VALUES ('%s','%s')","Jimmy", "Eddy" );
        database.ExecuteSQL(sSql);
        sSql.Format("INSERT INTO MYTABLE  VALUES ('%s','%s')","Frank", "Walter" );
        database.ExecuteSQL(sSql);
        CRecordset recset( &database );
        // Build the SQL statement
        sSql =  "SELECT * FROM MYTABLE";
        // Execute the query
        recset.Open(CRecordset::none,sSql,CRecordset::readOnly);
        // Loop through each record
        for (recset.MoveFirst(); !recset.IsEOF(); recset.MoveNext())
        {
            recset.GetFieldValue(0,sColumn1);
            recset.GetFieldValue(1,sColumn2);
            cout << sColumn1 << " " << sColumn2 << endl;
        }
        database.Close();
    }
    return 0;
}

[Shen ron]

sry but i have a problem i have just finshed learnin but i am getting an error

cannot convet char* to int;

and i have no way of correctin it...can you help???

[CommonTater]

post your code....

[Salem]

Meh - driveby thread hijacking.

Shen ron, start a new thread, with YOUR code (and make sure it has code tags as per the intro threads).