vc下如何对excel文件进行读写操作

[ljzcom]

vc下如何对excel文件进行读写操作

[arvid_gs]

www.vckbase.net上面有例子

[flyRaccoon]

找两个文件excel8.h;excel8.cpp(或者excel9.h;excel9.cpp)
_Application app;
Workbooks books;
_Workbook book;
Worksheets sheets;
_Worksheet sheet;

if(!app.CreateDispatch("Excel.Application"))
{
AfxMessageBox("Couldn't start Excel and get Application object.");
return;
}

app.SetVisible(TRUE);
//app.SetVisible(FALSE);
books = app.GetWorkbooks();

book = books.Add (covOptional);

sheets =book.GetSheets();
//add sheet
sheet = sheets.GetItem(COleVariant((short)1));
sheet.SetName("报表");

int i;
Range range;
Font font;
Interior interior;
Borders borders;
Border border;

//单元格合并
range = sheet.GetRange(COleVariant("A1"), COleVariant("B1"));
range.Merge(COleVariant((short)TRUE));

range.SetRowHeight(COleVariant((short)40));
font = range.GetFont();
font.SetBold(covTrue);
for(i=0;i<linkCount;i++)
{
range = sheet.GetRange(COleVariant(link[i].startPos), COleVariant(link[i].endPos));
interior = range.GetInterior();
borders = range.GetBorders();
borders.SetWeight(COleVariant((short)2)); //xlThin = 2
range.SetColumnWidth(COleVariant((short)30));
//设置有边框，还是无边框
borders.SetLineStyle(COleVariant((short)link[i].borderStyle));


//是项目，字体加粗
font = range.GetFont();
font.SetBold(covTrue);