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 =
Ïà¹ØÎĵµ£º
×òÌì¾ÍÒµ²¿Ò»ÃÀÅ®ÀÏʦÔÚQQÉÏ´þµ½ÎÒ£¬ÎÊÎÒÊDz»ÊÇ×ö¹ýVBScript£¬²¢²»ÓÉ·Ö˵°ÑÎÒQQ¸æËßÁËÒ»¸öÔÚÍâµØ¹¤×÷µÄѧÉú£¬ÈÃËýÀ´×ÉѯÎÒ£¬Ã»°ì·¨ÁË£¬Ó²×ÅͷƤÕÒÕÒ½â¾ö·½·¨¡£
ÔÀ´ÕâλÈí¼þ¹¤³ÌʦËùÔÚµÄÏîÄ¿×éÒª×öÒ»¸ö“¸ú΢Èí²î²»¶àµÄÔ¶³ÌWeb½çÃæÁ¬½Ó”£¬´ó¸ÅÏîÄ¿¾ÀíÊÇÕâô°²Åŵģº“Ëû˵ÓÃJavascriptʵÏֵŦÄÜûÓÐÄÇô ......
Table Web ·þÎñÆ÷¿Ø¼þʹÄúÄܹ»ÔÚ ASP.NET Ò³ÉÏ´´½¨¿ÉʹÓ÷þÎñÆ÷´úÂë½øÐбà³ÌµÄ±í¡£TableRow ºÍ TableCell Web ·þÎñÆ÷¿Ø¼þÌṩÏÔʾ Table ¿Ø¼þµÄÄÚÈݵķ½·¨¡£
Ò»¡¢±³¾°
ͨ³££¬±í²»½öÓÃÀ´ÏÔʾ±í¸ñÐÅÏ¢£¬Ëü»¹ÊÇÔÚÍøÒ³Éϸñʽ»¯ÐÅÏ¢µÄÒ»ÖÖ·½·¨¡£¿ÉÒÔͨ¹ý¶àÖÖ·½·¨ÔÚ ASP.NET Ò³ÉÏ´´½¨±í£º
& ......
TextBox Web ·þÎñÆ÷¿Ø¼þΪÓû§ÌṩÁËÒ»ÖÖÏò ASP.NET ÍøÒ³ÖмüÈëÐÅÏ¢£¨°üÀ¨Îı¾¡¢Êý×ÖºÍÈÕÆÚ£©µÄ·½·¨¡£
Ò»¡¢±³¾°
TextBox ·þÎñÆ÷¿Ø¼þÊÇÈÃÓû§ÊäÈëÎı¾µÄÊäÈë¿Ø¼þ¡£Ä¬ÈÏÇé¿öÏ£¬¸Ã¿Ø¼þµÄ TextMode ÊôÐÔÉèÖÃΪ TextBoxMode.SingleLine£¬Õ⽫ÏÔʾһ¸öµ¥ÐÐÎı¾¿ò¡£µ«¿ÉÒÔ½« TextMod ......
ÔÚÍøÉÏËѲéÁ˺ܾ㬹ØÓÚasp.netÖжàÐÐÎı¾¿ò¸ß¶È×ÔÊÊÓ¦ÄÚÈݵĽâ¾ö·½·¨
<td style="width:700px" align=center valign=top>
<asp:TextBox runat="server" ID="txtContent" Width=100% ReadOnly=true Wrap=true TextMode="MultiLine" MaxLength="1073741823" BorderWidt ......
ÍòÊ¿ªÍ·ÄÑ
ÕÒÁ˺ܶàAPS.NETµÄÊ飬ÒÔ¼°ÌýÀÏʦ½²µÄÖÆ×÷Á÷³Ì£¬»òÕßÔÚMSDNÀïÕÒµ½µÄ×ÊÁÏ£¬
´ó¸ÅÒòΪ±àÒëÆ÷µÄÔÒò£¬¶¼²»Ì«Ïàͬ£¬µ¼ÖÂ×Ô¼º°´×Ų½ÖèÒ²×ö²»¶Ô
½ñÌìÖÕÓÚÖªµÀÕý¹æµÄ×ö·¨ÁË ¹þ¹þ ¸Ï¿ì¼ÇÏÂÁË~
1.File=¡·Îļþ=¡·Ð½¨=¡·ÍøÕ¾=¡·ASP.NETÍøÕ¾
µã»÷È·ÈϾͿÉÒÔÁË
2.¿ªÊ¼Éè¼ÆÒ³Ãæ
Éè¼ÆÈ«²¿ÊÇÔÚDefault.aspxÀïÃæ
Ë ......