Loading

How to download excel file in window Application.

How to download excel file in window Application.

Sumit Ringane

Sumit Ringane

8y4.5kVisual Basic .NET

In my database table near about thousand record.

How could I download excel file using window application ?

3 Replies

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

Manav Pandya8y ago
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
0
Laxmidhar Sahoo8y ago
1. DialogResult result = openFileDialog1.ShowDialog();
2. if (result == DialogResult.OK) // Test result.
3. {
4. string pathDestination = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory), "Files");
5. foreach (string item in openFileDialog1.FileNames)
6. {
7. File.Copy(item, Path.Combine(pathDestination, Path.GetFileName(item)));
8. }
9. }
Try the bellow code may work
0

Sagar Pandurang Kap

Sagar Pandurang Kap8y ago

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.

0