How to download excel file in window Application.

Question

In my database table near about thousand record. How could I download excel file using window application ?

Manav Pandya · Answer

Hello Try following 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(); } } Thanks

Laxmidhar Sahoo · Answer

DialogResult result = openFileDialog1.ShowDialog(); if (result == DialogResult.OK) // Test result. { string pathDestination = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory), "Files" ); foreach ( string item in openFileDialog1.FileNames) { File.Copy(item, Path.Combine(pathDestination, Path.GetFileName(item))); } } Try the bellow code may work

Sagar Pandurang Kap · Answer

Hi, Try this :- if (saveFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK) { string sourcePath = Application.StartupPath; File.Copy(sourcePath + "\filename.xls", saveFileDialog1.FileName); } Hope it helps.

How to download excel file in window Application.

Answers (3)