Download Excel file on button click in windows form

Question

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

Midhun T P · Answer

Hi You need to use below namespaces - using System.IO; using System.Reflection;

Rawat · Answer

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

Midhun T P · Answer

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(); } }