odbc中可以插入excel对象吗,该如何解决
odbc中可以插入excel对象吗
vc建立的带有odbc数据源的单文档，请问可以插入excel对象，然后对其中的数据进行操作，以实现数据的导出吗？为什么插入excel对象，运行后出现
Compiling...
test_acView.cpp
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(130) : error C2065: '_Application' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(130) : error C2146: syntax error : missing ';' before identifier 'exlapp'
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(130) : error C2065: 'exlapp' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(131) : error C2065: '_Workbook' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(131) : error C2146: syntax error : missing ';' before identifier 'wbk'
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(131) : error C2065: 'wbk' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(132) : error C2065: 'Workbooks' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(132) : error C2146: syntax error : missing ';' before identifier 'wbks'
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(132) : error C2065: 'wbks' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(133) : error C2065: '_Worksheet' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(133) : error C2146: syntax error : missing ';' before identifier 'wht'
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(133) : error C2065: 'wht' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(134) : error C2065: 'Worksheets' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(134) : error C2146: syntax error : missing ';' before identifier 'whts'
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(134) : error C2065: 'whts' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(141) : error C2227: left of '->CreateDispatch' must point to class/struct/union
执行 cl.exe 时出错.
test_acView.obj - 1 error(s), 0 warning(s)
------解决方案--------------------
前面加上
#import …… 和命名空间
http://blog.****.net/superleolx/article/details/4140975
vc建立的带有odbc数据源的单文档，请问可以插入excel对象，然后对其中的数据进行操作，以实现数据的导出吗？为什么插入excel对象，运行后出现
Compiling...
test_acView.cpp
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(130) : error C2065: '_Application' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(130) : error C2146: syntax error : missing ';' before identifier 'exlapp'
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(130) : error C2065: 'exlapp' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(131) : error C2065: '_Workbook' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(131) : error C2146: syntax error : missing ';' before identifier 'wbk'
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(131) : error C2065: 'wbk' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(132) : error C2065: 'Workbooks' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(132) : error C2146: syntax error : missing ';' before identifier 'wbks'
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(132) : error C2065: 'wbks' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(133) : error C2065: '_Worksheet' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(133) : error C2146: syntax error : missing ';' before identifier 'wht'
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(133) : error C2065: 'wht' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(134) : error C2065: 'Worksheets' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(134) : error C2146: syntax error : missing ';' before identifier 'whts'
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(134) : error C2065: 'whts' : undeclared identifier
C:\Program Files\Microsoft Visual Studio\MyProjects\test_ac\test_acView.cpp(141) : error C2227: left of '->CreateDispatch' must point to class/struct/union
执行 cl.exe 时出错.
test_acView.obj - 1 error(s), 0 warning(s)
------解决方案--------------------
前面加上
#import …… 和命名空间
http://blog.****.net/superleolx/article/details/4140975