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
Ïà¹ØÎĵµ£º
¾¹ýÒ»Íí°ë¿àÕ½£¬ÖÕÓÚ½«Discuz NTÓëij¹«Ë¾ÍøÕ¾ÕûºÏÆðÀ´ÁË£¬Æð³õ»¹Óöµ½²»Ð¡ÎÊÌ⣬ºÜ¶à¶¼²»Ã÷°×¡£
½«ÔÚ¸ùij¹«Ë¾ÍøÕ¾¸ùĿ¼ÉϽ¨Ò»¸öBBSÎļþ¼Ð£¬°ÑDiscuz NTµÄÎļþ¶¼·Å½øÀïÃæ¡£
ÔÙ½«DNT.configÎļþ£¬configÎļþ¼Ð£¬aspnet_clientÎļþ¼Ð£¬BinÎļþ¼ÐµÄÄÚÈÝCopyµ½¸ùĿ¼ÖУ¬½«DiscuzNTµÄWeb.ConfigÎļþÓëij¹«Ë¾ÍøÕ¾µÄWeb.ConfigÎ ......
ÍòÊ¿ªÍ·ÄÑ
ÕÒÁ˺ܶàAPS.NETµÄÊ飬ÒÔ¼°ÌýÀÏʦ½²µÄÖÆ×÷Á÷³Ì£¬»òÕßÔÚMSDNÀïÕÒµ½µÄ×ÊÁÏ£¬
´ó¸ÅÒòΪ±àÒëÆ÷µÄÔÒò£¬¶¼²»Ì«Ïàͬ£¬µ¼ÖÂ×Ô¼º°´×Ų½ÖèÒ²×ö²»¶Ô
½ñÌìÖÕÓÚÖªµÀÕý¹æµÄ×ö·¨ÁË ¹þ¹þ ¸Ï¿ì¼ÇÏÂÁË~
1.File=¡·Îļþ=¡·Ð½¨=¡·ÍøÕ¾=¡·ASP.NETÍøÕ¾
µã»÷È·ÈϾͿÉÒÔÁË
2.¿ªÊ¼Éè¼ÆÒ³Ãæ
Éè¼ÆÈ«²¿ÊÇÔÚDefault.aspxÀïÃæ
Ë ......
¼ò½é
Microsoft Internet ÐÅÏ¢·þÎñ (IIS) ËùÊÕµ½µÄ¶Ôij Microsoft ASP.NET Ò³ÃæµÄÿ¸öÇëÇó¶¼±»Òƽ»¸ø ASP.NET HTTP ¹ÜÏß¡£HTTP ¹ÜÏßÓÉһϵÁÐÍйܶÔÏó×é³É£¬ÕâЩ¶ÔÏó°´Ë³Ðò´¦Àí¸ÃÇëÇ󣬲¢Íê³É´Ó URL µ½ÆÕͨ HTML Îı¾µÄת»»¡£HTTP ¹ÜÏßµÄÈë¿ÚµãÊÇ HttpRuntime Àà¡£ASP.NET »ù´¡½á¹¹Îª¸¨Öú½ø³ÌÖÐËù³ÐÔØµÄÿ¸ö AppDomain ´´½¨ ......
LinqDataSource ¿Ø¼þͨ¹ý ASP.NET Êý¾ÝÔ´¿Ø¼þ½á¹¹Ïò Web ¿ª·¢ÈËÔ±¹«¿ªÓïÑÔ¼¯³É²éѯ (LINQ)¡£LINQ ÌṩһÖÖÓÃÓÚÔÚ²»Í¬ÀàÐ͵ÄÊý¾ÝÔ´ÖвéѯºÍ¸üÐÂÊý¾ÝµÄͳһ±à³ÌÄ£ÐÍ£¬²¢½«Êý¾Ý¹¦ÄÜÖ±½ÓÀ©Õ¹µ½ C# ºÍ Visual Basic ÓïÑÔÖС£LINQ ͨ¹ý½«ÃæÏò¶ÔÏó±à³ÌµÄ×¼ÔòÓ¦ÓÃÓÚ¹ØÏµÊý¾Ý£¬¼ò»¯ÁËÃæÏò¶ÔÏó±à³ÌÓ ......