Znn3bq.jpeg
²é¿´: 1424  |  »Ø¸´: 11
µ±Ç°Ö÷ÌâÒѾ­´æµµ¡£

ÏÂÑ©Ìì146

гæ (³õÈëÎÄ̳)

[½»Á÷] ¡¾ÇóÖú¡¿ÇóÖú Ôõô±àдC/C++³ÌÐò¶ÁExcelÎļþÊý¾Ý

Ôõô±àдC/C++³ÌÐò¶ÁExcellÎļþÊý¾Ý
ÎÒÔÚÍøÉÏËÑÁËһϣ¬¶¼ºÜ¸´ÔÓ£¬¿´²»¶®¡£
ÎÒÖ»Ð轫Ïñ¶ÁtxtÎı¾ÎļþÑù£¬½«Êý¾Ý¶ÁÈëÄÚ´æ

±äÁ¿¡£

[ Last edited by nono2009 on 2009-11-17 at 13:39 ]
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

nono2009

³¬¼¶°æÖ÷ (ÎÄѧ̩¶·)

No gains, no pains.

ÓÅÐãÇø³¤ÓÅÐãÇø³¤ÓÅÐãÇø³¤ÓÅÐãÇø³¤ÓÅÐã°æÖ÷

¡ï ¡ï
Сľ³æ(½ð±Ò+0.5):¸ø¸öºì°ü£¬Ð»Ð»»ØÌû½»Á÷
ÓàÔó³É(½ð±Ò+1,VIP+0):лл²ÎÓëÓ¦Öú£¡ 11-17 16:11
ÏȽ«excelÎļþÁí´æÎª´ø¸ñʽµÄcsvÊý¾ÝÎļþ£¬È»ºó¾ÍÏñ¶ÁtxtÎļþÒ»ÑùÁË¡£
2Â¥2009-11-17 13:38:49
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

magic7004

½ð³æ (Ö°Òµ×÷¼Ò)

¡ï ¡ï
Сľ³æ(½ð±Ò+0.5):¸ø¸öºì°ü£¬Ð»Ð»»ØÌû½»Á÷
ÓàÔó³É(½ð±Ò+1,VIP+0):лл²ÎÓëÓ¦Öú£¡ 11-17 16:11
Excel¿ÉÒÔµ±³ÉÊý¾Ý¿âÀ´¶Áд£¬²»¹ý¶ÔÊý¾Ý¸ñÊ½Ã²ËÆÓÐÏÞÖÆ£¬²»ÍƼö¡£

»¹ÓоÍÊÇÓÃcomÀ´²Ù×÷excelÁË£¬¿ÉÒÔʵÏÖexcelµÄ¼¸ºõËùÓй¦ÄÜ£¬ÍƼö¡£

[ Last edited by magic7004 on 2009-11-17 at 16:08 ]
Á÷Ã¥²»¿ÉÅ£¬¿ÉŵÄÊÇÁ÷Ã¥ÓÐÎÄ»¯£¬ÓÐÎÄ»¯ÓÖBHµÄÁ÷Ã¥ÎÞµÐ~~£¡
3Â¥2009-11-17 15:48:23
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

jjdg

°æÖ÷ (ÖªÃû×÷¼Ò)

ÓÅÐã°æÖ÷

¶Ô
»¹ÊÇÓÃcom·½±ã£¡
ŬÁ¦Ñ§Ï°£¡ÒÔÕýµ±Í¾¾¶£¡»ñµÃÐèÒªµÄ֪ʶ£¡
4Â¥2009-11-17 18:57:00
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

ÏÂÑ©Ìì146

гæ (³õÈëÎÄ̳)

¸Ðл¸÷λ

¡ï
jjdg(½ð±Ò+1,VIP+0):ÓÃcomÀ²£¡Ö±½Ó¹Ò£¡ 12-9 22:59
·Ç³£¸Ðл¸÷λ¡£
µ«ÊÇÎÒ×öµÄÒ»¸ö³ÌÐòÖУ¬±ØÐëÒªÓÃc/c++¶ÁExcel±íÖеÄÊý¾Ý£¬¶øÇÒÎÒÖ»»áC/C++,²»»áÆäËûµÄÓïÑÔ
5Â¥2009-11-19 12:16:24
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

magic7004

½ð³æ (Ö°Òµ×÷¼Ò)

