vc++使用MFC操作EXCEL文件 创建+编辑+保存(2)

range.SetNumberFormat(COleVariant(\

//选择A:A列，设置宽度为自动适应 cols=range.GetEntireColumn(); cols.AutoFit();

//显示Excel表格，并设置状态为用户可控制 app.SetVisible(TRUE); app.SetUserControl(TRUE);

5. 如何自动保存我们生成的Excel文件？通过Workbook对象的SaveAs方法即可实现：

book.SaveAs(COleVariant(\ covOptional,covOptional,

covOptional,covOptional,(long)0,covOptional,covOptional,covOptional, covOptional);

//注意Excel2003的SaveAs函数参数不同，代码应写为：

/*void _Workbook::SaveAs(const VARIANT& Filename, 1

COleVariant VOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR); book.SaveAs(COleVariant(\

VOptional,VOptional, VOptional,VOptional,VOptional, (long)0, VOptional,VOptional,VOptional,VOptional, VOptional);

const VARIANT& FileFormat, const VARIANT& Password, const VARIANT& const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup, const VARIANT& ConflictResolution, 1

const VARIANT& AddToMru, const VARIANT& TextCodepage, 2 const VARIANT& TextVisualLayout, const VARIANT& Local 2 WriteResPassword, 3 long AccessMode, 3

)*/