Regex Hero | The .NET Regular Expression Tester
/
.NET Regex Library
Excel - parse formula references
0
Open in the
Regex Tester
( (?<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
9/4/2013 7:58:17 AM
0 comments so far.
Log in
to leave a comment.
Preview
<< back to
Library
You cannot vote on your own.
(click to dismiss)
You may only vote once.
(click to dismiss)
You must log in to vote.
(click to dismiss)
Regex Hero
Log In
.NET Regex Tester
Reference
Library
Videos
Support