I wish to write some data for an xlsx spreadshhet (ultimately into a current one with multiple shhets, but for the time being would be pleased with developing a blank single sheet file).

Searching around it appears I have to make use of the stand out ODBC driver (Microsoft Stand out Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)) to create data in to the worksheet.

However this fails with: "Driver not installed: Microsoft Stand out Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)"

I've the 64bit version of Office 2010 Professional Plus (I believe thats the version students get?) installed, on Home windows 7 Home 64bit. And am trying to produce a 32bit application.

Can there be some rudimentary problem using ODBC here with office and home windows models, or even the bitness from the application? Is ODBC the best option for simply writing some data right into a file?

A requirment can also be will be able to write any file, and stand out does not have to be open (but stand out 2007 or later is going to be placed on the machine).

CString sDriver = L"Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)";
CString sExcelFile = L"c:\\test.xlsx";
CString connect;
connect.Format(L"DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s",
    sDriver, sExcelFile, sExcelFile);

I would suggest you to employ a CSV file (Comma Separated Values). That's effortlessly produced and may be read by Stand out (in addition to OpenOffice's and iWork's items).

try http://www.libxl.com/ - not affiliated, not really a person (since i have use mostly C#)...

EDIT - according to comment:

the above mentioned lib would permit you to not just create but additionally read+modify existing stand out files while you hint like a future goal inside your first sentence...

For creating Stand out files there some free options:
You may create CSV or (if some formatting and/or grouping and/or formulas etc. needed) HTML - Stand out can open HTML and employ this all right for choose to make use of the tags it knows - see http://www.c-sharpcorner.com/UploadFile/kaushikborah28/79Nick08302007171404PM/79Nick.aspx