Microsoft is releasing PowerPivot for Excel 2010 & 2013. PowerPivot version crossed 11.
Based on the version, it have lot of functionality. To begin with the PowerPivot automation and customization, we need to check the version. This will enable us to proceed with the more customization in the powerpivot.
Below is the simple C# code to check the PowerPivot version that was used in that excel file.
This code need Microsoft.Office.Core.dll and Microsoft.Office.Interop.Excel.dll
Based on the version, it have lot of functionality. To begin with the PowerPivot automation and customization, we need to check the version. This will enable us to proceed with the more customization in the powerpivot.
Below is the simple C# code to check the PowerPivot version that was used in that excel file.
This code need Microsoft.Office.Core.dll and Microsoft.Office.Interop.Excel.dll