asp.netÖвÙ×÷ExcelÈ«¼¯[1]
Ê×ÏÈÔÚ 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; //Wor
Ïà¹ØÎĵµ£º
Ê×ÏÈ¿´ÏÂXML½á¹¹
<?xml version="1.0" encoding="utf-8"?>
<corplist>
<corp>
<linkname>³ÂÏÈÉú</linkname>
<corpname>XXXXXXXXX¹«Ë¾</corpname>
<email>xxxxx@126.com</email>
</corp>
<corp>
<linknam ......
1. ASP.NetÊÇʲô£¿
ASP.NetÊǽ¨Á¢ÔÚ΢ÈíÐÂÒ»´ú.Netƽ̨¼Ü¹¹ÉÏ£¬ÀûÓÃÆÕͨÓïÑÔÔËÐÐʱ£¨Common Language Runtime£©ÔÚ
·þÎñÆ÷ºó¶ËΪÓû§Ìṩ½¨Á¢Ç¿´óµÄÆóÒµ¼¶WebÓ¦Ó÷þÎñµÄ±à³Ì¿ò¼Ü¡£
2£®ASP.NetÓëASPµÄÁªÏµºÍÖ÷񻂿±ðÊÇʲô£¿
&n ......
ÔÚÕâÀïÎÒÃǽ«½²ÊöASP.NET Routing¶ÔÇëÇóµÄ²»Í¬´¦Àí¡£ÎÄÕ½«´Ó´¦Àí»úÖÆ·½Ã濪ʼ½²Æð£¬È»ºó½²Êö¼àÌýµÄ¹ý³Ì¡£Ï£Íû±¾ÎÄÄܶԴó¼ÒÓÐËù°ïÖú¡£
ASP.NET RoutingÊÇÒ»¸öͨÓõÄ×é¼þ£¬Ëü²»Éæ¼°µ½ÈκξßÌåµÄÇëÇó´¦Àí·½Ê½¡£Èç¹ûÄúÐèÒª£¬Ò²¿ÉÒÔ×Ô¼º»ùÓÚËü½øÐпª·¢——ÈçFubuMvcÏîÄ¿¾ÍÊÇÕâô×öµÄ¡£
Ê×ÏÈ£¬Èç¹ûÄúÐèÒªÔÚÏîÄ ......
ÖÚËùÖÜÖªASP.NET 2.0Àï¶Ô±¾µØ»¯£¨Localization£©×öÁ˺ܶ๤×÷£¬´ó´ó¼ò»¯ÁË¿ª·¢¹ý³Ì¡£½ñÌìÖÕÓÚÄܳé³öʱ¼äÑо¿Ò»ÏÂÕâ¸ö¼¼ÊõÁË£¬×ÊÁϺܶ࣬µ«´ó¶à´ø×ÅÒ»¹ÉÒ§ÎĽÀ×ֵķÒëζµÀ£¬So......×Ô¼ºÐ´Ò»Æª¡£
1.ʹÓù¤¾ß×Ô¶¯Éú³É±¾µØ»¯×ÊÔ´£¨LocalResources£©
2.ÔÀ´Localizable AttributePropertyÊÇÕâô»ØÊÂѽ
3.ÊÖ¹¤Ìí¼Ó±¾µ ......