asp.netתÒëExcelµÄÎÊÌ⣿ - .NET¼¼Êõ / ASP.NET
ÏÖÔÚÎÊÌâÊÇÎÒµ¼³öµÄÕýÈ·¡£µ«ÏÔʾµÄʱºòÓеãÎÊÌâ¡£ Êý¾Ý¿âÖбàºÅΪ£º430221199001200000 ExcelÏÔʾΪ:4.30221E+17 ÈçºÎÈñàºÅÔÚExcelÖÐÏÔʾΪ 430221199001200000
Çó¾È¡£¡¢¡£ÖªµÀµÄ˵»°~£¡£¡£¡£¡ C# code: XXX.Attributes.Add("style", "vnd.ms-excel.numberformat: @;"); ÕâÑù»áÒÔ×Ö·û´®¸ñʽÊä³ö£¬Ò»¶¨Äܱ£³ÖÔÑù ÊÖ¶¯¶¥Æð£¡· ÎÒÊÇÕâÑùдµÄ¡£¡£×Ö·û´®Ã»ÓÐAttributes tablexml+=@"<td>"+dt.Rows[i][CellsNames[a].ToString()]+"</td>" ÄÇÏÖÔÚ¸ÃÔõô°ìÒýÓà ÎÒÊÇÕâÑùдµÄ¡£¡£×Ö·û´®Ã»ÓÐAttributes tablexml+=@"<td>"+dt.Rows[i][CellsNames[a].ToString()]+"</td>" ÄÇÏÖÔÚ¸ÃÔõô°ì ÎÒÓõÄÊÇGridviewµ¼³ö£¬È¡ÄǸöcellÔö¼ÓÊôÐÔ£¬ÄãÓõÄxmlÎҾͲ»ÖªµÀÁË àÅ¡£¡£ лÁËàÞ ÖªµÀµÄ¡£¡£ËٶȽøÀ´°ï棡£¡£¡£¡£¡£¡£¡ excelʹÓÃ×Ö·û´®¸ñʽÒýÓà excelʹÓÃ×Ö·û´®¸ñʽ ʲôÒâ˼¡£¡£Äܲ»ÄܰѴúÂëÌù³öÀ´¡£ ÔÚÍøÉÏûÕÒµ½¡£¡£ C# code: //ExcelÏÔʾʱ»á°Ñ±àºÅ£º430221199001200000 ÏÔʾΪ:4.30221E+17 //ÇëÎÊÈçºÎ½â¾ö!!!!!! //tablexml¾ÍÊÇÒ»¸ö<table>&
Ïà¹ØÎÊ´ð£º
http://www.zgjhjy.com/Test/PrimaryTest/Index.aspx ¾ÍÊÇÀàËÆÒÔÉϵÄÔÚÏß²âÊÔϵͳ£¬ÐèÒªÓÐÒ»¸öºǫ́µÄ£¬ÓïÑÔÊÇaspµÄ£¬Êý¾Ý¿âÊÇaccessµÄ£¬»¹ÐèÒªÄÜÔÚºǫ́¶ÔÐÅÏ¢½øÐÐÌíɾ¸Ä²éµÄ¡£Ð»Ð»¸÷λÁË¡£¡£¡£ ³ÌÐòÕæµÄºÜ¶à£¬²»Öª ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼: Àý£º
......
C# code: SqlConnection conn = CsDB.sqlcon(); SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
ĿǰÊÇA.aspÃæÒ³ÓÐÒ»¸ö±äÁ¿aa,Ôõô²Å¿ÉÒÔ´«µ½B.aspÒ³Ãæ,²»ÊÇÓÃURL´«,ÏëÓÃ<inupt >¿Ø¼þÔõô´«°¡!Çë´ó¼ÒÖ¸µã! ÓÃ±íµ¥´«Öµ ´«Öµ£¬GETºÍPOST£¬ÒªÃ´´ø²ÎÊý£¬ÒªÃ´ÓÃform ¶øÇÒ£¬Èç¹ûÄãÁ½¸öÒ³ÃæÃ»ÓÐÈκιØÁª£¬´«Ö ......
ÏÖÓÐÒ»¸ö±í¸ñ£¬ÓкܶàÐÐÊý×é¡£ ÏëÒªÒ»¸ö½Å±¾£¬¶ÁÈ¡ËùÓÐÐеÄÊý×éºóÊä³ö¡£ Êä³öǰ²»ÏÔʾÕý³£Ë³ÐòµÄ±í¸ñÊý×飬¶øÖ±½ÓÏÔʾ³ö¶ÁÈ¡ºóµÄÊý×é¡£ Â¥Ö÷µÄ±í´ïʵÔÚ³ÉÎÊÌ⣡£¡ ÊDz»ÊÇÕâ¸öÒâ˼£¿ <% Dim ArrDNA£¨10£¬10£ ......