ÔõÑù ͨ¹ývb ¶Ôexcel µÄÊä³ö¸ñʽ½øÐÐÉèÖã¿
ÎÒÊÇÐÂÊÖÏ£Íû´ó¼ÒÄܹ»¸øÓë°ïÖú£º ÎÒÊǰÑdatagrid µÄÄÚÈݵ¼³öµ½excelÀïÃæ£¬ÔÚ datagrid ÀïµÄÈÕÆÚ£¬Ê±¼ä µ½excel ÀïÃæ ¶¼²»ÄÜÕý³£ÏÔʾ£¬µ«ÊÇÔÚexcel Àï ½«µ¥Ôª¸ñ¸ñʽ ÉèΪ ¡°ÈÕÆÚ¡±»òÕß¡°Ê±¼ä¡± ºó¾Í¿ÉÒÔÏÔʾÁË£¬ÏëÎÊϸßÊÖ ÔÚ³ÌÐòÀïÔõÑùÌí¼Ó´úÂë¾Í¿ÉÒÔ Ö±½ÓÕý³£ÏÔʾÈÕÆÚʱ¼ä
CStrº¯Êý»òFormatº¯Êý °ÑÄãµÄÈÕÆÚÀàÐÍת»»Ò»ÏºóÔÚ¸³Öµ °´Â¥ÉϽ«Êý¾ÝÀàÐÍת»»Ò»ÏÂ,»òÕßÔÚexcelÖÐÂ¼ÖÆÒ»ÏÂÄã×Ô¼ºÉèÖÃÈÕÆÚ¸ñʽµÄºê Äܲ»Äܸø¶Î´úÂë °¡ ÏàËÆµÄÀý×ÓÒ²ºÃ °ÝÇóÁË£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡11 ¼¸öºê·ÖÎöϾÍOKÀ²~~ ÉèÖÃexcel¸ñʽ£¬µ¼³öʱcopyÕâ¸öexcelÎļþ²»¾ÍÐÐÁË£¬Ð´Ê²Ã´´úÂë°¡£¡ Aspose.Cells Ç¿´óµÄµÚÈý·½Èí¼þ. ÏÈÉèÖõ¥Ôª¸ñµÄ¸ñʽ,È»ºóÔÙ¸³Öµ¾Í¿ÉÒÔÁË. xl.Worksheets(1).Cells(i + 1, j + 1).NumberFormatLocal = "@" xl.Worksheets(1).Cells(i + 1, j + 1).Value = ÊýÖµÒýÓà ÏÈÉèÖõ¥Ôª¸ñµÄ¸ñʽ,È»ºóÔÙ¸³Öµ¾Í¿ÉÒÔÁË. xl.Worksheets(1).Cells(i + 1, j + 1).NumberFormatLocal = "@" xl.Worksheets(1).Cells(i + 1, j + 1).Value = ÊýÖµ ¶¥Ò»Ï xlSHEET.Columns("A").NumberFormatLocal = "yyyy-mm-dd " xlSHEET.Columns("B").NumberFormatLocal = "hh:mm:ss " ÔÚ ¸øexcel¸³Öµºó ¼ÓÉÏÕâ¶Î´úÂë¾Í¿ÉÒÔ½â¾ö ÔÙ´Îлл´ó¼ÒµÄ°ï棬СµÜ²»Ê¤¸Ð¼¤£¡ http://download.csdn.net/source/1262359
Ïà¹ØÎÊ´ð£º
ÔÚÏÂÊÇvbµÄÐÂÊÖ£¬Ïëд¶Î³ÌÐò£¬ÔÚvbÖУ¬Ê¹ÓÃwscriptµ÷ÓÃһЩÍⲿµÄÃüÁµ«ÊdzÌÐòÖ´ÐÐÒ»Ö±ÓдíÎó£¬Çë¸÷λ¸ßÊÖ°ïæ½â´ðÏ£¬Ð»Ð»¡£ ´úÂëÈçÏ£º VB code: Private Function getFile_CMD(filename, filepath) As Bo ......
vbÊDz»ÊǺÜÅ£°¡ ÔõôÄÇô¶àµÄ²¡¶¾¶¼ÊÇvb×öµÄ°¡ c#Ðв»ÐУ¿ c#ÔÚXPÔËÐв»ÁË£¬³ý·ÇÈñðÈËÏÈ×°ÉÏ.net. VBÏà¶ÔÓÚC,C++,ASMµÈµÈ£¬¾ÖÏÞÐÔ´ó¶àÁË¡£ ±ðÔÙ˵ʲôÓïÑÔ²»ÈçʲôÓïÑԵϰÁË£¬Ö»ÓÐÄã²»»áÓûòÓÃ×Ų»Ë³ÊÖµÄÓ ......
DIM ds as new DataSet ÎÒÕâÑùÉùÃ÷ ÔõÀÏÊDZ¨ Óû§¶¨ÒåÀàÐÍ䶨Ò壿 Õâ¸öÐèÒªÒýÓÃʲôÂ𣿣¿ ǰÌáÊÇDataSet¶ÔÏóÒª´æÔÚ,¾ÍÊǶÔÏóä¯ÀÀÆ÷ÖÐÓÐËü.ûÓоÍÒªÒýÓÃ. datasetÊÇADO.NET¶ÔÏó Èç¹ûÄãÓõÄÊÇvb.net£¬ÄÇôÔÚ´ ......
ÎÒÏë°ÑwordÁí´æÎªxmlÖ®ºó£¬ÓÃvb¶ÁÈ¡Õâ¸öxmlµÄÄÚÈÝ£¬ÇëÎÊÈçºÎʵÏÖ£¿ dim f as integer dim b() as byte dim s as string dim L as long f=freefile() open "abc.xml" for binary access read as #f ......
vbÖÐ ÏÖÔÚÎÒÒª°ÑÊý¾Ý¿âÀï´æ´¢µÄÒ»¸ö¸½¼þµÄÄÚÈÝÌæ»»ÁË£¬Ôõô×ö£¬Ö»ÊÇÌæ»»ÎÒÖ¸¶¨µÄλÖ㬲»ÊÇÈ«²¿Ìæ»» Ç뽫ÎÊÌâ˵Ã÷°×£¬´æ´¢×ֶθñʽ£¬Èç¹ûÊÇBinary¸ñʽµÄ±È½ÏÂé·³£¬Èç¹ûÊÇ×Ö´®£¬Ö±½ÓÌæ»»¡£×îºÃ²»Òª½øÐÐÖ¸¶¨Î»ÖÃÌæ»»¡ ......