ChinaUnix.net
Ïà¹ØÎÄÕÂÍÆ¼ö:

excelɾ³ýÖØ¸´ÐÐ

¡¡ÔÚexcelÖмÈëÊý¾Ýºó£¬ÎÒÃÇÒ»°ãÓø߼¶É¸Ñ¡À´´¦Àíɾ³ýÖØ¸´µÄ¼Ç¼£¬excel 2007±£ÁôÁËÕâ¸ö¹¦ÄÜ£¬Í¬Ê±ÓÖÔö¼ÓÁËÒ»¸ö¡°É¾³ýÖØ¸´Ï°´Å¥£¬Ê¹²Ù×÷¸ü¼Ó¼òµ¥¡¢Áé»î¡£ 001 ¡¡¡¡Ò»¡¢´«Í³·½·¨:ʹÓø߼¶É¸Ñ¡ ¡¡¡¡²½ÖèÈçÏÂ: ¡¡¡¡1.µ¥»÷Êý¾ÝÇø£¬Ñ¡ÖÐÆäÖеÄÈÎÒ»¸öµ¥Ôª¸ñ¡£Èç¹ûÖ»ÊÇÕë¶ÔÆäÖв¿·Ö×ֶκͼǼ½øÐÐɸѡ£¬¿ÉÏÈÑ¡ÖÐÕⲿ·ÖÇøÓò¡£×¢Òâ:Ö»¶ÔÁ¬ÐøÑ¡ÖеľØÐÎÇøÓòÓÐЧ¡£ ¡¡¡¡2.µ¥»÷¡°Êý¾Ý¡±±êÇ©£¬ÔÙµ¥»÷ÏÂÃæ¹¤¾ßÀ¸Öеġ°ÅÅÐòÓëɸѡ¡±ÇøÖеġ°...

by cfsjsc5753 - ´æ´¢ÎĵµÖÐÐÄ - 2008-06-28 10:24:45 ÔĶÁ£¨919£© »Ø¸´£¨0£©

Ïà¹ØÌÖÂÛ

¼ÙÆÚÖУ¬½Óµ½ÒµÎñÒ»¸öexcelµÄÇóÖúµç»°£¬±È½Ï¸´ÔÓ£¬½áºÏ°Ù¶È£¬¾­¹ýÒ»ÍíÉϵÄŬÁ¦£¬ÐÒ²»ÈèÃü¡£
»¹ÊÇ¿´Êý¾Ý˵»°£¬ÓÐÒ»¸öexcelÊý¾Ý±íA£¬Ô­ÐÍÈçÏ£º
±àÂë   Ãû³Æ      ¹©Ó¦ÉÌ
111   °¢ÄªÎ÷ÁÖ   ¹«Ë¾AAA
111   °¢ÄªÎ÷ÁÖ   ¹«Ë¾BB...

by zhongtang - ÒÆ¶¯²Ù×÷ϵͳ - 2011-01-12 15:27:30 ÔĶÁ£¨992£© »Ø¸´£¨0£©

ÔÚÓÃOPENOFFICE excel½¨Á¢Ð±í¸ñÎļþ ÐиßÓëÉèÖò»·û£¬×ÖÌå´óСҲ²»·û£¬ÇëÎÊÄÄλ֪µÀÊÇʲôԭÒò

by xzb99 - LinuxÐÂÊÖÔ°µØ - 2011-10-21 18:04:03 ÔĶÁ£¨3043£© »Ø¸´£¨4£©

¸ßÊÖÃÇ, ÎÒÖªµÀperl¶ÁÈ¡excelµÄʱºò¿ÉÒÔץȡsheetµÄ×î´óÐÐÁÐÊý.µ«ÎÒÏÖÔÚÏëµÃµ½Ä³Ò»ÐÐ×ܹ²ÓжàÉÙÁÐ »òÕß˵ÈçºÎ°ÑͼÖÐPower supplyÕâÐйýÂ˵ô,ÎÒÓÃdefined($WKS->{Cells}[$r][$c]->Value)û°ì·¨×öµ½,Ö±½Ó±¨´í л

by uzik - Perl - 2011-10-12 18:45:43 ÔĶÁ£¨2154£© »Ø¸´£¨1£©

ǰÄ꿪·¢¹ýµ×¶Ë±êÌ⣬´ó²¿·Ö¹¦ÄÜÒѾ­ÊµÏÖ£¬¿ÉÒÔ²úÉú1µ½6Ðеĵ׶˱êÌâÁË¡£ ÏÖÉý¼¶Îª3.0°æ£¬½«¼¸¸öϸ½Ú½øÐÐÍêÉÆ£¬²»ÔÙÓÐÈκÎÎÊÌâ¡£ µ×±ê±êÌâµÄÒâÒ壺excel±¾ÉíÖ»Óж¥¶Ë±êÌ⣬ûÓе׶˱êÌâ¡£¶øÒ³Ã¼¹¦ÄÜÓÖÏ൱µÄµ¥µ÷£¬ÎÞ·¨Íê³É´ó²¿·ÖÐèÇó¡£ÀýÈçҳüÖеÄ×Ö·û²»ÄÜÊDZäÁ¿¡¢Ã»ÓмÆË㹦ÄÜ£¬²»ÄÜÊǶàÐеȵȣ¬¶øµ×¶Ë±êÌâ¿ÉÒÔ½â¾öÒÔÉÏËùÓÐÎÊÌâ¡£ ±¾²å¼þ¹¦ÄÜ£º½«Óû§Ö¸¶¨µÄÒ»ÐлòÕß¶àÐÐ×öΪµ×¶Ë±êÌ⣬·½±ã´òÓ¡¡£ Ïà¶ÔÓÚÒÔǰ°æ±¾»òÕßͬÀà²å¼þ£¬...

