Question

如何编程提取excel数据

Answer 1

简单的方法是通过ODBC来实现：具体实现一、包含Excel文件操作类头文件#include"CSpreadSheet.h"二、新建Excel文件，并写入默认数据//新建Excel文件名及路径，TestSheet为内部表名CSpreadSheetSS("c:\\Test.xls","TestSheet");CStringArraysampleArray,testRow;SS.BeginTransaction();//加入标题sampleArray.RemoveAll();sampleArray.Add("姓名");sampleArray.Add("年龄");SS.AddHeaders(sampleArray);//加入数据CStringstrName[]={"徐景周","徐志慧","郭徽","牛英俊","朱小鹏"};CStringstrAge[]={"27","23","28","27","26"};for(inti=0;i"+Rows.GetAt(j-1);}m_AccessList.AddString(strContents);}