XlFileFormat for excel 2010 file

c# excel-2010
Saboor Awan picture Saboor Awan · Sep 9, 2011 · Viewed 11.1k times · Source

I want to create a excel 2010 file from C# so what will be the XlFileFormat Enumeration for it.

http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.xlfileformat.aspx

Answer

David Heffernan picture David Heffernan · Sep 9, 2011
  • xlOpenXMLWorkbook for a .xlsx macro free workbook.
  • xlOpenXMLWorkbookMacroEnabled for a .xlsm macro enabled workbook.

The key piece of knowledge is that the new Office 2007 file formats are called Office Open XML.

Related questions

Simple Example of VSTO Excel using a worksheet as a datasource

I think I'm running into a case of "the easiest answers are the hardest ones to find" and I haven't come across any searches that give this to me in a straightforward way. This is for Excel 2010 and VS 2010 within …

Read More
Open XML SDK 2.0 to get access to excel 2010 worksheet by name

I have an Excel 2010 spreadsheet that has 3 worksheets named Sheet1, Sheet2 and Sheet3. I'm trying to get a reference to a worksheet by name. I'm using the code: using (SpreadsheetDocument myWorkbook = SpreadsheetDocument.Open(FileName, true)) { //Access the main Workbook part, …

Read More
Line breaks in generated csv file driving me crazy

I'm trying to make an export of some data i have (stored in a datatable). Some of those values have a linebreak in them. Now every time i try and import the file in excel (2010), the linbreaks get recognised as …

Read More