by ÂÞ¸Õ¾ý - ƵµÀ½»Á÷Çø - 2010-01-10 23:13:45 ÔĶÁ£¨3797£© »Ø¸´£¨0£©

ÓÐÒ»¸öÎÊÌ⣺Óû§´Óexcelµ¼ÈëµÄÎĵµ£¬¸ÃÓû§È´Ã»ÓÐȨÏÞɾ³ý£¬¶øÓû§µ¥¸öн¨ÎĵµÊ±ÊÇ¿ÉÒÔɾ³ýµÄ¡£ÎÒÒѾ­ÔÚµ¼ÈëµÄʱºò½«Óû§ÃûдÈë¡°×÷Õß¡±ÓòÁË¡£È´×ÜÊÇÌáʾ£ºÓû§²»ÔÚÔÊÐíµÄ×÷ÕßÁбíÖС£ ÇëÎÊ£¬ÕâÊÇÔõô»ØÊ£¿ÈçºÎ½â¾ö£¿

by whocoodingforme - ·þÎñÆ÷Ó¦Óà - 2005-08-13 21:15:10 ÔĶÁ£¨1352£© »Ø¸´£¨1£©

ÏÂÃæÊÇ´úÂ룬¿´À´ºÜ¼òµ¥£¿ Ҫɾ³ýexcelÎļþÖеÄsheet1ÕâÒ³¡£ ·¢¹ûÕâҳΪµÄÄÚÈÝΪ¿ÕµÄ£¬ÔòʹÓÃ$workbook->Worksheets("Sheet1")->Delete()¿ÉÒÔɾ³ý µ«Èç¹ûSheet1ÖÐÓÐÄÚÈÝ Ôòɾ³ý²»ÁË¡£ Ôõô´¦Àí£¬Çë´óÉñ¿´ÏÂÎÊÌâ³öÔÚÄÄÀ лл£¡ #!/usr/bin/perl use Win32; use Win32::OLE qw(in with); use Win32::OLE::Variant; use Win32::OLE::Const 'Microsoft excel'; use OLE; $Win32::OLE::Warn=3; $application=CreateObject OL...

excel

by sandy_amao - Perl - 2015-04-09 08:33:19 ÔĶÁ£¨1700£© »Ø¸´£¨5£©

±¾Ìû×îºóÓÉ mswsg ÓÚ 2016-04-19 09:12 ±à¼­ [code]# ! /usr/bin/env python3 # -*- coding: utf-8 -*- ''' python3 find_common_line_in_two_excels.py file1.xls file2.xls output.xls ''' from xlrd import * import xlwt as excelWrite import os import sys input1 = os.path.abspath(sys.argv[1]) input2 = os.path.abspath(sys.argv[2]) output = os.path.abspath(sys.argv[3]) def open_excel(excel): try: ...

by mswsg - Python - 2016-04-26 09:21:10 ÔĶÁ£¨2480£© »Ø¸´£¨3£©

ÎÒÏëÒª°ÑÁ½ÐзÖΪһ×飬¶ø²»ÊǰÑËüÃǶ³½áס£¬¼´Í¨¹ý²Ëµ¥£º Êý¾Ý->×é¼°·Ö¼¶ÏÔʾ->×éºÏ ²úÉúµÄЧ¹û£¬²»ÖªÓÃSpreadsheet_excel_WriterÄܲ»ÄÜ×öµ½£¬ÇóÎÊ£¡ :em17:

by kytexzy - PHP - 2008-03-09 18:07:37 ÔĶÁ£¨1705£© »Ø¸´£¨1£©

ÎÒʹÓõÄexcel 2003£¬Êý¾Ý¿âÊÇsql 2000£¬ÎÒʹÓÃexcelµÄ¡°Êý¾Ý¡±¡ª¡ª¡°µ¼ÈëÍⲿÊý¾Ý¡±¡ª¡ª¡°Ð½¨Êý¾Ý¿â²éѯ¡±£¬È»ºóÎÒÔÚµ¯³öµÄms queryÖÐ ÊäÈ룺select * from person,ÕâÊÇÒ»¸öÈËÔ±±íµÄÐÅÏ¢£¬¹²ÓÐ7Íò¶àÐС£excelµ¯³öÁËÒ»¸öÌáʾ¿ò£¬ÄÚÈÝÈçÏ£º\"²éѯ·µ»ØµÄÊý¾Ý³¬³ö¹¤×÷±íÔÊÐíµÄ·µ»Ø\". Ò²¾ÍÊÇ˵ֻÄÜÏÔʾ65536ÐУ¬Ê£ÏµÄ1Íò¶àÐв»ÄÜÏÔʾ£¬Ë­Óа취ÈÃËûÏÔʾ³öÀ´£¬»òÕßÊÇÏÔʾµ½ÁíÍâÒ»Ò³¡£Ë­Óа취£¿

by netech - SQL server - 2007-08-14 00:09:17 ÔĶÁ£¨4251£© »Ø¸´£¨1£©

ÐÎʽÈçÏ£º Ö÷Áã¼þ ×ÓÁã¼þ1 ×ÓÁã¼þ2 ×ÓÁã¼þ3 p10-2800 1220805 2220704 0509002 p28-3500 1020609 2010601 0601802 ÈçºÎ±ä³ÉÒÔÏ£º Ö÷Áã¼þ ×ÓÁã¼þ p10-2800 1220805 0000000 2220704 0000000 0509002 p28-3500 1020609 0000000 2010601 0000000 0601802 :mad: :right:

by Arraylf5362633 - SQL server - 2007-06-11 13:40:15 ÔĶÁ£¨4389£© »Ø¸´£¨2£©