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 ¶¼ÓÐÒÔÉÏÁ½¸ö·½·¨¡£
{{----
Ïà¹ØÎÊ´ð£º
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
ÊìϤjavascript
ÊìϤCss
ÊìϤajax
ÊìϤsqlserver2005
ÓÐÒ»ÄêµÄÏîÄ¿¾Ñé
¾ßÌåÏîÄ¿ºÍÆäËûµÄ¾Í²»ÔÚÕâдÁË
ÓÐÒâÕßÁªÏµ£º
QQ:359233910
ÒýÓÃ
±¾È˹¤×÷¾ÑéÒ»ÄêÒÔÉÏ
ÊìϤasp ......
±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»ÆÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......
ÆäʵÕâ¸öÎÊÌâ¿ÉÒÔÕÒÀÏʦ»Ø´ð£¬Õâ²»·Å¼ÙÁËÂð£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
¾ø¶ÔÓÐ £¬ASP¡¢netÀïÓкöàµÄÂß¼Åжϵȶ¼ÐèÒªwinform»ù´¡
C#ÓïÑÔ
Ado.net C/S½á¹¹
Asp.net B/S½á¹¹
Á©¶¼ÊÇ΢Èí³öµÄ£¬¶¼ÄÜÓÃC#½øÐпª·¢ ......