ÇóÒ»¸öÓÃaspÔÚwin2003Öн«Accessµ¹³öµ½ExcelµÄÀý×Ó
±¾À´ÔÚ×Ô¼ºµÄXPϵͳ»ú×ÓÉÏдµÄ³ÌÐò£¬Ò»µãÎÊÌâûÓУ¬µ«Ò»×ªµ½·þÎñÆ÷ÉÏ(Windows2003ϵͳ)¾Í³öÏÖЩĪÃûÆäÃîµÄÎÊÌ⣬¿ªÊ¼ÊÇCreateObject("Excel.Application")²»ÄÜ´´½¨¶ÔÏ󣬲éÁ˰ëÌ죬°ÑDCOMʲôµÄ×é¼þµÄȨÏÞ¶¼ÉèÖúÃÁË£¬¶ÔÏóÄÜ´´½¨ÁË£¬Êý¾ÝÄܵ¹³öÀ´£¬XLSÎļþÒ²ÄÜÉú³É£¬µ«µ¹³öÎļþÒ»Ö±´¦ÓÚÕýÔÚ´ò¿ªµÄ״ֱ̬µ½Timeout£¬¶øÇÒÈÎÎñ¹ÜÀíÆ÷ÖÐÿµ¹Ò»´Î¾Í¶à³öÒ»¸öExcel.exe½ø³ÌºÍDW20.exe½ø³Ì£¬²»ÖªµÀÔõô»ØÊÕ¡£¡£¡£Ö»ÄÜÊÖ¶¯È¥É±µô ÄÄλ´ó¸çÄܸøÒ»¸öÄÜÔÚwindows2003Ͻ«Accessµ¹³öµ½ExcelµÄasp³ÌÐòÀý×Ó£¿ ÄÜÓõÄСµÜÁí¿ªÌùËÍ·Ö¡£¡£¡£¡£
²»Êǽ«±í¸ñµÄÊý¾Ýµ¹µ½Excel£¬Êǽ«AccessµÄÊý¾Ýµ¹µ½Excel£¬ÒªÏÈ·ÃÎÊÊý¾Ý¿â£¬¶Á³öÊý¾Ýºóд½øExcel ¡£¡£¡£ÒýÓà ²»Êǽ«±í¸ñµÄÊý¾Ýµ¹µ½Excel£¬Êǽ«AccessµÄÊý¾Ýµ¹µ½Excel£¬ÒªÏÈ·ÃÎÊÊý¾Ý¿â£¬¶Á³öÊý¾Ýºóд½øExcel ¡£¡£¡£ Äã°Ñ±í¸ñÀïÃæµÄÊý¾Ý¸Ä³É´ÓÊý¾Ý¿â¶Á³öÀ´µÄ²»¾ÍÐÐÁË <% if request.querystring("action")="toExcel" then Response.ContentType="application/vnd.ms-excel" Response.AddHeader "content-disposition","attachment;filename=aaa.xls" end if %> <html> <body> <table name="data" id="data" width="100%" height="25%" border="0" cellpadding="1" cellspacing="1"> <tr> <td width="50%" align="
Ïà¹ØÎÊ´ð£º
owc11Âú×ã²»ÁËÒªÇó£¬ÓÐûÓиüºÃµãµÄ£¬aspÄܵ÷ÓÃµÄ Ä¿Ç°Ã»·¢ÏÖ£¬°ïÄã¶¥£¡ Ó¦¸ÃûÓÐÁ衃 ×ÔÒÑд¡£¶¥ °ï¶¥£¬¹Ø×¢£¡ ºÃÏñ¾ÍÕâ¸öÁË£¬Ä¿Ç°»¹Ã»¿´µ½ÆäËûµÃÉÏÊÐʹÓᣡ£¡£°ï¶¥£¡ ×Ô¼ºÔÙ¶¥Ò»Ï ºÃÏñÊÇûÓÐ ......
ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡ ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë XML code: <?xml version="1.0" encoding="utf-8"? ......
ÇëÎÊ£Á£Ó£Ð³ÌÐòԱתÀ´×ö¡¡£Ð£È£Ð¡¡£¬ÈçºÎʵÏÖ£¿ ûÓÐÈκΣУȣпª·¢¾Ñ飬ֻÊÇ×Ô¼ºÑ§Ï°£¬ ÇëÎÊÈçºÎת£¿£¿ ¶«Î÷»¹ÊÇÄÇЩ¶«Î÷£¬Ë¼Â·»¹ÊÇÄÇЩ˼·£¬Ö»ÊÇ»»Á˸öapi¶øÒÑ£¬ºÜÈÝÒ׸㶨µÄ ÄѵÄÊÇÏë·¨ÊÇ˼ ......
ÎÒÖ÷ÒªÏë¿ØÖÆÏÂword±£´æµÄµØÖ·£¬µ«ÊDZàÒë²»¹ýÈ¥£¬×ܾõµÃÊÇȱÁËusing¡£¡£¡£ лл ´úÂëÈçÏ£º using System; using System.IO; using System.Collections; using System.ComponentModel; using System.Data; u ......