Excel - parse formula references

(
 (?<apos>'?)# optional apostrophe at start
 (?<filename>(\[.*\])?)   # may or may not have filename in square brackets
 (?<sheet>.*)
 \k<apos># match apostrophe if it was there
 !# Section finishes with exclamation point e.g. Sheet1!
)?# May or may not have this section

(?<cell>
 \$?# can have $ before the column letter
 [A-Z]{1,3}# column letter(s)
 \$?# can have $ before the row number
 [0-9]{1,7}# row number(s)
)
(:(?<cell2>
 \$?# can have $ before the column letter
 [A-Z]{1,3}# column letter(s)
 \$?# can have $ before the row number
 [0-9]{1,7}# row number(s)
))?
([^\w(]|$)# Must be terminated with non-word character, not bracket, or end of line
|
\".*?\"# Ignore text in quoted strings

Parses cell references from excel formulas

Alan Singfield
09/04/2013 07:58:17

0 comments so far.

Excel - parse formula references

<< back to Library