é¦å
ï¼æ们æå¼åææ设置çå·¥ç¨é¡¹ç®ã
ç¶åï¼æ们å¨çé¢è®¾è®¡çªå£ï¼å å
¥ä¸ä¸ªlabelç¨äºæ¾ç¤ºï¼è¦ä¿åçç®å½ã注æ设置ä¸ç¸åºççé¢å¸å±ã
ç¶åï¼æ们å¨mainwindow.hç±»ä¸å建ä¸ä¸ªnewExcelçå½æ°ï¼ç¨äºå®ç°æ°å»ºexcelçåè½ã
å¨å¯¹åºçcppæ件ä¸ï¼æ们è¦å®ç°newExcelå½æ°åè½ï¼é¦å
ï¼æåæçæ¥éª¤ï¼å°applicationï¼workbookï¼worksheetè¿è¡èµå¼å¹¶è®¾ç½®ã
å
¶ä¸ï¼pApplication->setControl("Excel.Application");ç¨äºè¿æ¥excelæ§ä»¶ãpWorkBooks = pApplication->querySubObject("Workbooks");è·åworkbooksæéã
ä¹åï¼æ们éè¦ç¨QFileå
å¤æä¸æ¯å¦å·²ç»åå¨ååæ件ï¼å¦æ没æï¼æ们éè¿æä½excelç»ä»¶è¿è¡å建ãfile.exist()æ¯å¤ææ件æ¯å¦åå¨ãå¦æä¸åå¨ï¼æ们æ°å»ºä¸ä¸ªexcelï¼ç¶åè·åæ´»å¨çworkbookãç¶åéè¿dynamicCallè°ç¨SaveAså½æ°è¿è¡ä¿åã
ç¶åå¨æé å½æ°ä¸è°ç¨newExcelï¼æ们å¯ä»¥å建ä¸ä¸ªåå为fileNameçexcelæ件äºã
ç¨åºè¿è¡ä»¥åï¼ä¼å¼¹åºä¿åæ件ç对è¯æ¡ï¼å¨å
¶ä¸éæ©è¦ä¿åçexcelæ件åï¼ç¹å»ä¿åä¹åï¼ä¼å¨ä½ éæ©çè·¯å¾ä¸å建ä¸ä¸ªexcelæ件ã
ä½æ¯ï¼å½æ们åå¤å é¤æ¤æ件çæ¶åï¼ä¼æ æ³å®æï¼è¿æ¯å 为ï¼æ们ç¨åºä¸ä½¿ç¨pApplicationæä½excelçå½æ°å¹¶æ²¡æå
³éã
9
æ们å¯ä»¥å¨æºæ件ä¸æ·»å 以ä¸ä»£ç å
³éè°ç¨ãè¿æ ·å°±å¯ä»¥å é¤äºã
温馨提示:答案为网友推荐,仅供参考