¡ï
Сľ³æ(½ð±Ò+0.5):¸ø¸öºì°ü£¬Ð»Ð»»ØÌû½»Á÷
º¹Ï£¬Â§×¡com²»ÊÇÓïÑÔµÄ...
Á÷Ã¥²»¿ÉÅ£¬¿ÉŵÄÊÇÁ÷Ã¥ÓÐÎÄ»¯£¬ÓÐÎÄ»¯ÓÖBHµÄÁ÷Ã¥ÎÞµÐ~~£¡
6Â¥2009-11-19 12:21:42
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

magic7004

½ð³æ (Ö°Òµ×÷¼Ò)

¡ï ¡ï
senlia(½ð±Ò+2,VIP+0):ÇëÎÊÄÜ·ñÏêϸ½²½âÈçºÎÓÃcom»òÕßdao´¦ÀíexcelÎļþ£¿Ð»Ð» 11-19 13:55
Ҫô§סÓÃDAO°ÑExcelµ±Êý¾Ý¿â°É¡£
Á÷Ã¥²»¿ÉÅ£¬¿ÉŵÄÊÇÁ÷Ã¥ÓÐÎÄ»¯£¬ÓÐÎÄ»¯ÓÖBHµÄÁ÷Ã¥ÎÞµÐ~~£¡
7Â¥2009-11-19 12:22:15
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

magic7004

½ð³æ (Ö°Òµ×÷¼Ò)

¡ï ¡ï ¡ï
Сľ³æ(½ð±Ò+0.5):¸ø¸öºì°ü£¬Ð»Ð»»ØÌû½»Á÷
ÓàÔó³É(½ð±Ò+2,VIP+0):ר¼ÒÐÁ¿àÁË£¡ 11-19 18:12
ÒýÓûØÌû:
senlia(½ð±Ò+2,VIP+0):ÇëÎÊÄÜ·ñÏêϸ½²½âÈçºÎÓÃcom»òÕßdao´¦ÀíexcelÎļþ£¿Ð»Ð» 11-19 13:55

Ïêϸ½²½âµÄ»°¿ÉÒÔд±¾ÊéÁË¡£
§ס¼ÈÈ»ÐèÒª²Ù×÷excel£¬»¹ÊÇѧϰÏÂcom»òÕßÊý¾Ý¿âµÄ֪ʶ±È½ÏºÃ¡£

ps£º½¨Òé§סÓÃvb»òÕßC#À´×öExcelµÄ²Ù×÷£¬¼òµ¥ºÜ¶àµÄ¡£ÖÁÓÚ¼ÆË㲿·Ö£¬ÓÃC++×ö³ÉDll¾ÍºÃÁË¡£

ps2£ºÂ§×¡¼ÈÈ»²»»á¶ÁдexcelΪʲôһ¶¨ÒªÓÃexcelÄØ£¿
§סÈç¹ûÊÇΪÁËѧϰµÄ»°£¬»¹ÊDZðÅÂÂé·³£¬ÕÒ±¾Êé¿´¿´¡£
Èç¹ûÖ»ÊÇÒª½â¾öÎÊÌ⣬ÄǾÍÏëÏë±äͨµÄ·½·¨°É¡£±ÈÈç°´ÕÕɳ·¢ËµµÄ£¬×ö³Écsv£¨Comma Separated Values£©£¬ËüÊÇ´¿Îı¾µÄÎļþ£¬Ã¿ÐÐÊÇÒ»Ìõ¼Ç¼£¬¼Ç¼ÖеÄÿ¸ö×Ö¶ÎÓöººÅ£¨Ó¢Îĵģ©·Ö¸ô¿ª¾ÍÐÐÁË¡£CSV¿ÉÒÔÓÃexcelÖ±½Ó´ò¿ªµÄ¡£
Á÷Ã¥²»¿ÉÅ£¬¿ÉŵÄÊÇÁ÷Ã¥ÓÐÎÄ»¯£¬ÓÐÎÄ»¯ÓÖBHµÄÁ÷Ã¥ÎÞµÐ~~£¡
8Â¥2009-11-19 17:06:45
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

wxl_23

