asp.netÖвÙ×÷ExcelÈ«¼¯
Ê×ÏÈÔÚ Web.Config ÖÐÌí¼ÓÄ£ÄâÕʺÅ
<identity impersonate="true" userName="administrator"password="password" />
Æä´Î ÒªÌí¼Ó EXCEL com ×é¼þ¡£Èç¹ûÊÇEXCEL2003,ÔòÌí¼Ó EXcel library 11.0 °æ±¾¡£ÎÒ°ÑÓõ½µÄÒýÓÃÍ·ÎļþÁоÙÈçÏ£º
private Excel.Application objApp;
private Excel.Sheets objSheets;
private Excel._Worksheet objSheet;
private Excel.Range range;
objApp = new Excel.Application();
objSheet = (Excel._Worksheet)objSheets.get_Item(1);
ÎÒ½Ó×Å°Ñ´ó¼Ò±à³ÌÖÐÓõ½µÄº¯ÊýÁоÙÈçÏ£º
using System;
using System.IO;
using System.Text;
using System.Data;
using System.Reflection;
using System.Diagnostics;
using System.Collections;
namespace TEST.EXCEL
{
/// <summary>
/// ˵ Ã÷£ºExcelÊä³ö´òÓ¡Ä£¿é
/// ÔÝʱ²»Ìṩ²Ù×÷Excel¶ÔÏóÑùʽ·½·¨£¬Ñùʽ¿ÉÒÔÔÚExcelÄ£°åÖÐÉèÖúÃ
/// ×÷ Õߣº
/// ´´½¨ÈÕÆÚ£º
/// ÐÞ¡¡¡¡¸Ä£ºSuper
/// </summary>
public class ExcelHelper
{
#region ³ÉÔ±±äÁ¿
private string templetFile = null;
private string outputFile = null;
private object missing = Missing.Value;
private DateTime beforeTime; //ExcelÆô¶¯Ö®Ç°Ê±¼ä
private DateTime afterTime; //ExcelÆô¶¯Ö®ºóʱ¼ä
Excel.Application app;
Excel.Workbook workBook;
Excel.Worksheet workSheet;
Excel.Range range;
Excel.Range range1;
Excel.Range range2;
Excel.TextBox textBox;
private int sheetCount = 1; //WorkSheetÊýÁ¿
private string sheetPrefixName =
Ïà¹ØÎĵµ£º
ÔÚWeb±à³Ì¹ý³ÌÖУ¬´æÔÚןܶలȫÒþ»¼¡£±ÈÈçÔÚÒÔÇ°µÄASP°æ±¾ÖУ¬CookieΪ·ÃÎÊÕߺͱà³ÌÕ߶¼ÌṩÁË·½±ã£¬²¢Ã»ÓÐÌṩ¼ÓÃܵŦÄÜ¡£´ò¿ªIEä¯ÀÀÆ÷£¬Ñ¡Ôñ“¹¤¾ß”²Ëµ¥ÀïµÄ“InternetÑ¡Ï¬È»ºóÔÚµ¯³öµÄ¶Ô»°¿òÀïµ¥»÷“ÉèÖÔ°´Å¥£¬Ñ¡Ôñ“²é¿´Îļþ”°´Å¥£¬ÔÚµ¯³öµÄ´°¿ÚÖУ¬¾Í»áÏÔʾӲÅÌÀï ......
×òÌì¾ÍÒµ²¿Ò»ÃÀÅ®ÀÏʦÔÚQQÉÏ´þµ½ÎÒ£¬ÎÊÎÒÊDz»ÊÇ×ö¹ýVBScript£¬²¢²»ÓÉ·Ö˵°ÑÎÒQQ¸æËßÁËÒ»¸öÔÚÍâµØ¹¤×÷µÄѧÉú£¬ÈÃËýÀ´×ÉѯÎÒ£¬Ã»°ì·¨ÁË£¬Ó²×ÅͷƤÕÒÕÒ½â¾ö·½·¨¡£
ÔÀ´ÕâλÈí¼þ¹¤³ÌʦËùÔÚµÄÏîÄ¿×éÒª×öÒ»¸ö“¸ú΢Èí²î²»¶àµÄÔ¶³ÌWeb½çÃæÁ¬½Ó”£¬´ó¸ÅÏîÄ¿¾ÀíÊÇÕâô°²Åŵģº“Ëû˵ÓÃJavascriptʵÏֵŦÄÜûÓÐÄÇô ......
Ê×ÏÈ¿´ÏÂXML½á¹¹
<?xml version="1.0" encoding="utf-8"?>
<corplist>
<corp>
<linkname>³ÂÏÈÉú</linkname>
<corpname>XXXXXXXXX¹«Ë¾</corpname>
<email>xxxxx@126.com</email>
</corp>
<corp>
<linknam ......
ASP.NET½«WebÕ¾µãϵľø¶Ô·¾¶×ª»»ÎªÐéÄâ·¾¶
2009-11-25 10:39
ºÜ¾³£Ê¹Óõ½µÄÒ»¸ö¹¦ÄÜ,µ«ÔÚÔÚÍøÉÏȴһֱûÓÐÕÒµ½Ïà¹ØµÄ½â¾ö·½·¨,½ñÌì½è×ÅÏîÄ¿Ó¦Óõ½µÄ»ú»áдÁËÁ½¸ö½«¾ø¶Ô·¾¶×ª»»ÎªÐéÄâ·¾¶·â×°ºÃµÄ·½·¨
¡¡¡¡½«WebÕ¾µãϵľø¶Ô·¾¶×ª»»ÎªÏà¶ÔÓÚÖ¸¶¨Ò³ÃæµÄÐéÄâ·¾¶
¡¡¡¡/**//// <summary>
¡¡¡¡/// ½«WebÕ¾µãϵ ......
ASP.NET MVCµÄ1.0·¢ÐÐ˵Ã÷
×îÐÂÏûÏ¢
ASP.NET MVCµÄ1.0ÊÇASP.NET MVC¿ò¼ÜµÄµÚÒ»¸öÕýʽ°æ±¾µÄÖ§³Ö¡£ÓëÍù³£Ò»Ñù£¬ËæʱÌṩÓйØASP.NET MVCµÄÂÛ̳·´À¡¡£
×¢Ò⣺ÔÚÔËÐеÄASP.NET MVC 1.0°²×°³ÌÐò£¬Ð¶ÔØÈκÎÔçÆÚÔ¤ASP.NET MVCµÄ·¢Ðа汾¡£´ËÍ⣬¹Ø±ÕVisual Studio 2008µÄËùÓÐʵÀý¡£
Îĵµ
ASP.NET MVCÖеÄÎļþ¿ÉÔÚMSD ......