解決ASP.NET導(dǎo)出Excel文件時(shí)用Excel2007打開時(shí)彈出文件類型與擴(kuò)展名不同的對(duì)話框protectedvoidbtnExport_Click(objectsender,EventArgse)3{4stringstrMapPath=Server.MapPath("~/");//獲取Web應(yīng)用程序的物理路徑5stringsourceExcelFileName=strMapPath+"Temp.xls";//源Excel文件名6stringtargetExcelFileName=strMapPath+@"TempExcel\"+Guid.NewGuid().ToString()+".xls";//使用Guid生成全局唯一字符串，作為目標(biāo)Excel文件的文件名78File.Copy(sourceExcelFileName,targetExcelFileName);//Copy文件，放在目標(biāo)文件夾中910//Excel模型，用來(lái)操作Excel文件11Microsoft.Office.Interop.Excel.ApplicationexcelApp=null;12Microsoft.Office.Interop.Excel.WorkbookexcelWb=null;13Microsoft.Office.Interop.Excel.WorksheetexcelWs=null;14Microsoft.Office.Interop.Excel.RangeexcelR=null;1516try17{18excelApp=newMicrosoft.Office.Interop.Excel.Application();19excelWb=excelApp.Workbooks.Open(targetExcelFileName);//打開Excel工作簿文件20excelWs=(Microsoft.Office.Interop.Excel.Worksheet)(excelWb.Sheets.get_Item(1));//選擇工作簿中第一個(gè)工作表2122//向Excel中添加列名23for(inti=0;i<dtbl.Columns.Count;i++)24{25stringrangeName=((Char)(i+Excel58Response.ContentType="application/ms-excel";59Response.WriteFile(targetExcelFileName);//把剛剛生成的Excel文件寫入Http流60Response.End();6162}2.由于會(huì)在臨時(shí)文件夾中存儲(chǔ)Excel文件，所以寫了一個(gè)類用來(lái)清理過(guò)期不用的Excel文件：1///<summary>2///TempExcelCleaner清理TempExcel文件夾中已經(jīng)不用的臨時(shí)Excel文件3///</summary>4publicclassTempExcelCleaner5{6privatestringtempDirectoryPath;7privateintovertime=30;8privateintsleeptime=60;910///<summary>11///每次掃描文件夾的間隔時(shí)間，單位分鐘12///</summary>13publicintSleeptime14{15get{returnsleeptime;}16set{sleeptime=value;}17}1819///<summary>20///文件過(guò)期時(shí)間，單位分鐘21///</summary>22publicintOvertime23{24get{returnovertime;}25set{overtime=value;}26}2728///<summary>29///構(gòu)造TempExcelCleaner30///</summary>31///<paramname="tempDirectoryPath">要清理的文件夾路徑</param>32publicTempExcelCleaner(stringtempDirectoryPath)33{34this.tempDirectoryPath=tempDirectoryPath;35}3637privateTempExcelCleaner()38{39}4041///<summary>42///運(yùn)行，開始清理指定文件夾43///</summary>44publicvoidRun()45{46DirectoryInfodirectory=newDirectoryInfo(tempDirectoryPath);47//遍歷文件夾中所有文件，超過(guò)指定時(shí)間就刪除48foreach(FileInfofileindirectory.GetFiles())49{50DateTimecreateTime=file.CreationTime;51if(createTime.AddMinutes(overtime)<DateTime.Now)52{53file.Delete();54}55}56//遍歷完所有文件，休息指定時(shí)間57System.Threading.Thread.Sleep(sleeptime*60*1000);58}59}3.在Golobal.asax中的代碼，在Web應(yīng)用程序啟動(dòng)時(shí)開始臨時(shí)文件清理的服務(wù)：1voidApplication_Start(objectsender,EventArgse)2{3//在應(yīng)用程序啟動(dòng)時(shí)運(yùn)行的代碼4//Web應(yīng)用程序啟動(dòng)時(shí)開始執(zhí)行清理程序。5System.Threading.ThreadthreadTempExcelCleaner=newSystem.Threading.Thread(newSystem.Threading.ThreadStart(FunCleanTempExcel));6threadTempExcelCleaner.IsBackground=true;7threadTempExcelCleaner.Start();8}910voidFunCleanTempE