MFC关于excel的配置及使用

来源:互联网 发布:linux重启eth0网卡命令 编辑:程序博客网 时间:2024/05/22 13:57

1.目前可用的资源文件excel9.h及excel9.cpp包含excel操作接口类,支持office 2013下的excel版本

2.在MFC stdafx.h 头文件加入#include "excel9.h"

3.简单应用,代码如下:

_Application app;Workbooks books;_Workbook book;Worksheets sheets;_Worksheet sheet;Range range;Font font;Range cols;COleVariant covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);/*font=range.GetFont();font.SetBold(COleVariant((short)TRUE));*/if (!app.CreateDispatch(_T("Excel.Application"))){this->MessageBox(_T("无法创建Excel应用!"));return;}books = app.GetWorkbooks();book = books.Add(covOptional);sheets = book.GetSheets();sheet = sheets.GetItem(COleVariant((short)1));range = sheet.GetRange(COleVariant("A1"), COleVariant("A1"));range.SetValue(COleVariant("Test Cases"));range = sheet.GetRange(COleVariant("B1"), COleVariant("B1"));range.SetValue(COleVariant("Similarity"));range = sheet.GetRange(COleVariant("C1"), COleVariant("C1"));range.SetValue(COleVariant("Difference"));int index = 1;CString sNum;for (int i = 0; i < m_vsTcxySimDiff.size();){
<span style="white-space:pre"></span>index++;sNum.Format(_T("%d"), index);range = sheet.GetRange(COleVariant("A" + sNum), COleVariant("A" + sNum));range.SetValue(COleVariant(CString(m_vsTcxySimDiff[i++].c_str())));range = sheet.GetRange(COleVariant("B" + sNum), COleVariant("B" + sNum));range.SetValue(COleVariant(CString(m_vsTcxySimDiff[i++].c_str())));range = sheet.GetRange(COleVariant("C" + sNum), COleVariant("C" + sNum));range.SetValue(COleVariant(CString(m_vsTcxySimDiff[i++].c_str())));
}
//字体设置
<span style="white-space:pre"></span>//font = range.GetFont();<span style="white-space:pre"></span>//font.SetBold(COleVariant((short)TRUE));

注:

