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 ?

 

 

 

 

Answer 1

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 

Answer 2

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

 

 

Answer 3

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.