Download Excel file on button click in windows form

Rawat

hello sir i need download excel file in windows form on button click such as like we do in asp.net on <a href="file name"> tag i need this type in windows form i could be its possible plese suggest me 

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp10y ago
Hi,
You need to use below namespaces -
using System.IO;
using System.Reflection;
0
Rawat10y ago
i getting some name spaces error such as
string execPath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase);
var filePath = Path.Combine(execPath, MyFileName);
there i get error in path and assembly
0
Midhun Tp10y ago
Hi,
Please try below code -
private void button1_Click(object sender, EventArgs e)
{
var saveFileDialog = new SaveFileDialog();
saveFileDialog.DefaultExt = "xls";
saveFileDialog.Filter = "Excel files (*.xls)|*.xls |All files (*.*)|*.*";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
const string MyFileName = "filename.xls";
string execPath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase);
var filePath = Path.Combine(execPath, MyFileName);
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook book = app.Workbooks.Open(filePath);
book.SaveAs(saveFileDialog.FileName); //Save
book.Close();
}
}
0