Enumerate Only Excel Funtions using Exce.interops in c#

raghuexcel · Jul 18, 2011

Hello Experts,

I am facing a problem ... where i need a help ASAP. It is very urgent.

Scenario:

I need to find/Enumerate/Get list of all (only) excel funtions (like below) .... using Excel nterops in c#.

Excel funtions :

Finanacial
Date and time
Math& Trig
Statistical
Etc....

Kindly help me if you know this problem.

Thanks for your patience

Regards,
Raghuanthan.B

Sektor · Jul 18, 2011

AFAIK, there's no such method to retrieve built-name functions name.

raghuexcel · Jul 18, 2011

Would it be possible to get the CLSID or the PRODid for the Formulas which is being executed?

Or

Is there any way to know the current execution of the formula belongs to UDF or Excel?

RoryA · Jul 18, 2011

Functions do not have a CLSID or ProgID, and how do you plan to monitor the execution of the formula?

raghuexcel · Jul 18, 2011

Would it be possible to identify the Addin name when a corresponding formula is executed?

The Formula exection is monitored by the special cellls.
<link rel="File-List" href="file:///C:%5CDOCUME%7E1%5CRAGHUN%7E1.B%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CDOCUME%7E1%5CRAGHUN%7E1.B%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CDOCUME%7E1%5CRAGHUN%7E1.B%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style> <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format

ther; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} @font-face {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:modern; mso-font-pitch:fixed; mso-font-signature:-1610611985 1073750091 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; mso-themecolor:hyperlink; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {mso-style-noshow:yes; mso-style-priority:99; color

urple; mso-themecolor:followedhyperlink; text-decoration:underline; text-underline:single;} p.MsoPlainText, li.MsoPlainText, div.MsoPlainText {mso-style-noshow:yes; mso-style-priority:99; mso-style-link:"Plain Text Char"; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.5pt; font-family:Consolas; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} span.PlainTextChar {mso-style-name:"Plain Text Char"; mso-style-noshow:yes; mso-style-priority:99; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:"Plain Text"; mso-ansi-font-size:10.5pt; mso-bidi-font-size:10.5pt; font-family:Consolas; mso-ascii-font-family:Consolas; mso-hansi-font-family:Consolas;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style>foreach (Excel.Range mdsCell in activeSheet.UsedRange.SpecialCells(Excel.XlCellType.xlCellTypeFormulas, Missing.Value)){

// Formula
}

We need to know which formula from which addin is being executed cuurently

Sektor · Jul 18, 2011

Try reflection.

RoryA · Jul 18, 2011

That's not going to tell you which one is actually executing, it's merely going to iterate all the formulas in the sheet. There is no way that I know of to tell which formula is currently being calculated (especially as 2007 onwards can multithread) or where the formula code is located.

raghuexcel · Jul 18, 2011

Can you please suggest us an example?

Enumerate Only Excel Funtions using Exce.interops in c#

raghuexcel

New Member

Excel Facts

Sektor

Well-known Member

raghuexcel

New Member

RoryA

MrExcel MVP, Moderator

raghuexcel

New Member

Sektor

Well-known Member

RoryA

MrExcel MVP, Moderator

raghuexcel

New Member

Similar threads

Forum statistics

Share this page

Enumerate Only Excel Funtions using Exce.interops in c#

New Member

Excel Facts

Well-known Member

New Member

MrExcel MVP, Moderator

New Member

Well-known Member

MrExcel MVP, Moderator

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock