Python Script to analyze Excel formula nested parentheses and arguments

Dane
2014-03-14
2014-03-14
  • Dane
    Dane
    2014-03-14

    Oh man, as soon as I posted this, I realized that I left out support for references to Table cells, such as TablePeriods[[#Headers],[YearMonth]]. I'll have to add that soon.

     
  • Dane
    Dane
    2014-03-14

    I just took care of the square brackets. I believe that states 3-5 handle square-brackets depths pretty well. Square brackets inside quotes will be ignored. Should be all good on that front.