Excel to pdf using interop

Question

I am converting excel file to pdf using interop. and i have a working code.

but before saving it to pdf. it prompt a dialog box which ask the user to "save changes to the file or not" how can i avoid this prompt?

and how can i close the excel when saving is done? Thank you

public string ExceltoPdf(string excelLocation, string outputLocation)
        {
            try
            {
                Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
                app.Visible = false;
                Microsoft.Office.Interop.Excel.Workbook wkb = app.Workbooks.Open(excelLocation);
                wkb.ExportAsFixedFormat(Microsoft.Office.Interop.Excel.XlFixedFormatType.xlTypePDF, outputLocation);

                wkb.Close();
                app.Quit();

                return outputLocation;

            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.StackTrace);
                throw ex;
            }
        }

NetMage · Accepted Answer · 2017-05-09 23:33:29Z

3

Try adding

app.DisplayAlerts = False

after you set .Visible.

answered May 9, 2017 at 23:33

NetMage

27.1k3 gold badges39 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Fabian S. · Accepted Answer · 2018-01-18 12:59:27Z

1

Open your Excel as ReadOnly

Microsoft.Office.Interop.Excel.Workbook wkb = app.Workbooks.Open(excelLocation, ReadOnly: true);

edited Jan 18, 2018 at 12:59

Fabian S.

9776 silver badges22 bronze badges

answered Jan 18, 2018 at 11:36

Lakshan Dhanasekara

215 bronze badges

Collectives™ on Stack Overflow

Excel to pdf using interop

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related