asp.net保存Excel文件时文件名的问题 我根据需要将页面中的值保存到excel文件中,在保存时我用excel.saveWorkSpace保存文件,但是文件的默认名怎么改成自己想要的,它默认为Sheet1着急,大虾们,帮帮忙啊,小弟第一次在csdn里发帖,如有不周还请谅解asp.netexcel 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 設置worksheet.Name = "Sheet名字";如下:#region 创建Excel及worksheet ConExcel.Workbooks workbooks = xlApp.Workbooks; ConExcel.Workbook workbook = workbooks.Add(ConExcel.XlWBATemplate.xlWBATWorksheet); ConExcel.Range range = null; ConExcel.Worksheet worksheet = (ConExcel.Worksheet)workbook.Worksheets.get_Item(workbook.Worksheets.Count); workbook.Worksheets.Add(Type.Missing, worksheet, Type.Missing, Type.Missing);//取得sheet1 worksheet.Name = "Sheet名字"; #endregion ConExcel.Worksheet worksheet = worksheet.Name = "Sheet名字"; 1楼正解! 另外如下不知是否對你有幫助:FileInfo fi = new FileInfo(newPath);//excelFile为文件在服务器上的地址 HttpResponse contextResponse = HttpContext.Current.Response; contextResponse.Clear(); contextResponse.Buffer = true; contextResponse.Charset = "UTF-8"; System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("Excel名稱.xls", System.Text.Encoding.UTF8)); contextResponse.AppendHeader("Content-Length", fi.Length.ToString()); contextResponse.ContentEncoding = Encoding.Default; contextResponse.ContentType = "application/ms-excel";//這個是保存的類型,我這裡是.xls contextResponse.WriteFile(fi.FullName); contextResponse.Flush(); int indexSub = newPath.LastIndexOf(@"\"); string locationSub = ""; locationSub = newPath.Substring(0, indexSub); System.IO.DirectoryInfo filePath = new System.IO.DirectoryInfo(locationSub); ConExcel是什么?我这里是这样的 using ConExcel = Microsoft.Office.Interop.Excel;引用了Microsoft.Office.Interop.Excel.dll 那我那样写也没有错吧,最后我是这样保存的 worksheet.Application.DisplayAlerts = false;//显示提示信息 worksheet.Name = fileName; //workbook.SaveAs(, missing, missing, missing, missing, missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing); excel.SaveWorkspace(fileName);但是为什么弹出框的默认文件名还是sheet1,而不是我想要的那个fileName。麻烦您了 那我那样写也没有错吧,最后我是这样保存的 worksheet.Application.DisplayAlerts = false;//显示提示信息 worksheet.Name = fileName; //workbook.SaveAs(, missing, missing, missing, missing, missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing); excel.SaveWorkspace(fileName);但是为什么弹出框的默认文件名还是sheet1,而不是我想要的那个fileName。麻烦您了不好意思,这个我也不太清楚,我用的是如下方式保存:FileInfo fi = new FileInfo(newPath);//newPath为文件在服务器上的地址 HttpResponse contextResponse = HttpContext.Current.Response; contextResponse.Clear(); contextResponse.Buffer = true; contextResponse.Charset = "UTF-8"; System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("Excel名稱.xls", System.Text.Encoding.UTF8)); contextResponse.AppendHeader("Content-Length", fi.Length.ToString()); contextResponse.ContentEncoding = Encoding.Default; contextResponse.ContentType = "application/ms-excel"; contextResponse.WriteFile(fi.FullName); contextResponse.Flush(); 多个Web.config怎么配置? SQL语句写法 谁能给个关于AspNetPager的ACCESS数据库分页代码? 如何在Global.asax.cs文件Application_EndRequest中判断页面是aspx文件还是asmx文件呢? 请求帮助,有关于IIS. 想通过asp.net赚更多钱,提高生活水平,但是看了这个贴后……哭!!!!!!! 怎么调试中,断点突然无效了? 任何显示数据备份进度条? 如何判断用户是否登录? asp.net 动态加载dll的问题 求助:如何比较两个sql server数据库是否一样。 asp.net中 HttpModel 与HttpModel
#region 创建Excel及worksheet
ConExcel.Workbooks workbooks = xlApp.Workbooks;
ConExcel.Workbook workbook = workbooks.Add(ConExcel.XlWBATemplate.xlWBATWorksheet);
ConExcel.Range range = null; ConExcel.Worksheet worksheet = (ConExcel.Worksheet)workbook.Worksheets.get_Item(workbook.Worksheets.Count);
workbook.Worksheets.Add(Type.Missing, worksheet, Type.Missing, Type.Missing);//取得sheet1
worksheet.Name = "Sheet名字";
#endregion
worksheet.Name = "Sheet名字"; 1楼正解!
FileInfo fi = new FileInfo(newPath);//excelFile为文件在服务器上的地址
HttpResponse contextResponse = HttpContext.Current.Response;
contextResponse.Clear();
contextResponse.Buffer = true;
contextResponse.Charset = "UTF-8";
System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("Excel名稱.xls", System.Text.Encoding.UTF8));
contextResponse.AppendHeader("Content-Length", fi.Length.ToString());
contextResponse.ContentEncoding = Encoding.Default;
contextResponse.ContentType = "application/ms-excel";//這個是保存的類型,我這裡是.xls
contextResponse.WriteFile(fi.FullName);
contextResponse.Flush(); int indexSub = newPath.LastIndexOf(@"\");
string locationSub = "";
locationSub = newPath.Substring(0, indexSub);
System.IO.DirectoryInfo filePath = new System.IO.DirectoryInfo(locationSub);
引用了Microsoft.Office.Interop.Excel.dll
worksheet.Application.DisplayAlerts = false;//显示提示信息
worksheet.Name = fileName;
//workbook.SaveAs(, missing, missing, missing, missing, missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing);
excel.SaveWorkspace(fileName);
但是为什么弹出框的默认文件名还是sheet1,而不是我想要的那个fileName。麻烦您了
worksheet.Application.DisplayAlerts = false;//显示提示信息
worksheet.Name = fileName;
//workbook.SaveAs(, missing, missing, missing, missing, missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing);
excel.SaveWorkspace(fileName);
但是为什么弹出框的默认文件名还是sheet1,而不是我想要的那个fileName。麻烦您了
不好意思,这个我也不太清楚,我用的是如下方式保存:
FileInfo fi = new FileInfo(newPath);//newPath为文件在服务器上的地址
HttpResponse contextResponse = HttpContext.Current.Response;
contextResponse.Clear();
contextResponse.Buffer = true;
contextResponse.Charset = "UTF-8";
System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("Excel名稱.xls", System.Text.Encoding.UTF8));
contextResponse.AppendHeader("Content-Length", fi.Length.ToString());
contextResponse.ContentEncoding = Encoding.Default;
contextResponse.ContentType = "application/ms-excel";
contextResponse.WriteFile(fi.FullName);
contextResponse.Flush();