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

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


Ïà¹ØÎĵµ£º

asp.net ¶ÔXML ¶Áд²é²Ù×÷

  Ê×ÏÈ¿´ÏÂ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


      Êý¾ÝÔ´¿Ø¼þÌṩ¶àÖÖÊý¾Ý·þÎñ£¬ÕâÑù½«¸ß¼¶¹¦ÄÜÌí¼Óµ½Ó¦ÓóÌÐò»á±äµÃ¸ü¼ÓÈÝÒס£Õâ°üÀ¨¸ù¾ÝÖ¸¶¨µÄËÑË÷Ìõ¼þɸѡÊý¾Ý¡£É¸Ñ¡¶ÔÓÚʹÓûº´æÊý¾ÝÓÈÆä·½±ã£¬ÒòΪÄúÎÞÐèÖØÐÂÔËÐвéѯ»òµ÷ÓöÁÈ¡Êý¾ÝµÄ·½·¨¾Í¿ÉÒÔÌṩËÑË÷¹¦ÄÜ¡£
      ÈôҪɸѡÊý¾Ý£¬±ØÐë°´ÏÂÁз½Ê½ÅäÖÃÊý¾Ý ......

Asp.NetµÄÃæÊÔÌâ

 1. Ìî¿Õ:
(1)ÃæÏò¶ÔÏóµÄÓïÑÔ¾ßÓÐ________ÐÔ¡¢_________ÐÔ¡¢________ÐÔ¡£
(2)ÄÜÓÃforeach±éÀú·ÃÎʵĶÔÏóÐèҪʵÏÖ ________________½Ó¿Ú»òÉùÃ÷________________·½·¨µÄÀàÐÍ¡£
(3)ÁоÙADO.netÖеÄÎå¸öÖ÷Òª¶ÔÏó_______________¡¢_____________¡¢_______________¡¢_______________¡¢_________________¡£
2. ²»¶¨ÏîÑ¡Ôñ£ ......

ASP.NET 2.0 ±¾µØ»¯2

ÔÚASP.NET 2.0 ±¾µØ»¯¼¼ÊõÖ®Ñо¿µÄ»Ø¸´ÖÐÌáµ½ÁËÒÔÏÂÁ½µã£º
1.ÕâÖ»Êǵ¥¸öÒ³ÃæµÄÇл»£¬ÈçºÎ×öÕû¸öÕ¾µãµÄÇл»ÄØ£¿£¨ hjh £©
2.¹ØÓÚÈçºÎ½«×ÊÔ´Ö±½ÓÏÔʾ……¼ÈÈ»¿Ø¼þÄܹ»½«Ç¶ÈëdllµÄ×ÊÔ´Ö±½ÓÏÔʾ£¬²»ÖªµÀÍøÕ¾ÄÜ·ñÒ²½«Ç¶Èë×ÊÔ´Ö±½Óµ÷ÓÃWebResourceÏÔÊ¾ÄØ£¿£¨Cat Chen £©
ÓÉÓÚ²»ÊÇÒ»Á½¾ä¿ÉÒÔ˵Ç壬ËùÒÔÔÙ¿ªÒ»Æª×Ðϸ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