excel导入导出（Excel import export）.docVIP

excel导入导出（Excel import export） #include ole2.h / / this header file must contain, otherwise it can not be automated #include stdio.h Then we modify the / / add a function, this function is the basis of the program Write another program and / / if want to use pure C++ to achieve automation, this function can be reused HRESULT, AutoWrap (int, autoType, VARIANT, *pvResult, IDispatch, *pDisp, LPOLESTR, ptName, int, cArgs...); / / modify the main function Int main (int, argc, char*, argv[]) { / / printf (Hello World \n!); / / comment out this sentence / / initialize the COM Library CoInitialize (NULL); EXCEL / / CLSID CLSID clsid; HRESULT HR = CLSIDFromProgID (L, Excel.Application, clsid); If (FAILED (HR)) { : MessageBox (NULL), CLSIDFromProgID () function call failed! , error, 0x10010); Return -1; } / / create an instance of IDispatch *pXlApp; HR = CoCreateInstance (CLSID, NULL, CLSCTX_LOCAL_SERVER, IID_IDispatch, (void * *) pXlApp); If (FAILED (HR)) { :: MessageBox (NULL). Please check to see if EXCEL has been installed! , error, 0x10010); Return -2; } The Application.Visible property set / show, 1 VARIANT x; X.vt = VT_I4; X.lVal = 1; autowrap (dispatch _ propertyput, zero, pxlapp, l visible, 1, x); / / 获取workbooks集合 idispatch * pxlbooks; { variant result; variantinit ( result); autowrap (dispatch _ propertyget, result, pxlapp, l goal, 0); pxlbooks = result.pdispval; } / / 调用 workbooks.add () 方法, 创建一个新的workbook idispatch * pxlbook; { variant result; variantinit ( result); autowrap (dispatch _ propertyget, result, pxlbooks, l add, 0); pxlbook = result.pdispval; } / / 创建一个15x15的数组, 用于填充表格 variant type. wchar sztmp [32]. arr.vt = vt _ array | vt _ variant; safearraybound sab [2]. sab [0].llbound = 1; sab [0].celements = 15; sab [1].llbound = 1; sab [1].celements = 15; arr.parray = safearraycreate (vt _ variant 2, sab); / / 初始化数组内容 for (int i = 0; i = 15; i + +) { for (int j = 1; j = 15; j + +) { variant tmp; tmp.vt = vt _ bstr. wsprintfw (sztmp, l % i% i, i, j); tmp.b