How to save workbook without showing save dialog with Excel interop?

by

All of the arguments to WorkBook.SaveAs() are optional, but you can just use Type.Missing for most of them if you want to.

The typical call would look like:

wbook.SaveAs("c:\\temp\\blah", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault, Type.Missing, Type.Missing,
            false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
            Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
wbook.Close();

Note that I didn’t include the file extension; Excel will set that for you.

Workbook.SaveAs Method (Microsoft.Office.Tools.Excel) | Microsoft Docs describes each of the arguments.

More Related Contents:

  1. How to read an excel file in C# without using Microsoft.Office.Interop.Excel libraries
  2. How to make correct date format when writing data to Excel
  3. Importing Excel into a DataTable Quickly
  4. Reading Excel files from C#
  5. How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
  6. Reading Datetime value From Excel sheet
  7. Reading excel file using OLEDB Data Provider
  8. How to read file using NPOI
  9. How to open an Excel file in C#?
  10. EPPlus number format
  11. Read from word document line by line
  12. How to read data from excel file using c# [duplicate]
  13. Get instance of Excel application with C# by Handle
  14. BUG: Can’t choose dates on a DatePicker that fall outside a floating VSTO Add-In
  15. Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running?
  16. The quest for the Excel custom function tooltip
  17. What reference do I need to use Microsoft.Office.Interop.Excel in .NET?
  18. Set data type like number, text and date in excel column using Microsoft.Office.Interop.Excel in c#
  19. How to write an image from byte[] into MS WORD using C# Windows application
  20. Why appending AutoFilter corrupts my excel file in this example?
  21. C# – How to add an Excel Worksheet programmatically – Office XP / 2003
  22. Detecting a password-protected document
  23. How to import all the Excel sheets to DataSet in C#
  24. Scientific notation when importing from Excel in .Net
  25. EPPlus – LoadFromCollection – Text converted to number
  26. Accessing an open Excel Workbook in C#
  27. As of today, what is the right way to work with COM objects? [duplicate]
  28. .Net Excel Interop Deleting a worksheet
  29. Xamarin On Windows C#
  30. .Net Data structures: ArrayList, List, HashTable, Dictionary, SortedList, SortedDictionary — Speed, memory, and when to use each? [closed]

Leave a Comment