asp.net¶ÁÈ¡EXcelµÄСÌÖÂÛ
ÔÚCSÎļþÖУ¬Ê×ÏÈÔÚ¶¥²¿ÒýÈë²Ù×÷ExcelÊý¾ÝµÄÃüÃû¿Õ¼ä
using System.Data.OleDb;
Õýʽ´úÂëÈçÏ£º
private void Button_Click(object sender, System.EventArgs e)
{
string thefullname = this.uploadFile.PostedFile.FileName;//»ñÈ¡ÍêÕû·¾¶
ClientScriptManager csm = Page.ClientScript;
if (thefullname == "")
{
csm.RegisterStartupScript(GetType, "Error", "alert('ÇëÑ¡ÔñÒªÉÏ´«µÃExcelÎļþ');", true);
return;
}
int fileLength = this.uploadFile.PostedFile.ContentLength;
if (fileLength > 512000)
{
csm.RegisterStartupScript(GetType, "Error", "alert('ÎļþÒѳ¬¹ý500K£¬ÎÞ·¨ÉÏ´«£¡');", true);
return;
}
FileInfo info = new FileInfo(thefullname);
string fileExt = info.Extension;
if (fileExt.ToLower() != ".xls")
{
csm.RegisterStartupScript(GetType, "Error", "alert('²»ÊÇExcelÎļþ£¬ÇëʹÓÃÕýÈ·µÄÎļþ¸ñʽ£¡');", true);
return;
}
string uploadPath = Page.MapPath(@"uploadfile\report.xls");
 
Ïà¹ØÎĵµ£º
1. ´ò¿ªvs 2008µÄ¹¤¾ß>Ñ¡Ïî>HTMLÉè¼ÆÆ÷ʱÌáʾ:¼ÓÔØ´ËÊôÐÔҳʱ³ö´í
2. ´ò¿ª .aspx ÎļþÊÇ, Ö»ÓÐHTML±à¼ÊÓͼ,ûÓÐÊÓͼÇл»Ñ¡Ïî
ÔÚÃüÁîÐÐÖÐÔËÐУºdevenv /ResetSkipPkgs ¼´¿É½â¾ö¸ÃÎÊÌâ.
http://www.cnblogs.com/S.Sams/archive/2009/06/06/1414500.html ......
ÏÂÃæÊÇÓÃÀ´²âÊÔÑéÖ¤ÂëµÄǰ̨ÏÔʾ´úÂ룺ÆäÖнű¾º¯ÊýchangeµÄ×÷ÓÃÊÇʵÏÖ“¿´²»Çå³þ£¬»»Ò»ÕŵÄЧ¹û”
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CheckTest.aspx.cs" Inherits="SecurityCodeTest.CheckTest" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http ......
´úÂë:
/// <summary>
/// ´ò¿ªExcelÎļþ
/// </summary>
/// <param name="ExcelFileName">ÎļþÃû</param>
private void OpenExcelFile(string ExcelFileName)
{
&nb ......
³ö´¦£ºÌì¼«Íø ×÷ÕߣºÖìÏÈÖÒ±àÒë ʱ¼ä£º2006-9-25 9:26:00
Ò»¡¢¼ò½é
Èç½ñ£¬µç×ÓÓʼþÒѾ³ÉΪһÖÖÎÞËù²»ÔÚ¡¢Ò첽֪ͨºÍ·Ö²¼Ê½µÄÏûϢϵͳ¡£´æÔÚÐí¶àweb¿ª·¢³¡Ëù£»ÆäÖУ¬·þÎñÆ÷¶Ë´úÂë¶¼ÐèÒªÉú³ÉÒ»¸öµç×ÓÓʼþ²¢ÇÒ°ÑËü·¢Ë͸øÖ¸¶¨µÄ½ÓÊÕÕß¡£¸Ãµç×ÓÓʼþ¿ÉÒÔ±»·¢Ë͸øÍøµãÖеÄһЩÓû§£¬Í¨ÖªËûÃÇÓйØÓÚË ......
ÕâÊÇÎÒ´Ó±ð´¦Õª³µÄһƪÎÄÕ£¬ÏàÐÅ´ó¼Ò¶¼ºÜÊìϤµÄ£¬½²µÄºÜÃ÷°×£¬µ«ÊÇÎÒ¶ÔÆäÖÐÒ»µã´æÓÐÒÉ»ó£¬Ðí¾ÃҲûÓÐÕÒµ½´ð°¸¡£
µ÷ÓÃwebserviceʱ¿ÉÒÔ·µ»ØdatatableµÈ¸´ÔÓÊý¾ÝÀàÐÍ£¬ÏÂÃæÀý×ÓÖÐÒ²Óеģ¬ÔÚǰ̨µ÷ÓÃʱ£¬ÆäʵÕâЩÊý¾ÝÀàÐ;¹ýÁËת»»Æ÷´¦Àí¡£ÏÂÃæµÄÀý×ÓÖУ¬·µ»ØµÄdatatable±»Ò»ÏîÒ»ÏîÌí¼Óµ½selectÉÏÈ¥ÁË£¬ÆäʵÎÒ¿´Á˾ÍÊÇÒ»¸ö ......