Get list of excel formular/functions for ToDay() from worksheet. [modified]
C#
1
Posts
1
Posters
0
Views
1
Watching
-
Hi I am trying to get the list of cells that contain Today(), curretPath, filename function. Following is my code to get the list of all the formulars on the sheet. formularRange = excelSheet.Cells.SpecialCells(Excel.XlCellType.xlCellTypeFormulas,Excel.XlSpecialCellsValue.xlNumbers); if((bool)formularRange.Cells.HasFormula) { System.Array formulars; if((bool)formularRange.Cells.HasArray) formulars = (System.Array)formularRange.FormulaArray; string colname = formularRange.Cells.Name.ToString(); } Hope this help. thanks -- modified at 17:52 Wednesday 30th May, 2007