VB Formatº¯Êý
Format[$] ( expr [ , fmt ] )
format ·µ»Ø±äÌåÐÍ
format$ Ç¿ÖÆ·µ»ØÎªÎı¾
--------------------------------
Êý×ÖÀàÐ͵ĸñʽ»¯
--------------------------------
¹Ì¶¨¸ñʽ²ÎÊý£º
General Number ÆÕͨÊý×Ö£¬Èç¿ÉÒÔÓÃÀ´È¥µôǧλ·Ö¸ôºÅ
format$("100,123.12","General Number") ·µ»ØÖµ 100123.12
Currency »õ±ÒÀàÐÍ£¬¿ÉÌí¼Óǧλ·Ö¸ôºÅºÍ»õ±Ò·ûºÅ
format$("100123.12","Currency") ·µ»ØÖµ £¤100,123.12
Fixed ¸ñʽΪ´øÁ½Î»Ð¡ÊýµÄÊý×Ö
format$("100123","Fixed") ·µ»ØÖµ 100123.00
Standard ±ê×¼£¬¼´´øÇ§Î»·Ö¸ôºÅºÍÁ½Î»Ð¡Êý
format$("100123","Standard") ·µ»ØÖµ 100,123.00
Percent °Ù·ÖÊý
format$("100123","Percent") ·µ»ØÖµ 10012300.00%
Scientific ¿ÆÑ§¼ÇÊý·¨
format$("100123","Scientific") ·µ»ØÖµ 1.00E+05
Yes/No µ±ÖµÎª0ʱ·µ»Ø NO,·ñÔò·µ»Ø YES
format$("100123","Yes/No") ·µ»ØÖµ Yes
True/False µ±ÖµÎª0ʱ·µ»Ø False,·ñÔò·µ»Ø True
format$("100123","True/False") ·µ»ØÖµ True
On/Off µ±ÖµÎª0ʱ·µ»Ø Off,·ñÔò·µ»Ø On
format$("100123","Yes/No") ·µ»ØÖµ On
×Ô¶¨Òå¸ñʽ²ÎÊý
"" ²»½øÐиñʽ»¯ ·µ»ØÖµ ÔÖµ
0 ռλ¸ñʽ»¯£¬²»×ã²¹0
format$("100123","0000000") ·µ»ØÖµ 0100123
# ռλ¸ñʽ»¯£¬²»×ãʱ²»²¹0
format$("100123
Ïà¹ØÎĵµ£º
App ¶ÔÏóÊÇVBÓ¦ÓóÌÐòµÄÈ«¾ÖÐÅÏ¢£¬ÈçÓ¦ÓóÌÐòµÄ±êÌâ¡¢°æ±¾ÐÅÏ¢¡¢¿ÉÖ´ÐÐÎļþºÍ°ïÖúÎļþµÄ·¾¶¼°Ãû³ÆÒÔ¼°ÊÇ·ñÔËÐÐǰһ¸öÓ¦ÓóÌÐòµÄʾÀý¡£
ÊôÐÔ
£££££££ ÆäËûÊôÐÔ£££££££££££££££££
EXEName ÊôÐÔ ·µ»Øµ±Ç°ÕýÔËÐеĿÉÖ´ÐÐÎļþ ......
·¢ËͶËÒÔ163ΪÀý
Ò»¡¢asp.net°æ using System.Web.Mail; //ÃüÃû¿Õ¼äÒýÓÃ
c#
MailMessage mail = new MailMessage();
mail.To = "shadow103@qq.com"; //½ÓÊÜÈ˵ÄÓÊÏä
& ......
È«Ãæ¿ØÖÆ Excel
Ê×ÏÈ´´½¨ Excel ¶ÔÏó£¬Ê¹ÓÃComObj:
Dim ExcelID as Excel.Application
Set ExcelID as new Excel.Application
1) ÏÔʾµ±Ç°´°¿Ú£º
ExcelID.Visible := True;
2) ¸ü¸Ä Excel ±êÌâÀ¸£º
ExcelID.Caption := 'Ó¦ÓóÌÐòµ÷Óà Microsoft Excel';
3) Ìí¼Óй¤×÷²¾£º
ExcelID.WorkBooks.Add;
4) ´ò¿ªÒÑ´æÔÚµ ......
×ö±ÏÒµÂÛÎĵÄʱºòÓöµ½µÄÒ»¸öÎÊÌ⣬Çë½Ì¶¹°êÉϵÄÍøÓѲÅÓÐÁ˴𰸡£Ð»Ð»Õâλ½Ð“Òì²Ê”µÄÅóÓÑ¡£ÄóöÀ´Óë´ó¼Ò·ÖÏí¡£
¡¡¡¡ÓÃVB×öͼÏñ´¦ÀíÈí¼þµÄ±ÏÒµÂÛÎÄ£¬Óöµ½Ò»¸öÎÊÌâ¡£¼ÓÔØÒ»·ùͼƬ£¬Óöà¸öÂ˾µ·Ö±ð´¦Àí£¬ÏëÒ»²½Ò»²½UNDOµ½×îÔʼµÄͼÏñ£¬¶à´ÎUNDOÔõôʵÏÖ?
²Î¿¼·½°¸£º
Èç¹ûÏë×öµ½¶à´ÎUND ......