How can I use C # to get Excel version include build version and MSO version and check Excel version is 2016 or 2021

Question

How can I use C # to get Excel version include build version and MSO version and check Excel version is 2016 or 2021

Frank Zhu 20

Question1: How can I get Excel Version with C# as same as [File -> Account -> About Excel] as below:
User's image

Question2: How can I determine Excel Version is 2016 or 2021 with C#? I found they are same in registry.

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Jack J Jun 25,316

@Frank Zhu , Welcome to Microsoft Q&A,

First, we could get the build version from the Excel.exe in the installed path of computer.

// If your excel is 32 bit, please use ProgramFiles(x86)
string path1=Environment.GetEnvironmentVariable("ProgramFiles(x86)")+ "\\Microsoft Office\\Office16\\EXCEL.EXE";
// If your excel is 64 bit, please use ProgramFiles
string path2= Environment.GetEnvironmentVariable("ProgramFiles") + "\\Microsoft Office\\Office16\\EXCEL.EXE";
var file = FileVersionInfo.GetVersionInfo(path1);
Console.WriteLine(file.FileVersion);

Note: MSO version is not related to excel version, which is related to some office installation. So, there is no need to get it/

Second, you could try to install nuget-package Microsoft.Office.Interop.Excel and use the following code to check if the Excel Version is 2016 or 2021.

            Excel.Application objApp = new Excel.Application();
            int version=Convert.ToInt32(objApp.Version);
            if(version==16)
            {
                Console.WriteLine("This is Excel 2016");
            }
            if(version==21)
            {
                Console.WriteLine("This is Excel 2021");
            }

Tested result:

User's image

Best Regards,

Jack

If the answer is the right solution, please click "Accept Answer" and upvote it.If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Frank Zhu 20 Reputation points

2023-02-20T03:01:08.0466667+00:00

It cannot work, using Microsoft.Office.Interop.Excel and the version of Excel 2021 is 16 too.
Jack J Jun 25,316 Reputation points

2023-02-20T03:03:52.0233333+00:00

@Frank Zhu, thanks for the feedback, did you only install the Excel 2021 in your computer, or you install 2021 and 2016 both in your computer?
Frank Zhu 20 Reputation points

2023-02-20T03:04:03.1833333+00:00

Hi Jack
Thank you for your answer.

Using your source code cannot determine the version of Excel is 2016 or 2021 because the version of them are 16.

Best Regards

Frank

Jack J Jun 25,316

@Frank Zhu, you could also use another method to use registry to check if the excel is 2016 or 2021.

 using (RegistryKey key = Registry.ClassesRoot.OpenSubKey("Excel.Application\\CurVer"))
            {
                if (key != null)
                {
                    Console.WriteLine(key.GetValue(""));
                    
                }
            }

I get the result:

User's image

Jack J Jun 25,316 Reputation points

2023-02-23T07:37:32.25+00:00

@Frank Zhu, is any update? Have you tried my updated solution?

Share via

How can I use C # to get Excel version include build version and MSO version and check Excel version is 2016 or 2021

0 additional answers

Your answer