Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔõÑù ͨ¹ý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ÖÐʹÓÃWScriptµ÷ÓÃÍⲿÃüÁî - VB / »ù´¡Àà

ÔÚÏÂÊÇvbµÄÐÂÊÖ£¬Ïëд¶Î³ÌÐò£¬ÔÚvbÖУ¬Ê¹ÓÃwscriptµ÷ÓÃһЩÍⲿµÄÃüÁµ«ÊdzÌÐòÖ´ÐÐÒ»Ö±ÓдíÎó£¬Çë¸÷λ¸ßÊÖ°ïæ½â´ðÏ£¬Ð»Ð»¡£
´úÂëÈçÏ£º
VB code:

Private Function getFile_CMD(filename, filepath) As Bo ......

vb Å£Âð - Web ¿ª·¢ / vbScript

vbÊDz»ÊǺÜÅ£°¡ ÔõôÄÇô¶àµÄ²¡¶¾¶¼ÊÇvb×öµÄ°¡ c#Ðв»ÐУ¿
c#ÔÚXPÔËÐв»ÁË£¬³ý·ÇÈñðÈËÏÈ×°ÉÏ.net.
VBÏà¶ÔÓÚC,C++,ASMµÈµÈ£¬¾ÖÏÞÐÔ´ó¶àÁË¡£

±ðÔÙ˵ʲôÓïÑÔ²»ÈçʲôÓïÑԵϰÁË£¬Ö»ÓÐÄã²»»áÓûòÓÃ×Ų»Ë³ÊÖµÄÓ ......

¹ØÓÚVB DIM ds as new DataSetÎÊÌâ - VB / »ù´¡Àà

DIM ds as new DataSet
ÎÒÕâÑùÉùÃ÷ ÔõÀÏÊDZ¨ Óû§¶¨ÒåÀàÐÍ䶨Ò壿 Õâ¸öÐèÒªÒýÓÃʲôÂ𣿣¿
ǰÌáÊÇDataSet¶ÔÏóÒª´æÔÚ,¾ÍÊǶÔÏóä¯ÀÀÆ÷ÖÐÓÐËü.ûÓоÍÒªÒýÓÃ.

datasetÊÇADO.NET¶ÔÏó
Èç¹ûÄãÓõÄÊÇvb.net£¬ÄÇôÔÚ´ ......

vb - VB / »ù´¡Àà

ÎÒÏë°Ñ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 - VB / »ù´¡Àà

vbÖÐ ÏÖÔÚÎÒÒª°ÑÊý¾Ý¿âÀï´æ´¢µÄÒ»¸ö¸½¼þµÄÄÚÈÝÌæ»»ÁË£¬Ôõô×ö£¬Ö»ÊÇÌæ»»ÎÒÖ¸¶¨µÄλÖ㬲»ÊÇÈ«²¿Ìæ»»
Ç뽫ÎÊÌâ˵Ã÷°×£¬´æ´¢×ֶθñʽ£¬Èç¹ûÊÇBinary¸ñʽµÄ±È½ÏÂé·³£¬Èç¹ûÊÇ×Ö´®£¬Ö±½ÓÌæ»»¡£×îºÃ²»Òª½øÐÐÖ¸¶¨Î»ÖÃÌæ»»¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