<span style="font-size:18px;">COleVariant()接受CString类型输入</span>
<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAVYAAACrCAYAAAA91LTwAAAaUklEQVR4Ae2du4plR3SGe4ykSAj0ChNIgR5BoQODU7+CEQanxvYrGJwaDPZzWBjh2A4VSImCDpUqUaSrWTP80t9rVl13Ve3aZ/8HeuqyVq3LV7XX7N7ndPer5+fn35/0EgEREAERGEbgL4ZZkiEREAEREIE3BFRYdRBEQAREYDABFdbBQGVOBERABFRYdQZEQAREYDABFdbBQGVOBERABFRYdQZEQAREYDABFdbBQGVOBERABFRYdQZEQAREYDCB9wbbqzb33XffPb3//vvV+ndT/Pnnn58++eSTu6Vdne+PP/749OGHH1brS/E4ATHPM2Q+p92x/v67fuArt03ik6Pz9PTrr7/mFSQdTkDM80iZjwprntVpUhXWPPpffvklryDpcAJinkfKfFRY86xOk6qw5tHz3UFeU9JRBMQ8T5L5LCusP/zwQz4qSUWggQAf4oZlUj1AQMzz8JjPkjevrKh+//33Tx9//PEfke12R/a3//UvT//51//0R3xnd3bg8/r16xDD8/NzOL9ykr/tWun3iK+I5w4sa3PagfnODJnP9MKKouo3b4fC4WPaabwDH7vo7SD7iz+aW82O7w5W++7xFzGLikSP7VVrdmAencmI7Som7If5TH0UkCqqFswOhQNQcLdq7S6vnfjswoTj4LsDnt+xv8uFf5TNrsxRbI/md3Q985lWWHNF1RJQ4chv4658dikSfHeQJ7mv1H8nsG+kbyN7BOYzGTOfKY8CSkV1ZnKyPZ4Af8u6SzHgQzw+Y1mMCIh5ROXPOeYzvLDWFtVd78j+xHRubyc+XEx3uWPlb7vO3an7eBfz/F4zn6GPAmqLqoW3S+HAc1Xf5hHOl+7Cx2e6y/MsvjvwMWo8h4CY57kyn2F3rC1F1cLbqXDwx6xQYPMI50t34jM/23YPfHfQvnqPFbvc/dfSeATmtbn26DGfIXesrUW1J2itEQEmwHcHPL9jP7rLv1pRNa67Mt+FJfMZcsdqH/znD//XHO4d7shwd2qt3bX6cU0es3R24GMH1l5okSs/c8Xc6pYP8WrfPf58cd2BYWseOzDHWURrOezCkvkMKaytG2T6OxQOfgRgMflxT16j1uzAZ5cDGzHlb7si+Y5zO/Os4bUD850ZMp9TCutf/tvf1eyjdP736el//v7fxSEgwHcHgVhTEwiIeR4q83n15ZdfvvnFqHyHhL5vzayfw7hF9o//9x/5CCX9g8A/f/I3f/TVEQERuAaB9z744IPTIn3+1/8+zffujl//w1+9CfGLL77YPdRT4vv222+fPvvss1N839WpmOd3nvkM+VRA3p2kIiACInAvAiqs99pvZSsCIrCAgArrAshyIQIicC8Cp3wq4F6I12X76tWrN874DcUW77n1kJm9XvulWODjbPulOEryUp6SPz6BrjtWfJB+FB47qKmvUT5G2IliHGG31saZ/q3YzSp4tfmn9EZyMVvI1fr+VZJ7fY3vSaDpjnV0QWXkuGhxcE0WHWxe09Nn+y3ro3Uz4kvFVOMfDFM2SvNH15fsl+Q1/iMOts7P+7H5rrHPMZb0S3K2pf69CDTdsdpPJs346aTUAU3Nr96i6CJdHYP8tRGws2P7ppcInEGgqbCeESD7tAuFv1hmfZb5iwoy1vPrW8e+8MOH9w27LI90IId+qWX/WJuzW6tT8puSp+z7eT82e9Ec+4Ecuiyr6WO9tdELcpNxH7o8x33IeZ2XY2yt12tZn1sLO94X5v1axMJy9ccRuExhtYNghYS/+HB4uUeEdTbPfa/XO/b+OTaz6eXeD8u9zMYWs+l4u9DN5WQy2EDr7eTWw0eu5fgRK/TZNutBbi3r8Dz6LLd+64vXR2tZzn3o8hz3Iee8IAdjjE2X9bDWz0Of10c6kMMO2zYbLPcyL4cNtWMIND1jHeNyjRU7OCtf7I8PdCoG1k/p+HmsgX2Mvd4ZY44F8UVxsB73I91HnOOcuV+Ta04fhZPt5PRZT/3xBC5VWEsXLMvPOFTwb77Rx5b5uSg+rIlksGMt5KaPPsvP6nP86J8Vyxl+j+Z8dH0p59n2S/7vJL9UYS0VEZbbIeLxjE1lH9xP+eJ4In2WexuRvtc5c7x7fCvY5Pavxv/R9SUfs+2X/N9JfplnrNGm2MWMF/cxV2pr19iB9Lo2Th1Ur2txRHOl+K4q3yHX3P6s4nqUQ8v61BnN5dpiP2dHsncJNN2x8udY0R/58StstLW+aEUHx+tgvaXpZUid7aR0oMstr4vssxx9n0cuPh9L9Ju/eL2PgWXowybGnI/1bT7SgT5k0MX6SG66PG99++J5tsO2eZ77XsdksPfNN9/Y8M0LftHapF/LMvRZB3O2Fv0WOeJ6G9Hbf7Ee9lK2bb5mvdnxNnnO24Buyf7baPXvSAJNhXVkEY2S4IPQKi+tZXstui3r2C73zYYfs13u49cF8pwV2dL6nJxl6KOFHz/GPNqS3PRYJ9WHPd+yvpf5senar2jDq2ZtSeeo3GJJ2UjNI360Kb1oPprLxVCSIQa1Ywhc+lHAGASyIgIiIAJjCbz3008/vbHI/wOi71tT9HMYt8pMP7o7exPMTf+Jvv03FHx3dlM0YdriEmKZOinmebzg896nn36a15wh1Z9maaKq35T/Li47wOLyLpeZM2Kep8t8mp6x5s3WS+0P5H311VdP+rMj9cykKQIicB0CpxTW6+BZHykeB/D/fuujkEcREIEjBLZ988o+RsIfUzmS5BXW3i3fK+yJYhSBXgLbFlZLiN8Y601wh3U1RfNRct2Bt2IQgbMJND8KeP369YuYn5+fX4xnDHJ3rlyQIj2W98YW2YUtth/pmdy+IhlsnNH6eEp5WIwpHZ6vzSXnHzag02MfNh6tPcIEa8GEuXpZpIM5tWUCTYXViqovpNFc2W27Bg6BHQDuwxLP8xz6R1v2yX3Yne0ffka0qViRl/ngvvfp1/ux1/fjSN/P8Zj73tadxsyB+zUMIn0/5/fc5Hr1Edj6UQBS8hvu5/0BgXxUe7b/UXnMsmN8Rl6Efj9T/Gfls6PdiMlI5p6x97cjk51jarpj9XerOydmsUWHBTF7GeZHtpEPvhgi+Uj/KVs1fjlOs1OzJuWvd55jOMN/b9w7rmvhp6J6fAebCqt3N+sxwIyN9Tb92Oc2Y+x9+rEdfj83Iw5vM/LpL8RIB3ZM1vJCnrym5C/nn+2oX0dAPOs49Wp1PwqYVVQtkejC600Q6/jCbS0EsHG05RgiW2cc9shnKU7sj62N1ke5RXNmJ+UrNR/Z0VwbgSN71ubpvtpdd6wzi+rMrbADZS8Uhpm+rmD7yAV2pPB5v9iPIzavwHuHGD17H1NJ7vU1jgk037FeqajaIcELB2blxcv+EccuLXhE8ewcdxSv5uoI5Pa8zoK0agk0FdaoqNrc2S/c8XAcuUMUFQ6bi+bZZqrf6j9lZ9V8xKY1d9b39mzM8ta8Ip6tNh5N3zNpZe71jc+RPXo0vqPzaX4UcGYhxUGIDok/eDbmF8vRZzuY4zW+f8S/2cJ62PUxYn5F62NhnxELHyvreBnbivq8FnJvw+t4OdbdqWUmPTxye34njitybSqsqz9uZQeBDxD3Izgt8pLuUft+fcnfykNfisViP6JzZC1zq7HD+nfop5ik5sGkJG/Vg77amEBTYY1NzJmtPQijvPsiPspurZ3V+dbGJT0REIF2Aq++/vrr33/77bcnfNkFjr5vU7LUvK1PyWz+888/b49YK0RABERgcwLvffTRR6eEaL/oWr8BPo1ev481zcYk4pPnM0Mq5nmqzKfpUwF5s5KKgAiIgAgYARVWnQMREAERGExg28JqbyatfKd8MNdmc3fLtxmQFojAhQhsW1iNob3BdZfXnXK9y54qz/sSaP64lf8BgRWfbc3duXJBivRY3rvNkV3YYvuRHsuxZofWxxrFCR0vw7zPw+t5uR/Djl+Hea/v9bz8DmOwaWWBdZ4R7JTkfp3GeQJNhTX1I60riisfAO4jPTsYmOc59I+2sM1++DDyPHyxHHM7tKlYkaPFyDrcR/ysC33Ialq2yX2s9fYxf+eWOXG/lkmJaUle60d6F3nzKrXhmO85ZC2bDz9+DeZn+/d+Z499PpanzeGFvDH2+phPtV7f20+tu/O8mF1r95vuWP2daXQHu1P6UQFAfF6G+ZFt5CNXoEb6ztmK4srp52T+gs/ptsiYk60bGXNLHI+kW2Jakj8Si9m5NBVWBIPnrL7QQn60nXGxept+fDTmmvXepx9b8fBzNXaP6pzhsxSzL6Q7xljKYTd5iWlJvls+O8fT9akAK6j2hQI7OkEUmJF2+dDYRbr6FRUGjsniiXRmx3mGz1JOnktJX/IygRLTkrzsQRpMoKuwwsDM4gofI1srIjsWkpE5ttg6yuLo+pZYpSsCVyLQVFhn3aHOAmYXPl4oAiv/Z2b/iGOXFjx2iYfj2Jkbx3mlfolpSX6lXHeItamw7hBwFIMVS38wbJwqol7XbNpcNB/583M1/lM63taKccSGc/exRvq5OE2f7Xndo/a9vTuMS8xKzO/AaKccm968ir71t7lVL1ys1tpB45c/eDk5dNkO5tim7x/xb7a8Dx+j9zdzjFxSPjjWGXHm7LMM8c2IAbav0jKXVh68FvmyjZIca9TWEWgqrGZydSH1m59Li3UjPZZzP9KN5kprSnKzmdIpFboont65VAzeXkkvJU/Nt9ivteFtPvo4xSU1zzxKOiU521I/T6C5sObNjZOu3mS+ex2XRb2l1fnWRyZNERCBVgL6CwKtxKQvAiIgAgUC+gsCBUBnifm3kZ8Vw85+xWf97oh5njnzeYhPBeTTlVQEREAE1hJQYV3LW95EQARuQGDbwmpvJq18p/zsvb5bvmfzln8RmElg28JqST/yO+W+kD5yrjMPsGyLwI4EDhXWVT/iiiIUtQy1JGfdln5kF3NsB3Pcspz7uxdSzsH60Qs6XoZ533q90jjlt7TukeVg2poj1vkWdvw8xpCrbSPQ/TnWVUUV6aAQ2YZzH3Ke5zn0j7bsk/uwO9s//KxoU7kgb4uBdbiP+FgX+pCVWrOn17sEmDP339WMZ/yeeK2S3OtrnCZw6I41bXasJLXhmO85ZC0Rwo9fg/nZ/r3fs8c+X+Ngc3iBC8ZeH/Op1tZ7Gyndu8x7hp75XThcJc+uwmp3qyt/tLUXpr847XDiq9dmy7qcf4tj15eP+0icviAcsaW1xwjg7KP11jCP1ss1rifQ/ChgRVG1jR15cRsOb9OP65H1aUb+bI5flnOkxzpn9HeM6QwOV/fprym/ryX51fNfGX/THeuKomrJo8CMBMGHxhe0kX6O2PIH/YitUWt3jGlUbneyw+c/yrskj9ZoLk2g646VzeFNrCs8GkBBnVG4mcmj9I8W1aPrH4Wj8rgfgabC6ovnqjvY3m3hC5v7vfZa153hszXGlP6VY0/ldOf50n6W5Hdm15N706OAHgcr1kR3oLmDYjL/srlo3utF41b/ZqPXV+R/9JzF5r815Hh9vpF+LibTZ3s5XcneEigxF9O9TkrTHStCx7f/Nl5514qL0Vp/4fuDl5NDl+1gDjlG7Sj/Zhv+OIbI51lzyDXlH/Ejl5Rezzz7Rt/83f11hDmvBUdmWpJjjdo6Al2F1T8SqHPVruWLDh+EyFqLvKR71H7Neo4BBSRat3qO48r5Luml5Kl5+CrJoXfHNsUmNc+MSjolOdtSP0+gq7DmTY6Rrt5kX8THZFFvZXW+9ZFJUwREoJWA/oJAKzHpi4AIiECBgP6CQAHQWWL+beRnxbCzX/FZvztinmfOfB7iUwH5dCUVAREQgbUEVFjX8pY3ERCBGxDYtrDam0k7vVM++yzcLd/ZPGVfBM4ksG1hNSij3im/QtEaleuZh0m+RUAE3hJo+rgV/2AAA5z9udbcnSsXpEjP5PYVyTiHXD+3tsZ/zvauMp8z54mYTSeah7zUwkfJxlE/pTgeSV7L1OeMdX6+tDdeX+O3BJoKqy2ZXURTG4MN5ouMDwPPwwbLMdfbnu2/N+6edSmWzKDHLq9hH9xnHeuP3ENv+9HGzJH7tXlif6Ev9iDR3m79KADp+A338z2HCDZq2rP918S4Usd4pJjUxOH3y2zpIq4hl9Y5ytTvp7eX9ixJRKD5jtU/DjjrDjZKxs/5w2JyvoAjubdxZBzZX+m/N3Yf91kXGfwys96ctK6eALjXr5CmJ9BcWH0hnfFLWGZtrLfrxx7O6LH358dW0Pzc6Bha7Fks9vKFtsVGr+5OHHpz0Lr7Emh6FOCL6ixsKDCj7Z9RIJBDVCh8PJEO1p/RWnyz9iKXz24ccrFKJgIRgeY71siI5h6bAIqr/49gZtZWXPmF8coY2P9d+vpPbcxON92x+uerY0KYZwUX4zwPectn+89Hl5aeHbcVT/6ySDFORy2JCOxDoKmw7hP2y0jsovPFwMY2X/syfW+jdm2N/5ROrY8r6ZVYehate3UlFqtiLTEt7cmqOO/ip+lRgD1j9Xetq5672oag8EUXoj9YNvYvrMc86/j10OEW63v9ex/sn/2c3fdxWjwcKzjYPPosr4mffaTWwjb8pPRq/N1Bp4bpHTjskGNTYbWAVxdSvpi4H8HLyXOyyFY0V7JRkpvNlA4Xkcj36rlUnLkcEGNuLXRG2mGbd++n2KfmPa9aPb9O45cEmgvry+XzRqs32Arbap9M70zfHIf6IiACxwnoLwgcZygLIiACIvCCgP6CwAsc+wz4t5HvE9U+kYjP+r0Q8zxz5vMQnwrIpyupCIiACKwloMK6lre8iYAI3IDAtoXV3kza7Z3ymefhbvnOZCnbInA2gW0Lq4EZ9U75jkXLxzQq17MPlPyLgAg8PXV93Ao/JLDqM625O1cuSJGeye0rktUegNzaGv+Rn6MxRTZb5ywvjt+vR945HVtTsuPtYg3Psw/4Zbn1WcfLNH5LAOxaWWGd59hqx6+/67i5sPKvCeT+bIDYYL6I+TDwPGJhOeZ627P998Ydravhwjy57+3V2IrWgCdk3oeXQ09tmgAz5H56xUuJZ96zty8t3nfU9CjAF9JVd6x+w7FdmO85RLBR08KP18X8bP/e79GxxY3YI1s+H9PVRRaR2mfu6J758+Dt7ZPpNSJpvmO1tPAowPqrimsPTn9YzAYXiEje4ye1xttn36k1V5rHxTcjL2/Ts7wSp6vFin29Wtw7xdtcWP1dqx+PSG7Wxnq7fjwi9pSNyJfN8cuKR6THOrv0j8SJPDkXXzj9+Ig/9qO+CKwg0PQowAJacYcaXXgjYPiLdYTNkTauUjxGxWn7Ee1JNDeSs2yJwGwCzXesswOS/WsQsOLKL4xriqIvzLbGz7Ft9dcR0D6MYd18xzrG7RoruNjXeHvXy9n+341ozIwVQv4yqxiP8PCo3EawkY1rEGgqrPYYgN+42iVF3PFwPK3/85p+7wXd47/XF+c4q+/zWclyVk6Pbre0Z0fO96Ozm5Ff86MAX1xXPHNF4ihG0YXuD5aN/QvrMc86fj10uMX6Hv/ePsaRLfY5o488zDb6zMLmER/6URxYCzveRrQG9ngt5qDPvnkOfbUxAeZWuxexJc0eJdBcWM3hqmJqFx8fEO5HiefkOVlkK5or2WiVs74vNJH/UXPsN2ezpJeSp+bZV0mnJGdb6v9JIMUtNf/nyre9Wj2/TuOXBLoK60sTc0arN9gX8TlZpa2uzjcdiSQiIAJHCegvCBwlqPUiIAIi4AjoLwg4ILsM+beR7xLTTnGIz/rdEPM8c+bT9KmAvFlJRUAEREAEjIAKq86BCIiACAwmsG1htTeTVr5TPphrs7m75dsMSAtE4EIEti2sxvCR3yn3hfSRc73Q9aBQRWAIgaaPW6V+6mr251pzd65ckCI9lvcSi+zCFtuP9FiONdbafKTPOmf2fWw+D5Z7WSluXsu6sFOS8xr1xxIw9tiHsZbvZa2psBoaX0RTxXY0Rmw2bzxfgDwP3yzHXG97tv/euHvWpVhGDMx+pF/yC1vQ83vl5dBTO4eA5z/Hy32sNj0KiIqqn5uBLnWRYb7nwm6JE378GszP9u/97jY2Di0XJrghj7vzA4czW9sTvy9nxnN13813rEh4xi+4hu1RbXRQuABE8lG+zY63z75H+hltK4rbz43ymSqqntUs/6PykB0RYALdhZWNjO6nLrajfrxdPz5qP7c+8mVz/LLiEemxzso+4isVNeiNjM373InLyDxl6zEJND0KWIUABWakv+jC9BfvSH89tqIYe+yMWmN8or3AnMU7I+bd9mUUT9m5D4GuO9YrPAa4zxbOzxSFlAse93sjmFGUe2PROhEYSWDLO9ZRCdqFe+brbP+9uZ8d99n+e7lpnQiAwEMUVtxRISlr7eLku6qUDtaYfu8FnbLN/uEHba8vrD+75fitz7namOVnxyr/IrCaQNejgNVBwh8uVn8hm9wXN77QsT6n42VYw+0R/94+xlEu7POMPmJj3zbHL9bxMtbr6bNtrB/tA3bVviWAs20j9MW8/3R0FdYVn13FBvPmcj9KuSS3NTU6ke2atSXbXs5jHOaU79XzHFvKd0onNe/t5PRyMm9H4+MExPs4Q7bQVVjZwKz+6o0++85xdb6z9k12RUAEnp70FwR0CkRABERgMAH9BYHBQEeZ499GPsrmI9kRn/W7KeZ55sznIT4VkE9XUhEQARFYS0CFdS1veRMBEbgBARXWG2yyUhQBEVhLQIV1LW95EwERuAGB5o9b+V9sveozrTfYC6UoAiLwIASaCmv0y1eiuQdhozREQAREoIuAHgV0YdMiERABEUgTUGFNs5FEBERABLoIND0KsOepesbaxVmLREAEbkSg647VCqzetLrRKVGqIiACTQSaCqt/oyq6g23yLmUREAEReEACTYX1AfNXSiIgAiIwnIAK63CkMigCInB3Anrz6u4nQPmLgAgMJ9BUWM273rQavgcyKAIi8GAE9CjgwTZU6YiACJxPQH9B4Pw9UAQiIAIPRuD/AT1QQd92dJWqAAAAAElFTkSuQmCC" alt="" />

0 0
原创粉丝点击