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.