如何将clistview内容导出到excel?
为何调用ExportListToExcel函数，提示参数类型不匹配？请懂的朋友给予解答，谢谢！

void CBeiView::OnButton1()                   //单击“导出到excel”按钮
{
    CListCtrl &ctl=GetListCtrl();
    ExportListToExcel(ctl,"库存明细");      //调用全局函数,导出数据到excel
}
//全局函数
void ExportListToExcel(CListCtrl* pList, CString strTitle)
{
    CString warningStr;
    if (pList->GetItemCount ()>0) {   
        CDatabase database;
        CString sDriver;
        CString sExcelFile;
        CString sSql;
        CString tableName = strTitle;     
        // 检索是否安装有Excel驱动 "Microsoft Excel Driver (*.xls)"
        sDriver = GetExcelDriver();
        if (sDriver.IsEmpty())
        {
            // 没有发现Excel驱动
            AfxMessageBox("没有安装Excel!\n请先安装Excel软件才能使用导出功能!");
            return;
        }      
        ///默认文件名
        if (!GetDefaultXlsFileName(sExcelFile))
            return;        
        // 创建进行存取的字符串
        sSql.Format("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s",sDriver, sExcelFile, sExcelFile);     
        // 创建数据库 (既Excel表格文件)
        if( database.OpenEx(sSql,CDatabase::noOdbcDialog) )
        {
            // 创建表结构
            int i;
            LVCOLUMN columnData;
            CString columnName;
            int columnNum = 0;
            CString strH;
            CString strV;
            sSql = "";
            strH = "";
            columnData.mask = LVCF_TEXT;
            columnData.cchTextMax =100;
            columnData.pszText = columnName.GetBuffer (100);
            for(i=0;pList->GetColumn(i,&columnData);i++)
            {
                if (i!=0)
                {
                    sSql = sSql + ", " ;
                    strH = strH + ", " ;
                }
                sSql = sSql + " " + columnData.pszText +" TEXT";
                strH = strH + " " + columnData.pszText +" ";
            }
            columnName.ReleaseBuffer ();
            columnNum = i;
            sSql = "CREATE TABLE " + tableName + " ( " + sSql +  " ) ";
            database.ExecuteSQL(sSql);
            // 插入数据项
            int nItemIndex;
            for (nItemIndex=0;nItemIndex<pList->GetItemCount ();nItemIndex++){
                strV = "";
                for(i=0;i<columnNum;i++)
                {
                    if (i!=0)
                    {
                        strV = strV + ", " ;
                    }
                    strV = strV + " '" + pList->GetItemText(nItemIndex,i) +"' ";
                }               
                sSql = "INSERT INTO "+ tableName
                    +" ("+ strH + ")"
                    +" VALUES("+ strV + ")";
                database.ExecuteSQL(sSql);
            }        
        }              
        // 关闭数据库
        database.Close();            
        warningStr.Format("导出数据成功\n保存在%s文件中.",sExcelFile);
        AfxMessageBox(warningStr);
    }
}

ExportListToExcel(&ctl,"库存明细");

还是不行，可以正常编译，但执行后会出现出错信息：字段定义语法错误。

是在create table执行的时候报错吧？ 怀疑ListCtrl列名里含特殊字符, 比如括号，斜杠。。导致语法错误。

    如果是这个问题，可以把列名加上[]试试。
    形如: CREATE TABLE test( [col/1] TEXT, [col/2] TEXT, [col(3)] TEXT )