¡ï ¡ï ¡ï
Сľ³æ(½ð±Ò+0.5):¸ø¸öºì°ü£¬Ð»Ð»»ØÌû½»Á÷
senlia(½ð±Ò+2,VIP+0):¸ÐлÄúµÄ½¨Ò飡 11-19 21:03
½¨Òéһϣ¬¿ÉÒÔÓÃpythonÀ´Ð´Ñ½£¬ÕâÑù¾Í¿ÉÒÔ¶ÁExcelÎļþµÄÊý¾ÝÁË¡£
9Â¥2009-11-19 20:00:58
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

magic7004

½ð³æ (Ö°Òµ×÷¼Ò)

¡ï ¡ï ¡ï ¡ï ¡ï ¡ï
Сľ³æ(½ð±Ò+0.5):¸ø¸öºì°ü£¬Ð»Ð»»ØÌû½»Á÷
senlia(½ð±Ò+5,VIP+0):Äú..ÐÁ¿àÁË 11-20 18:06
½ñÌìÓпգ¬Ð´Á˸ö¼òµ¥µÄÀý×Ó£¬Â§×¡¿´¿´°É¡£ÎÒÓÃVC++ 6.0 ºÍ Office 2003×öµÄ¡£

Ó÷¨£º
Ê×ÏÈ´´½¨»ò´ò¿ªÒ»¸ö¹¤³Ì£¨MFCµÄ»òÕßWin32µÄ¶¼ÐУ©£¬È»ºó°´ÏÂÃæ²½Ö裺

1¡¢°ÑÎļþExcelOperation.h¡¢ExcelOperation.cpp¡¢Excel.hºÍExcel.cppÈ«²¿¼ÓÈëµ½¹¤³ÌÖС£
2¡¢´ò¿ª¹¤³ÌµÄStdAfx.h£¬Èç¹ûÀïÃæÃ»ÓÐ#include£¬¾Í¼ÓÉÏÕâÐС£
3¡¢Ñ¡²Ëµ¥Project-->Settings...£¬ÔÚProject Settings´°¿ÚÖÐÑ¡C/C++±êÇ©£¬È»ºóCatagoryÑ¡Code Generation£¬È»ºóUse run-time libraryÑ¡Multithreaded »ò Multithreaded Dll£¨¿´¸½¼þͼƬ£©¡£
4¡¢ÔÚ§ס×Ô¼ºµÄcppÖмÓÈë#include "ExcelOperation.h"¾Í¿ÉÒÔʹÓÃExcelOperationÀàÁË¡£

Àà°üº¬OpenXls£¬CreateXls£¬CloseXls£¬ReadCell£¬WriteCell ¹²5¸ö³ÉÔ±º¯Êý£¬²ÎÊý¶¼ºÜ¼òµ¥£¬Ó÷¨¿´ÏÂÃæµÄÀý×Ó¡£
CODE:
#include "stdafx.h"
#include "ExcelOperation.h"

int APIENTRY WinMain(HINSTANCE hInstance,
                     HINSTANCE hPrevInstance,
                     LPSTR     lpCmdLine,
                     int       nCmdShow)
{
        // TODO: Place code here.
        ExcelOperation excel;
        try
        {
                excel.CreateXls("D:\\sss.xls");        //´´½¨D:\sss.xls
                excel.WriteCell(1,1,1,COleVariant("Hello! :-)"));        //ÏòSheet1µÄA1µ¥Ôª¸ñдÈë×Ö·û´®Hello! :-)
                COleVariant va = excel.ReadCell(1,1,1);        //¶Á³öSheet1µÄA1µ¥Ôª¸ñ
                CString s("Sheet1!A1 =");
                s += va.bstrVal;
                MessageBox(NULL,s,NULL,MB_OK);        //ÓÃMessageBoxÏÔʾÆäÄÚÈÝ
                excel.CloseXls();        //±£´æ²¢¹Ø±Õsss.xls
        }
        catch(char* e)
        {
                MessageBox(NULL,e,NULL,MB_OK);
        }
        catch(...)
        {
                MessageBox(NULL,"Something Wrong! :-(", NULL, MB_OK);
        }
        return 0;
}

ps£ºËæ±ãдµÄ£¬ºÜ´Ö²Ú£¬Â§×¡¿ÉÒÔ×Ô¼º¼ÓÈëÐèÒªµÄ¹¦ÄÜ ºÍ ´íÎó´¦Àí´úÂë¡£

