导出excel遇到问题 [复制链接]

我在把tableview里面的数据导出excel的时候遇到以下错误

复制代码

1. QAxBase: Error calling IDispatch member Open: Exception thrown by server
2. Code : 1004
3. Source : Microsoft Office Excel
4. Description: ????C:\temp\source_data.xls????????????????????????
5. ?????????????????????????????????????????
6. Help : D:\Program Files (x86)\Microsoft Office\Office12\2052\XLMAIN11.CHM
7. Connect to the exception(int,QString,QString,QString) signal to catch this exception
8. "d:\Program Files (x86)\SogouInput\5.1.1.4880\crashrpt.exe" "sogoupy.ime" "sogoupy" "0" "crush.dmp" "crush.rpt"

代码如下:

复制代码

1. QAxObject* excel = new QAxObject( "Excel.Application", 0 );
2.      QAxObject* workbooks = excel->querySubObject( "Workbooks" );
3.      QAxObject* workbook = workbooks->querySubObject( "Open(const QString&)", "C:\\temp\\source_data.xls");
4.      QAxObject* sheets = workbook->querySubObject( "Worksheets" );

workbook = workbooks->querySubObject("Open(QString, QVariant)", fileName, 0);

Open方法应该是两个参数吧，你试试看。