Exporting to .xlsx using Microsoft.Office.Interop.Excel SaveAs Error

by

This is how you save the relevant file as a Excel12 (.xlsx) file… It is not as you would intuitively think i.e. using Excel.XlFileFormat.xlExcel12 but Excel.XlFileFormat.xlOpenXMLWorkbook. The actual C# command was

excelWorkbook.SaveAs(strFullFilePathNoExt, Excel.XlFileFormat.xlOpenXMLWorkbook, Missing.Value,
    Missing.Value, false, false, Excel.XlSaveAsAccessMode.xlNoChange, 
    Excel.XlSaveConflictResolution.xlUserResolution, true, 
    Missing.Value, Missing.Value, Missing.Value);

Missing.Value is found in the System.Reflection namespace.

More Related Contents:

  1. How do I properly clean up Excel interop objects?
  2. How to export DataTable to Excel
  3. How to detect installed version of MS-Office?
  4. Format excel column to decimal doing export from c#
  5. Export DataTable to Excel with EPPlus
  6. Reading Datetime value From Excel sheet
  7. How do I export to Excel?
  8. Excel Interop – Efficiency and performance
  9. Reading excel file using OLEDB Data Provider
  10. How to get the range of occupied cells in excel sheet
  11. How to create CSV Excel file C#? [closed]
  12. How to open an Excel file in C#?
  13. EPPlus number format
  14. How to read data from excel file using c# [duplicate]
  15. Excel interop: _Worksheet or Worksheet?
  16. Excel error HRESULT: 0x800A03EC while trying to get range with cell’s name
  17. How to add data table with legend keys to a MS Chart in C#?
  18. How to make correct date format when writing data to Excel
  19. OpenFileDialog can’t load CSV files but can load xls/xlsx Excel files [duplicate]
  20. Importing Excel into a DataTable Quickly
  21. Resources for learning c# Excel interop [closed]
  22. Accessing Excel Custom Document Properties programmatically
  23. Read excel file from a stream
  24. How can I programmatically create, read, write an excel without having office installed?
  25. Why appending AutoFilter corrupts my excel file in this example?
  26. Open XML SDK 2.0 – how to update a cell in a spreadsheet?
  27. Using ExcelDataReader to read Excel data starting from a particular cell
  28. EPPlus – LoadFromCollection – Text converted to number
  29. Accessing an open Excel Workbook in C#
  30. .Net Excel Interop Deleting a worksheet

Leave a Comment