[ Last edited by magic7004 on 2009-11-20 at 16:54 ]
Á÷Ã¥²»¿ÉÅ£¬¿ÉŵÄÊÇÁ÷Ã¥ÓÐÎÄ»¯£¬ÓÐÎÄ»¯ÓÖBHµÄÁ÷Ã¥ÎÞµÐ~~£¡
10Â¥2009-11-20 15:16:24
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ ÏÂÑ©Ìì146 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] ²ÄÁÏ307·ÖÇó´óÀÐ×éÊÕÁô +15 Hllºú 2026-04-07 15/750 2026-04-08 22:35 by Öí»á·É
[¿¼ÑÐ] 070300»¯Ñ§279Çóµ÷¼Á +13 ¹þ¹þ¹þ^_^ 2026-04-08 13/650 2026-04-08 22:29 by belle15
[¿¼ÑÐ] ÉúÎïѧ328·ÖÇóµ÷¼Á +9 ÉÁµçkkl 2026-04-08 10/500 2026-04-08 21:42 by liuhuiying09
[¿¼ÑÐ] 318Çóµ÷¼Á +13 ykyhsa 2026-04-05 15/750 2026-04-08 21:37 by wj165256
[¿¼ÑÐ] 273Çóµ÷¼Á +41 ÂóС¶£µ± 2026-04-06 48/2400 2026-04-08 15:16 by screening
[¿¼ÑÐ] ²ÄÁϵ÷¼Á +13 ºº123456 2026-04-07 14/700 2026-04-07 22:53 by À´¿´Á÷ÐÇÓê10
[¿¼ÑÐ] 333Çóµ÷¼Á +6 ºÏ³ËÑîϰϦ 2026-04-06 6/300 2026-04-07 09:44 by Öí»á·É
[¿¼ÑÐ] 372Çóµ÷¼Á +4 jjÓ¿77 2026-04-02 4/200 2026-04-07 09:31 by °×ÔÆ¶ä¶ä·É
[¿¼ÑÐ] 285Çóµ÷¼Á +15 ŶßϺôo 2026-04-04 17/850 2026-04-06 23:02 by chenzhimin
[¿¼ÑÐ] Çóµ÷¼Á +5 С›g 2026-04-03 5/250 2026-04-06 22:45 by 875465
[¿¼ÑÐ] ר˶304ÕÒµ÷¼Á£¬Ò»Ïß³ÇÊÐ×îºÃ +3 ÀîlslÀî 2026-04-05 3/150 2026-04-06 12:16 by ffffjjjj
[¿¼ÑÐ] 306·Ö²ÄÁÏÓ뻯¹¤Çóµ÷¼Á +7 Àè°ÉÀ²À²ÄãºÜÓÐà 2026-04-03 7/350 2026-04-05 17:18 by Hdyxbekcb
[¿¼ÑÐ] 283Çóµ÷¼Á +4 mcbbc 2026-04-03 5/250 2026-04-04 20:51 by imissbao
[¿¼ÑÐ] 0835ѧ˶299Çóµ÷¼Á 08´óÀà¿É½ÓÊÜ +5 useryy 2026-04-03 5/250 2026-04-04 20:07 by À¶ÔÆË¼Óê
[¿¼ÑÐ] 085701Çóµ÷¼Á +7 ¹¨ÓíÃú 2026-04-04 8/400 2026-04-04 13:49 by ССÊ÷2024
[¿¼ÑÐ] 294Çóµ÷¼Á +6 Grey_Ey 2026-04-03 6/300 2026-04-03 20:46 by ÐÀϲ777
[¿¼ÑÐ] Çóµ÷¼Á»ú»á +5 ÒâȾivy 2026-04-03 5/250 2026-04-03 15:13 by qoooooo614
[¿¼ÑÐ] 279Çóµ÷¼Á +6 qazplm0852 2026-04-02 6/300 2026-04-03 10:03 by À¶ÔÆË¼Óê
[¿¼ÑÐ] Ò»Ö¾Ô¸°²»Õ´óѧ0817»¯Ñ§¹¤³ÌÓë¼¼Êõ£¬Çóµ÷¼Á +14 ÎÒ²»ÊÇÖ»Òò 2026-04-02 15/750 2026-04-03 09:49 by À¶ÔÆË¼Óê
[¿¼ÑÐ] 295Çóµ÷¼Á +7 Ô¸ÂÃ;ÓÀԶ̹Ȼ 2026-04-02 7/350 2026-04-03 08:22 by fangshan711
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û