在GetSaveAsFileName中添加过滤器 [英] Add filters in GetSaveAsFileName
本文介绍了在GetSaveAsFileName中添加过滤器的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
请帮我看看如何在Asp.net中设置过滤器
我有试过
app.GetSaveAsFilename( 客户详细信息, * .xls);
但我收到错误。
提前致谢
string fileFilter = Excel工作簿(* .xlsx),*。xlsx, +
Excel启用宏的工作簿(* .xlsm),*。xlsm, +
// Excel二进制工作簿(* .xlsb), * .xlsb,+
Excel 97-2003工作簿(* .xls),*。 xls, +
// XML数据(* .xml) ,*。xml,+
// 单个文件网页(*的.mht; * .mhtml),*。mht; * .mhtml,+
// 网页(* .htm; * .html),*。htm; *。html,+
Excel模板(* .xltx),*。xltx, +
Excel宏命令模板(* .xltm),*。xltm, +
// Excel 97-2003模板(* .xlt),*。xlt,+
< span class =code-comment> // Text(制表符分隔)(* .txt),*。txt,+
CSV(逗号分隔)(*。csv),*。csv, ;
// PDF(* .pdf),*。pdf,+
// XPS文档(* .xps),*。xps,;
// 启动我们可以控制的SaveAs对话框
object sa = Wb.Application.GetSaveAsFilename(m,fileFilter.TrimEnd( new char [] {' ,'}), m,m,m);
或这样的VB代码
fileSaveName = Application.GetSaveAsFilename(_
fileFilter:= 文本文件(* .txt),* .txt)
如果 fileSaveName<> False 然后
MsgBox 另存为& fileSaveName
结束 如果
我认为您需要按YES保存工作表。
Hi,
Please help me how to set filters in Asp.net
I have tried
app.GetSaveAsFilename("Customer Details","*.xls");
But I am getting error.
Thanks in advance
解决方案
you can use like this.
string fileFilter = "Excel Workbook (*.xlsx),*.xlsx," + "Excel Macro-Enabled Workbook (*.xlsm),*.xlsm," + //"Excel Binary Workbook (*.xlsb),*.xlsb," + "Excel 97-2003 Workbook (*.xls),*.xls," + //"XML Data (*.xml),*.xml," + //"Single File Web Page (*.mht; *.mhtml),*.mht;*.mhtml," + //"Web Page (*.htm; *.html),*.htm;*.html," + "Excel Template (*.xltx),*.xltx," + "Excel Macro-Enbaled Template (*.xltm),*.xltm," + //"Excel 97-2003 Template (*.xlt),*.xlt," + //"Text (Tab delimited)(*.txt),*.txt," + "CSV (Comma delimited)(*.csv),*.csv,"; //"PDF (*.pdf),*.pdf," + //"XPS Document (*.xps),*.xps,"; // Launch a SaveAs dialog that we can control object sa = Wb.Application.GetSaveAsFilename(m, fileFilter.TrimEnd(new char[] { ',' }), m, m, m);
or VB code like this
fileSaveName = Application.GetSaveAsFilename( _ fileFilter:="Text Files (*.txt), *.txt") If fileSaveName <> False Then MsgBox "Save as " & fileSaveName End If
i think you need to press "YES" to save the sheet.
这篇关于在GetSaveAsFileName中添加过滤器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文