source: node_modules/prismjs/components/prism-excel-formula.js@ 65b6638

Prism.languages['excel-formula'] = {
        'comment': {
                pattern: /(\bN\(\s*)"(?:[^"]|"")*"(?=\s*\))/i,
                lookbehind: true,
                greedy: true
        },
        'string': {
                pattern: /"(?:[^"]|"")*"(?!")/,
                greedy: true
        },
        'reference': {
                // https://www.ablebits.com/office-addins-blog/2015/12/08/excel-reference-another-sheet-workbook/

                // Sales!B2
                // 'Winter sales'!B2
                // [Sales.xlsx]Jan!B2:B5
                // D:\Reports\[Sales.xlsx]Jan!B2:B5
                // '[Sales.xlsx]Jan sales'!B2:B5
                // 'D:\Reports\[Sales.xlsx]Jan sales'!B2:B5

                pattern: /(?:'[^']*'|(?:[^\s()[\]{}<>*?"';,$&]*\[[^^\s()[\]{}<>*?"']+\])?\w+)!/,
                greedy: true,
                alias: 'string',
                inside: {
                        'operator': /!$/,
                        'punctuation': /'/,
                        'sheet': {
                                pattern: /[^[\]]+$/,
                                alias: 'function'
                        },
                        'file': {
                                pattern: /\[[^[\]]+\]$/,
                                inside: {
                                        'punctuation': /[[\]]/
                                }
                        },
                        'path': /[\s\S]+/
                }
        },
        'function-name': {
                pattern: /\b[A-Z]\w*(?=\()/i,
                alias: 'builtin'
        },
        'range': {
                pattern: /\$?\b(?:[A-Z]+\$?\d+:\$?[A-Z]+\$?\d+|[A-Z]+:\$?[A-Z]+|\d+:\$?\d+)\b/i,
                alias: 'selector',
                inside: {
                        'operator': /:/,
                        'cell': /\$?[A-Z]+\$?\d+/i,
                        'column': /\$?[A-Z]+/i,
                        'row': /\$?\d+/
                }
        },
        'cell': {
                // Excel is case insensitive, so the string "foo1" could be either a variable or a cell.
                // To combat this, we match cells case insensitive, if the contain at least one "$", and case sensitive otherwise.
                pattern: /\b[A-Z]+\d+\b|\$[A-Za-z]+\$?\d+\b|\b[A-Za-z]+\$\d+\b/,
                alias: 'selector'
        },
        'number': /(?:\b\d+(?:\.\d+)?|\B\.\d+)(?:e[+-]?\d+)?\b/i,
        'boolean': /\b(?:FALSE|TRUE)\b/i,
        'operator': /[-+*/^%=&,]|<[=>]?|>=?/,
        'punctuation': /[[\]();{}|]/
};

Prism.languages['xlsx'] = Prism.languages['xls'] = Prism.languages['excel-formula'];