Using SaveFileDialog with ClosedXML

Question

I try to tell you my problem. with ClosedXML i have SaveAs() method, but when i use SaveAs(string name), it saves my excel document to some strange folder with some strange path. so i've decide to use savefiledialog to give user posibility to select folder and name for document. how can i use savefiledialog with closedXML?

SaveAs() also have SaveAs(Path path). Can i use it?

Yes, it have two overloads - SaveAs(string name) and SaveAs(Path path) — Viaches, Aug 10 '12 at 09:51
I don't know for sure, however my guess would be that you could do something like `string path = saveFileDialog.Path` after the user selects the path then use the `SaveAs(name, path)` or however `SaveAs` overloads. It's just a guess though. — Garrett Fogerlie, Aug 10 '12 at 09:54

score 6 · Accepted Answer · answered Aug 10 '12 at 14:33

The "strange" folder is the folder your application is running from (since you're not specifying a path).

If you want you can use the SaveFileDialog to get the path and pass it to the SaveAs method.

    var saveFileDialog = new SaveFileDialog
                             {
                                 Filter = "Excel files|*.xlsx", 
                                 Title = "Save an Excel File"
                             };

    saveFileDialog.ShowDialog();

    if (!String.IsNullOrWhiteSpace(saveFileDialog.FileName))
        workbook.SaveAs(saveFileDialog.FileName);

Btw, strange path for strange folder is C:\Windows\System32\inetsrv and it's not a folder my application is running from) — Viaches, Aug 16 '12 at 07:39

score 0 · Answer 2 · edited Oct 10 '19 at 14:51

0

var saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Excel files|*.xlsx";

//serialVal is name of a variable, not necessary at all if you don't need a specific file name

saveFileDialog.FileName = serialVal; 
if (saveFileDialog.ShowDialog() == true)
{
    workbook.SaveAs(saveFileDialog.FileName);
    workbook.Dispose();
    return;
}

edited Oct 10 '19 at 14:51

kiner_shah

3,939
7
23
37

answered Oct 10 '19 at 14:17

fra

1

Using SaveFileDialog with ClosedXML

2 Answers2