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

asp.netÖÐ ÈçºÎ´ò¿ª¸Õ´¦Àí¹ýµÄExcelÎļþ ¼±!!!!

string sTemplate = Server.MapPath(Request.ApplicationPath) + "\\Template\\Service.xls"; 
object missing = System.Reflection.Missing.Value;
Application excel = new Application();
Workbooks books = excel.Workbooks;
_Workbook book = books.Open(sTemplate, Type.Missing, Type.Missing, Type.Missing, Type.Missing,Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

            Sheets sheets = book.Worksheets;
            _Worksheet sheet = sheets.get_Item(1) as Worksheet;
            Range range = sheet.get_Range("B3", missing);
            range.set_Value(missing, cust.Cust_name);

  µ½ÕâÀïÎÒÒѾ­´¦ÀíºÃµÄÏÖÓеÄExcelÄ£°å£¬½ÓÏÂÀ´¾ÍÊÇÒª´ò¿ª¸Õ´¦ÀíºÃµÄExcelÄ£°å¡£
//ÎÒÓÃÏÂÃæÕâ¸ö·½·¨´ò¿ª²»ÐУ¬µÚÒ»¸ö²ÎÊý²»ÖªµÀÌîʲô£¿ÎÒÊÔÁËÏÂÄ£°åµÄ·¾¶±¨´íµÄ¡£ ÇëÄÄλ°ïÎÒÏëÏë°ì·¨£¬»¹ÓÐʲôÆäËû·½·¨´ò¿ªÂ𣿠ÎÒÒª´ò¿ªºó´òÓ¡µÄ¡£
  book.OpenLinks(, true, XlLink.xlExcelLinks);
Ä£°å²»Ò²ÒѾ­´ò¿ª²¢Ð´ÈëÖµÁËÂð£¿ÎªÊ²Ã´ÒªÔÙ´ò¿ª£¿

²»ÓÃÔÙ´ò¿ªÁË£¬Ö±½Óµ÷ÓôòÓ¡·½·¨¾Í¿ÉÒÔÁË¡£

ÎÒÊÇÒªµ÷ÓÃExcelµÄ´òÓ¡£¬ÄÇÎÒ´úÂëÔõôд°¡¡£ÕÒ²»µ½ÊÇÄǸö¶ÔÏóµÄ´òÓ¡µÄ·½·¨

PrintPreview ´òÓ¡Ô¤ÀÀ
PrintOut ´òÓ¡

Workbook¡¢Worksheet¡¢NamedRange ¶¼ÓÐÒÔÉÏÁ½¸ö·½·¨¡£
{{----


Ïà¹ØÎÊ´ð£º

asp.net·ÖÒ³ÎÊÌâ

select top 12 * from Product where [id] not in (select top 12 [id] from Product)
ÕâÑù¿ÉÒÔ·ÖÒ³£¬µ«ÊÇÎÒÔÚºóÃæÏë¼Ó¸öÌõ¼þ
select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......

asp.net³ÌÐòÔ±ÇóÖ° - .NET¼¼Êõ / ·Ç¼¼ÊõÇø

±¾È˹¤×÷¾­ÑéÒ»ÄêÒÔÉÏ
ÊìϤasp.net
ÊìϤjavascript
ÊìϤCss
ÊìϤajax
ÊìϤsqlserver2005
ÓÐÒ»ÄêµÄÏîÄ¿¾­Ñé
¾ßÌåÏîÄ¿ºÍÆäËûµÄ¾Í²»ÔÚÕâдÁË
ÓÐÒâÕßÁªÏµ£º
QQ:359233910
ÒýÓÃ
±¾È˹¤×÷¾­ÑéÒ»ÄêÒÔÉÏ
ÊìϤasp ......

ÇóÖú£ºÕÒASP.NETÍøÒ³ÖÆ×÷¸ßÊÖ£¬Óб¨³ê¡£

±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»Æ­ÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......

winform±à³ÌÓëASP.NETÓÐÁ¬ÏµÂð - .NET¼¼Êõ / C#

ÆäʵÕâ¸öÎÊÌâ¿ÉÒÔÕÒÀÏʦ»Ø´ð£¬Õâ²»·Å¼ÙÁËÂð£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
¾ø¶ÔÓÐ £¬ASP¡¢netÀïÓкöàµÄÂß¼­Åжϵȶ¼ÐèÒªwinform»ù´¡

C#ÓïÑÔ 
Ado.net C/S½á¹¹
Asp.net B/S½á¹¹

Á©¶¼ÊÇ΢Èí³öµÄ£¬¶¼ÄÜÓÃC#½øÐпª·¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