xlsbdump.py

#!/usr/bin/env python

from __future__ import print_function

__description__ = 'XLSB parser'
__author__ = 'Didier Stevens'
__version__ = '0.0.1'
__date__ = '2022/03/29'

"""
Source code put in the public domain by Didier Stevens, no Copyright
https://DidierStevens.com
Use at your own risk

History:
  2022/03/28: start from binary template
  2022/03/29: continue

Todo:
"""

import optparse
import sys
import os
import zipfile
import binascii
import random
import gzip
import collections
import glob
import textwrap
import re
import struct
import string
import math
import fnmatch
import json
import time
import csv
if sys.version_info[0] >= 3:
    from io import BytesIO as DataIO
else:
    from cStringIO import StringIO as DataIO
if sys.version_info[0] >= 3:
    from io import StringIO
else:
    from cStringIO import StringIO

REGEX_STANDARD = b'[\x09\x20-\x7E]'

def PrintManual():
    manual = r'''
Manual:

This tool takes XLSB files as input and parses them.

https://docs.microsoft.com/en-us/openspecs/office_file_formats/ms-xlsb/acc8aa92-1f02-4167-99f5-84f9f676b95a

'''
    for line in manual.split('\n'):
        print(textwrap.fill(line, 79))

DEFAULT_SEPARATOR = ','
QUOTE = '"'

def PrintError(*args, **kwargs):
    print(*args, file=sys.stderr, **kwargs)

#Convert 2 Bytes If Python 3
def C2BIP3(string):
    if sys.version_info[0] > 2:
        return bytes([ord(x) for x in string])
    else:
        return string

#Convert 2 Integer If Python 2
def C2IIP2(data):
    if sys.version_info[0] > 2:
        return data
    else:
        return ord(data)

# CIC: Call If Callable
def CIC(expression):
    if callable(expression):
        return expression()
    else:
        return expression

# IFF: IF Function
def IFF(expression, valueTrue, valueFalse):
    if expression:
        return CIC(valueTrue)
    else:
        return CIC(valueFalse)

#-BEGINCODE cBinaryFile------------------------------------------------------------------------------
#import random
#import binascii
#import zipfile
#import gzip
#import sys
#if sys.version_info[0] >= 3:
#    from io import BytesIO as DataIO
#else:
#    from cStringIO import StringIO as DataIO

def LoremIpsumSentence(minimum, maximum):
    words = ['lorem', 'ipsum', 'dolor', 'sit', 'amet', 'consectetur', 'adipiscing', 'elit', 'etiam', 'tortor', 'metus', 'cursus', 'sed', 'sollicitudin', 'ac', 'sagittis', 'eget', 'massa', 'praesent', 'sem', 'fermentum', 'dignissim', 'in', 'vel', 'augue', 'scelerisque', 'auctor', 'libero', 'nam', 'a', 'gravida', 'odio', 'duis', 'vestibulum', 'vulputate', 'quam', 'nec', 'cras', 'nibh', 'feugiat', 'ut', 'vitae', 'ornare', 'justo', 'orci', 'varius', 'natoque', 'penatibus', 'et', 'magnis', 'dis', 'parturient', 'montes', 'nascetur', 'ridiculus', 'mus', 'curabitur', 'nisl', 'egestas', 'urna', 'iaculis', 'lectus', 'maecenas', 'ultrices', 'velit', 'eu', 'porta', 'hac', 'habitasse', 'platea', 'dictumst', 'integer', 'id', 'commodo', 'mauris', 'interdum', 'malesuada', 'fames', 'ante', 'primis', 'faucibus', 'accumsan', 'pharetra', 'aliquam', 'nunc', 'at', 'est', 'non', 'leo', 'nulla', 'sodales', 'porttitor', 'facilisis', 'aenean', 'condimentum', 'rutrum', 'facilisi', 'tincidunt', 'laoreet', 'ultricies', 'neque', 'diam', 'euismod', 'consequat', 'tempor', 'elementum', 'lobortis', 'erat', 'ligula', 'risus', 'donec', 'phasellus', 'quisque', 'vivamus', 'pellentesque', 'tristique', 'venenatis', 'purus', 'mi', 'dictum', 'posuere', 'fringilla', 'quis', 'magna', 'pretium', 'felis', 'pulvinar', 'lacinia', 'proin', 'viverra', 'lacus', 'suscipit', 'aliquet', 'dui', 'molestie', 'dapibus', 'mollis', 'suspendisse', 'sapien', 'blandit', 'morbi', 'tellus', 'enim', 'maximus', 'semper', 'arcu', 'bibendum', 'convallis', 'hendrerit', 'imperdiet', 'finibus', 'fusce', 'congue', 'ullamcorper', 'placerat', 'nullam', 'eros', 'habitant', 'senectus', 'netus', 'turpis', 'luctus', 'volutpat', 'rhoncus', 'mattis', 'nisi', 'ex', 'tempus', 'eleifend', 'vehicula', 'class', 'aptent', 'taciti', 'sociosqu', 'ad', 'litora', 'torquent', 'per', 'conubia', 'nostra', 'inceptos', 'himenaeos']
    sample = random.sample(words, random.randint(minimum, maximum))
    sample[0] = sample[0].capitalize()
    return ' '.join(sample) + '.'

def LoremIpsum(sentences):
    return ' '.join([LoremIpsumSentence(15, 30) for i in range(sentences)])

STATE_START = 0
STATE_IDENTIFIER = 1
STATE_STRING = 2
STATE_SPECIAL_CHAR = 3
STATE_ERROR = 4

FUNCTIONNAME_REPEAT = 'repeat'
FUNCTIONNAME_RANDOM = 'random'
FUNCTIONNAME_CHR = 'chr'
FUNCTIONNAME_LOREMIPSUM = 'loremipsum'

def Tokenize(expression):
    result = []
    token = ''
    state = STATE_START
    while expression != '':
        char = expression[0]
        expression = expression[1:]
        if char == "'":
            if state == STATE_START:
                state = STATE_STRING
            elif state == STATE_IDENTIFIER:
                result.append([STATE_IDENTIFIER, token])
                state = STATE_STRING
                token = ''
            elif state == STATE_STRING:
                result.append([STATE_STRING, token])
                state = STATE_START
                token = ''
        elif char >= '0' and char <= '9' or char.lower() >= 'a' and char.lower() <= 'z':
            if state == STATE_START:
                token = char
                state = STATE_IDENTIFIER
            else:
                token += char
        elif char == ' ':
            if state == STATE_IDENTIFIER:
                result.append([STATE_IDENTIFIER, token])
                token = ''
                state = STATE_START
            elif state == STATE_STRING:
                token += char
        else:
            if state == STATE_IDENTIFIER:
                result.append([STATE_IDENTIFIER, token])
                token = ''
                state = STATE_START
                result.append([STATE_SPECIAL_CHAR, char])
            elif state == STATE_STRING:
                token += char
            else:
                result.append([STATE_SPECIAL_CHAR, char])
                token = ''
    if state == STATE_IDENTIFIER:
        result.append([state, token])
    elif state == STATE_STRING:
        result = [[STATE_ERROR, 'Error: string not closed', token]]
    return result

def ParseFunction(tokens):
    if len(tokens) == 0:
        print('Parsing error')
        return None, tokens
    if tokens[0][0] == STATE_STRING or tokens[0][0] == STATE_IDENTIFIER and tokens[0][1].startswith('0x'):
        return [[FUNCTIONNAME_REPEAT, [[STATE_IDENTIFIER, '1'], tokens[0]]], tokens[1:]]
    if tokens[0][0] != STATE_IDENTIFIER:
        print('Parsing error')
        return None, tokens
    function = tokens[0][1]
    tokens = tokens[1:]
    if len(tokens) == 0:
        print('Parsing error')
        return None, tokens
    if tokens[0][0] != STATE_SPECIAL_CHAR or tokens[0][1] != '(':
        print('Parsing error')
        return None, tokens
    tokens = tokens[1:]
    if len(tokens) == 0:
        print('Parsing error')
        return None, tokens
    arguments = []
    while True:
        if tokens[0][0] != STATE_IDENTIFIER and tokens[0][0] != STATE_STRING:
            print('Parsing error')
            return None, tokens
        arguments.append(tokens[0])
        tokens = tokens[1:]
        if len(tokens) == 0:
            print('Parsing error')
            return None, tokens
        if tokens[0][0] != STATE_SPECIAL_CHAR or (tokens[0][1] != ',' and tokens[0][1] != ')'):
            print('Parsing error')
            return None, tokens
        if tokens[0][0] == STATE_SPECIAL_CHAR and tokens[0][1] == ')':
            tokens = tokens[1:]
            break
        tokens = tokens[1:]
        if len(tokens) == 0:
            print('Parsing error')
            return None, tokens
    return [[function, arguments], tokens]

def Parse(expression):
    tokens = Tokenize(expression)
    if len(tokens) == 0:
        print('Parsing error')
        return None
    if tokens[0][0] == STATE_ERROR:
        print(tokens[0][1])
        print(tokens[0][2])
        print(expression)
        return None
    functioncalls = []
    while True:
        functioncall, tokens = ParseFunction(tokens)
        if functioncall == None:
            return None
        functioncalls.append(functioncall)
        if len(tokens) == 0:
            return functioncalls
        if tokens[0][0] != STATE_SPECIAL_CHAR or tokens[0][1] != '+':
            print('Parsing error')
            return None
        tokens = tokens[1:]

def InterpretInteger(token):
    if token[0] != STATE_IDENTIFIER:
        return None
    try:
        return int(token[1])
    except:
        return None

def Hex2Bytes(hexadecimal):
    if len(hexadecimal) % 2 == 1:
        hexadecimal = '0' + hexadecimal
    try:
        return binascii.a2b_hex(hexadecimal)
    except:
        return None

def InterpretHexInteger(token):
    if token[0] != STATE_IDENTIFIER:
        return None
    if not token[1].startswith('0x'):
        return None
    bytes = Hex2Bytes(token[1][2:])
    if bytes == None:
        return None
    integer = 0
    for byte in bytes:
        integer = integer * 0x100 + C2IIP2(byte)
    return integer

def InterpretNumber(token):
    number = InterpretInteger(token)
    if number == None:
        return InterpretHexInteger(token)
    else:
        return number

def InterpretBytes(token):
    if token[0] == STATE_STRING:
        return token[1]
    if token[0] != STATE_IDENTIFIER:
        return None
    if not token[1].startswith('0x'):
        return None
    return Hex2Bytes(token[1][2:])

def CheckFunction(functionname, arguments, countarguments, maxcountarguments=None):
    if maxcountarguments == None:
        if countarguments == 0 and len(arguments) != 0:
            print('Error: function %s takes no arguments, %d are given' % (functionname, len(arguments)))
            return True
        if countarguments == 1 and len(arguments) != 1:
            print('Error: function %s takes 1 argument, %d are given' % (functionname, len(arguments)))
            return True
        if countarguments != len(arguments):
            print('Error: function %s takes %d arguments, %d are given' % (functionname, countarguments, len(arguments)))
            return True
    else:
        if len(arguments) < countarguments or len(arguments) > maxcountarguments:
            print('Error: function %s takes between %d and %d arguments, %d are given' % (functionname, countarguments, maxcountarguments, len(arguments)))
            return True
    return False

def CheckNumber(argument, minimum=None, maximum=None):
    number = InterpretNumber(argument)
    if number == None:
        print('Error: argument should be a number: %s' % argument[1])
        return None
    if minimum != None and number < minimum:
        print('Error: argument should be minimum %d: %d' % (minimum, number))
        return None
    if maximum != None and number > maximum:
        print('Error: argument should be maximum %d: %d' % (maximum, number))
        return None
    return number

def Interpret(expression):
    functioncalls = Parse(expression)
    if functioncalls == None:
        return None
    decoded = ''
    for functioncall in functioncalls:
        functionname, arguments = functioncall
        if functionname == FUNCTIONNAME_REPEAT:
            if CheckFunction(functionname, arguments, 2):
                return None
            number = CheckNumber(arguments[0], minimum=1)
            if number == None:
                return None
            bytes = InterpretBytes(arguments[1])
            if bytes == None:
                print('Error: argument should be a byte sequence: %s' % arguments[1][1])
                return None
            decoded += number * bytes
        elif functionname == FUNCTIONNAME_RANDOM:
            if CheckFunction(functionname, arguments, 1):
                return None
            number = CheckNumber(arguments[0], minimum=1)
            if number == None:
                return None
            decoded += ''.join([chr(random.randint(0, 255)) for x in range(number)])
        elif functionname == FUNCTIONNAME_LOREMIPSUM:
            if CheckFunction(functionname, arguments, 1):
                return None
            number = CheckNumber(arguments[0], minimum=1)
            if number == None:
                return None
            decoded += LoremIpsum(number)
        elif functionname == FUNCTIONNAME_CHR:
            if CheckFunction(functionname, arguments, 1, 2):
                return None
            number = CheckNumber(arguments[0], minimum=0, maximum=255)
            if number == None:
                return None
            if len(arguments) == 1:
                decoded += chr(number)
            else:
                number2 = CheckNumber(arguments[1], minimum=0, maximum=255)
                if number2 == None:
                    return None
                if number < number2:
                    decoded += ''.join([chr(n) for n in range(number, number2 + 1)])
                else:
                    decoded += ''.join([chr(n) for n in range(number, number2 - 1, -1)])
        else:
            print('Error: unknown function: %s' % functionname)
            return None
    return decoded

def ParsePackExpression(data):
    try:
        packFormat, pythonExpression = data.split('#', 1)
        data = struct.pack(packFormat, int(pythonExpression))
        return data
    except:
        return None

FCH_FILENAME = 0
FCH_DATA = 1
FCH_ERROR = 2

def FilenameCheckHash(filename, literalfilename):
    if literalfilename:
        return FCH_FILENAME, filename
    elif filename.startswith('#h#'):
        result = Hex2Bytes(filename[3:].replace(' ', ''))
        if result == None:
            return FCH_ERROR, 'hexadecimal'
        else:
            return FCH_DATA, result
    elif filename.startswith('#b#'):
        try:
            return FCH_DATA, binascii.a2b_base64(filename[3:])
        except:
            return FCH_ERROR, 'base64'
    elif filename.startswith('#e#'):
        result = Interpret(filename[3:])
        if result == None:
            return FCH_ERROR, 'expression'
        else:
            return FCH_DATA, C2BIP3(result)
    elif filename.startswith('#p#'):
        result = ParsePackExpression(filename[3:])
        if result == None:
            return FCH_ERROR, 'pack'
        else:
            return FCH_DATA, result
    elif filename.startswith('#'):
        return FCH_DATA, C2BIP3(filename[1:])
    else:
        return FCH_FILENAME, filename

def AnalyzeFileError(filename):
    PrintError('Error opening file %s' % filename)
    PrintError(sys.exc_info()[1])
    try:
        if not os.path.exists(filename):
            PrintError('The file does not exist')
        elif os.path.isdir(filename):
            PrintError('The file is a directory')
        elif not os.path.isfile(filename):
            PrintError('The file is not a regular file')
    except:
        pass

class cBinaryFile:
    def __init__(self, filename, zippassword='infected', noextraction=False, literalfilename=False):
        self.filename = filename
        self.zippassword = zippassword
        self.noextraction = noextraction
        self.literalfilename = literalfilename
        self.oZipfile = None
        self.extracted = False
        self.fIn = None

        fch, data = FilenameCheckHash(self.filename, self.literalfilename)
        if fch == FCH_ERROR:
            line = 'Error %s parsing filename: %s' % (data, self.filename)
            raise Exception(line)

        try:
            if self.filename == '':
                if sys.platform == 'win32':
                    import msvcrt
                    msvcrt.setmode(sys.stdin.fileno(), os.O_BINARY)
                self.fIn = sys.stdin
            elif fch == FCH_DATA:
                self.fIn = DataIO(data)
            elif not self.noextraction and self.filename.lower().endswith('.zip'):
                self.oZipfile = zipfile.ZipFile(self.filename, 'r')
                if len(self.oZipfile.infolist()) == 1:
                    self.fIn = self.oZipfile.open(self.oZipfile.infolist()[0], 'r', self.zippassword)
                    self.extracted = True
                else:
                    self.oZipfile.close()
                    self.oZipfile = None
                    self.fIn = open(self.filename, 'rb')
            elif not self.noextraction and self.filename.lower().endswith('.gz'):
                self.fIn = gzip.GzipFile(self.filename, 'rb')
                self.extracted = True
            else:
                self.fIn = open(self.filename, 'rb')
        except:
            AnalyzeFileError(self.filename)
            raise

    def close(self):
        if self.fIn != sys.stdin and self.fIn != None:
            self.fIn.close()
        if self.oZipfile != None:
            self.oZipfile.close()

    def read(self, size=None):
        try:
            fRead = self.fIn.buffer
        except:
            fRead = self.fIn
        if size == None:
            return fRead.read()
        else:
            return fRead.read(size)

    def Data(self):
        data = self.read()
        self.close()
        return data

#-ENDCODE cBinaryFile--------------------------------------------------------------------------------

def File2Strings(filename):
    try:
        if filename == '':
            f = sys.stdin
        else:
            f = open(filename, 'r')
    except:
        return None
    try:
        return map(lambda line:line.rstrip('\n'), f.readlines())
    except:
        return None
    finally:
        if f != sys.stdin:
            f.close()

def File2String(filename):
    try:
        f = open(filename, 'rb')
    except:
        return None
    try:
        return f.read()
    except:
        return None
    finally:
        f.close()

def ProcessAt(argument):
    if argument.startswith('@'):
        strings = File2Strings(argument[1:])
        if strings == None:
            raise Exception('Error reading %s' % argument)
        else:
            return strings
    else:
        return [argument]

def Glob(filename):
    filenames = glob.glob(filename)
    if len(filenames) == 0:
        return [filename]
    else:
        return filenames

class cExpandFilenameArguments():
    def __init__(self, filenames, literalfilenames=False, recursedir=False, checkfilenames=False, expressionprefix=None, flagprefix=None):
        self.containsUnixShellStyleWildcards = False
        self.warning = False
        self.message = ''
        self.filenameexpressionsflags = []
        self.expressionprefix = expressionprefix
        self.flagprefix = flagprefix
        self.literalfilenames = literalfilenames

        expression = ''
        flag = ''
        if len(filenames) == 0:
            self.filenameexpressionsflags = [['', '', '']]
        elif literalfilenames:
            self.filenameexpressionsflags = [[filename, '', ''] for filename in filenames]
        elif recursedir:
            for dirwildcard in filenames:
                if expressionprefix != None and dirwildcard.startswith(expressionprefix):
                    expression = dirwildcard[len(expressionprefix):]
                elif flagprefix != None and dirwildcard.startswith(flagprefix):
                    flag = dirwildcard[len(flagprefix):]
                else:
                    if dirwildcard.startswith('@'):
                        for filename in ProcessAt(dirwildcard):
                            self.filenameexpressionsflags.append([filename, expression, flag])
                    elif os.path.isfile(dirwildcard):
                        self.filenameexpressionsflags.append([dirwildcard, expression, flag])
                    else:
                        if os.path.isdir(dirwildcard):
                            dirname = dirwildcard
                            basename = '*'
                        else:
                            dirname, basename = os.path.split(dirwildcard)
                            if dirname == '':
                                dirname = '.'
                        for path, dirs, files in os.walk(dirname):
                            for filename in fnmatch.filter(files, basename):
                                self.filenameexpressionsflags.append([os.path.join(path, filename), expression, flag])
        else:
            for filename in list(collections.OrderedDict.fromkeys(sum(map(self.Glob, sum(map(ProcessAt, filenames), [])), []))):
                if expressionprefix != None and filename.startswith(expressionprefix):
                    expression = filename[len(expressionprefix):]
                elif flagprefix != None and filename.startswith(flagprefix):
                    flag = filename[len(flagprefix):]
                else:
                    self.filenameexpressionsflags.append([filename, expression, flag])
            self.warning = self.containsUnixShellStyleWildcards and len(self.filenameexpressionsflags) == 0
            if self.warning:
                self.message = "Your filename argument(s) contain Unix shell-style wildcards, but no files were matched.\nCheck your wildcard patterns or use option literalfilenames if you don't want wildcard pattern matching."
                return
        if self.filenameexpressionsflags == [] and (expression != '' or flag != ''):
            self.filenameexpressionsflags = [['', expression, flag]]
        if checkfilenames:
            self.CheckIfFilesAreValid()

    def Glob(self, filename):
        if not ('?' in filename or '*' in filename or ('[' in filename and ']' in filename)):
            return [filename]
        self.containsUnixShellStyleWildcards = True
        return glob.glob(filename)

    def CheckIfFilesAreValid(self):
        valid = []
        doesnotexist = []
        isnotafile = []
        for filename, expression, flag in self.filenameexpressionsflags:
            hashfile = False
            try:
                hashfile = FilenameCheckHash(filename, self.literalfilenames)[0] == FCH_DATA
            except:
                pass
            if filename == '' or hashfile:
                valid.append([filename, expression, flag])
            elif not os.path.exists(filename):
                doesnotexist.append(filename)
            elif not os.path.isfile(filename):
                isnotafile.append(filename)
            else:
                valid.append([filename, expression, flag])
        self.filenameexpressionsflags = valid
        if len(doesnotexist) > 0:
            self.warning = True
            self.message += 'The following files do not exist and will be skipped: ' + ' '.join(doesnotexist) + '\n'
        if len(isnotafile) > 0:
            self.warning = True
            self.message += 'The following files are not regular files and will be skipped: ' + ' '.join(isnotafile) + '\n'

    def Filenames(self):
        if self.expressionprefix == None:
            return [filename for filename, expression, flag in self.filenameexpressionsflags]
        else:
            return self.filenameexpressionsflags

def CheckJSON(stringJSON):
    try:
        object = json.loads(stringJSON)
    except:
        print('Error parsing JSON')
        print(sys.exc_info()[1])
        return None
    if not isinstance(object, dict):
        print('Error JSON is not a dictionary')
        return None
    if not 'version' in object:
        print('Error JSON dictionary has no version')
        return None
    if object['version'] != 2:
        print('Error JSON dictionary has wrong version')
        return None
    if not 'id' in object:
        print('Error JSON dictionary has no id')
        return None
    if object['id'] != 'didierstevens.com':
        print('Error JSON dictionary has wrong id')
        return None
    if not 'type' in object:
        print('Error JSON dictionary has no type')
        return None
    if object['type'] != 'content':
        print('Error JSON dictionary has wrong type')
        return None
    if not 'fields' in object:
        print('Error JSON dictionary has no fields')
        return None
    if not 'name' in object['fields']:
        print('Error JSON dictionary has no name field')
        return None
    if not 'content' in object['fields']:
        print('Error JSON dictionary has no content field')
        return None
    if not 'items' in object:
        print('Error JSON dictionary has no items')
        return None
    for item in object['items']:
        item['content'] = binascii.a2b_base64(item['content'])
    return object['items']

CUTTERM_NOTHING = 0
CUTTERM_POSITION = 1
CUTTERM_FIND = 2
CUTTERM_LENGTH = 3

def Replace(string, dReplacements):
    if string in dReplacements:
        return dReplacements[string]
    else:
        return string

def ParseInteger(argument):
    sign = 1
    if argument.startswith('+'):
        argument = argument[1:]
    elif argument.startswith('-'):
        argument = argument[1:]
        sign = -1
    if argument.startswith('0x'):
        return sign * int(argument[2:], 16)
    else:
        return sign * int(argument)

def ParseCutTerm(argument):
    if argument == '':
        return CUTTERM_NOTHING, None, ''
    oMatch = re.match(r'\-?0x([0-9a-f]+)', argument, re.I)
    if oMatch == None:
        oMatch = re.match(r'\-?(\d+)', argument)
    else:
        value = int(oMatch.group(1), 16)
        if argument.startswith('-'):
            value = -value
        return CUTTERM_POSITION, value, argument[len(oMatch.group(0)):]
    if oMatch == None:
        oMatch = re.match(r'\[([0-9a-f]+)\](\d+)?([+-](?:0x[0-9a-f]+|\d+))?', argument, re.I)
    else:
        value = int(oMatch.group(1))
        if argument.startswith('-'):
            value = -value
        return CUTTERM_POSITION, value, argument[len(oMatch.group(0)):]
    if oMatch == None:
        oMatch = re.match(r"\[u?\'(.+?)\'\](\d+)?([+-](?:0x[0-9a-f]+|\d+))?", argument)
    else:
        if len(oMatch.group(1)) % 2 == 1:
            raise Exception("Uneven length hexadecimal string")
        else:
            return CUTTERM_FIND, (binascii.a2b_hex(oMatch.group(1)), int(Replace(oMatch.group(2), {None: '1'})), ParseInteger(Replace(oMatch.group(3), {None: '0'}))), argument[len(oMatch.group(0)):]
    if oMatch == None:
        return None, None, argument
    else:
        if argument.startswith("[u'"):
            # convert ascii to unicode 16 byte sequence
            searchtext = oMatch.group(1).decode('unicode_escape').encode('utf16')[2:]
        else:
            searchtext = oMatch.group(1)
        return CUTTERM_FIND, (searchtext, int(Replace(oMatch.group(2), {None: '1'})), ParseInteger(Replace(oMatch.group(3), {None: '0'}))), argument[len(oMatch.group(0)):]

def ParseCutArgument(argument):
    type, value, remainder = ParseCutTerm(argument.strip())
    if type == CUTTERM_NOTHING:
        return CUTTERM_NOTHING, None, CUTTERM_NOTHING, None
    elif type == None:
        if remainder.startswith(':'):
            typeLeft = CUTTERM_NOTHING
            valueLeft = None
            remainder = remainder[1:]
        else:
            return None, None, None, None
    else:
        typeLeft = type
        valueLeft = value
        if typeLeft == CUTTERM_POSITION and valueLeft < 0:
            return None, None, None, None
        if typeLeft == CUTTERM_FIND and valueLeft[1] == 0:
            return None, None, None, None
        if remainder.startswith(':'):
            remainder = remainder[1:]
        else:
            return None, None, None, None
    type, value, remainder = ParseCutTerm(remainder)
    if type == CUTTERM_POSITION and remainder == 'l':
        return typeLeft, valueLeft, CUTTERM_LENGTH, value
    elif type == None or remainder != '':
        return None, None, None, None
    elif type == CUTTERM_FIND and value[1] == 0:
        return None, None, None, None
    else:
        return typeLeft, valueLeft, type, value

def Find(data, value, nth, startposition=-1):
    position = startposition
    while nth > 0:
        position = data.find(value, position + 1)
        if position == -1:
            return -1
        nth -= 1
    return position

def CutData(stream, cutArgument):
    if cutArgument == '':
        return [stream, None, None]

    typeLeft, valueLeft, typeRight, valueRight = ParseCutArgument(cutArgument)

    if typeLeft == None:
        return [stream, None, None]

    if typeLeft == CUTTERM_NOTHING:
        positionBegin = 0
    elif typeLeft == CUTTERM_POSITION:
        positionBegin = valueLeft
    elif typeLeft == CUTTERM_FIND:
        positionBegin = Find(stream, valueLeft[0], valueLeft[1])
        if positionBegin == -1:
            return ['', None, None]
        positionBegin += valueLeft[2]
    else:
        raise Exception("Unknown value typeLeft")

    if typeRight == CUTTERM_NOTHING:
        positionEnd = len(stream)
    elif typeRight == CUTTERM_POSITION and valueRight < 0:
        positionEnd = len(stream) + valueRight
    elif typeRight == CUTTERM_POSITION:
        positionEnd = valueRight + 1
    elif typeRight == CUTTERM_LENGTH:
        positionEnd = positionBegin + valueRight
    elif typeRight == CUTTERM_FIND:
        positionEnd = Find(stream, valueRight[0], valueRight[1], positionBegin)
        if positionEnd == -1:
            return ['', None, None]
        else:
            positionEnd += len(valueRight[0])
        positionEnd += valueRight[2]
    else:
        raise Exception("Unknown value typeRight")

    return [stream[positionBegin:positionEnd], positionBegin, positionEnd]

#-BEGINCODE cDump------------------------------------------------------------------------------------
#import binascii
#import sys
#if sys.version_info[0] >= 3:
#    from io import StringIO
#else:
#    from cStringIO import StringIO

class cDump():
    def __init__(self, data, prefix='', offset=0, dumplinelength=16):
        self.data = data
        self.prefix = prefix
        self.offset = offset
        self.dumplinelength = dumplinelength

    def HexDump(self):
        oDumpStream = self.cDumpStream(self.prefix)
        hexDump = ''
        for i, b in enumerate(self.data):
            if i % self.dumplinelength == 0 and hexDump != '':
                oDumpStream.Addline(hexDump)
                hexDump = ''
            hexDump += IFF(hexDump == '', '', ' ') + '%02X' % self.C2IIP2(b)
        oDumpStream.Addline(hexDump)
        return oDumpStream.Content()

    def CombineHexAscii(self, hexDump, asciiDump):
        if hexDump == '':
            return ''
        countSpaces = 3 * (self.dumplinelength - len(asciiDump))
        if len(asciiDump) <= self.dumplinelength / 2:
            countSpaces += 1
        return hexDump + '  ' + (' ' * countSpaces) + asciiDump

    def HexAsciiDump(self, rle=False):
        oDumpStream = self.cDumpStream(self.prefix)
        position = ''
        hexDump = ''
        asciiDump = ''
        previousLine = None
        countRLE = 0
        for i, b in enumerate(self.data):
            b = self.C2IIP2(b)
            if i % self.dumplinelength == 0:
                if hexDump != '':
                    line = self.CombineHexAscii(hexDump, asciiDump)
                    if not rle or line != previousLine:
                        if countRLE > 0:
                            oDumpStream.Addline('* %d 0x%02x' % (countRLE, countRLE * self.dumplinelength))
                        oDumpStream.Addline(position + line)
                        countRLE = 0
                    else:
                        countRLE += 1
                    previousLine = line
                position = '%08X:' % (i + self.offset)
                hexDump = ''
                asciiDump = ''
            if i % self.dumplinelength == self.dumplinelength / 2:
                hexDump += ' '
            hexDump += ' %02X' % b
            asciiDump += IFF(b >= 32 and b < 127, chr(b), '.')
        if countRLE > 0:
            oDumpStream.Addline('* %d 0x%02x' % (countRLE, countRLE * self.dumplinelength))
        oDumpStream.Addline(self.CombineHexAscii(position + hexDump, asciiDump))
        return oDumpStream.Content()

    def Base64Dump(self, nowhitespace=False):
        encoded = binascii.b2a_base64(self.data).decode().strip()
        if nowhitespace:
            return encoded
        oDumpStream = self.cDumpStream(self.prefix)
        length = 64
        for i in range(0, len(encoded), length):
            oDumpStream.Addline(encoded[0+i:length+i])
        return oDumpStream.Content()

    class cDumpStream():
        def __init__(self, prefix=''):
            self.oStringIO = StringIO()
            self.prefix = prefix

        def Addline(self, line):
            if line != '':
                self.oStringIO.write(self.prefix + line + '\n')

        def Content(self):
            return self.oStringIO.getvalue()

    @staticmethod
    def C2IIP2(data):
        if sys.version_info[0] > 2:
            return data
        else:
            return ord(data)
#-ENDCODE cDump--------------------------------------------------------------------------------------

def IfWIN32SetBinary(io):
    if sys.platform == 'win32':
        import msvcrt
        msvcrt.setmode(io.fileno(), os.O_BINARY)

#Fix for http://bugs.python.org/issue11395
def StdoutWriteChunked(data):
    if sys.version_info[0] > 2:
        if isinstance(data, str):
            sys.stdout.write(data)
        else:
            sys.stdout.buffer.write(data)
    else:
        while data != '':
            sys.stdout.write(data[0:10000])
            try:
                sys.stdout.flush()
            except IOError:
                return
            data = data[10000:]

class cVariables():
    def __init__(self, variablesstring='', separator=DEFAULT_SEPARATOR):
        self.dVariables = {}
        if variablesstring == '':
            return
        for variable in variablesstring.split(separator):
            name, value = VariableNameValue(variable)
            self.dVariables[name] = value

    def SetVariable(self, name, value):
        self.dVariables[name] = value

    def Instantiate(self, astring):
        for key, value in self.dVariables.items():
            astring = astring.replace('%' + key + '%', value)
        return astring

class cOutput():
    def __init__(self, filenameOption=None, binary=False):
        self.starttime = time.time()
        self.filenameOption = filenameOption
        self.separateFiles = False
        self.progress = False
        self.console = False
        self.head = False
        self.headCounter = 0
        self.tail = False
        self.tailQueue = []
        self.STDOUT = 'STDOUT'
        self.fOut = None
        self.oCsvWriter = None
        self.rootFilenames = {}
        self.binary = binary
        if self.binary:
            self.fileoptions = 'wb'
        else:
            self.fileoptions = 'w'
        self.dReplacements = {}

    def Replace(self, line):
        for key, value in self.dReplacements.items():
            line = line.replace(key, value)
        return line

    def Open(self, binary=False):
        if self.fOut != None:
            return

        if binary:
            self.fileoptions = 'wb'
        else:
            self.fileoptions = 'w'

        if self.filenameOption:
            if self.ParseHash(self.filenameOption):
                if not self.separateFiles and self.filename != '':
                    self.fOut = open(self.filename, self.fileoptions)
            elif self.filenameOption != '':
                self.fOut = open(self.filenameOption, self.fileoptions)
        else:
            self.fOut = self.STDOUT

    def ParseHash(self, option):
        if option.startswith('#'):
            position = self.filenameOption.find('#', 1)
            if position > 1:
                switches = self.filenameOption[1:position]
                self.filename = self.filenameOption[position + 1:]
                for switch in switches:
                    if switch == 's':
                        self.separateFiles = True
                    elif switch == 'p':
                        self.progress = True
                    elif switch == 'c':
                        self.console = True
                    elif switch == 'l':
                        pass
                    elif switch == 'g':
                        if self.filename != '':
                            extra = self.filename + '-'
                        else:
                            extra = ''
                        self.filename = '%s-%s%s.txt' % (os.path.splitext(os.path.basename(sys.argv[0]))[0], extra, self.FormatTime())
                    elif switch == 'h':
                        self.head = True
                    elif switch == 't':
                        self.tail = True
                    else:
                        return False
                return True
        return False

    @staticmethod
    def FormatTime(epoch=None):
        if epoch == None:
            epoch = time.time()
        return '%04d%02d%02d-%02d%02d%02d' % time.localtime(epoch)[0:6]

    def RootUnique(self, root):
        if not root in self.rootFilenames:
            self.rootFilenames[root] = None
            return root
        iter = 1
        while True:
            newroot = '%s_%04d' % (root, iter)
            if not newroot in self.rootFilenames:
                self.rootFilenames[newroot] = None
                return newroot
            iter += 1

    def LineSub(self, line, eol):
        line = self.Replace(line)
        self.Open()
        if self.fOut == self.STDOUT or self.console:
            try:
                print(line, end=eol)
            except UnicodeEncodeError:
                encoding = sys.stdout.encoding
                print(line.encode(encoding, errors='backslashreplace').decode(encoding), end=eol)
#            sys.stdout.flush()
        if self.fOut != self.STDOUT:
            self.fOut.write(line + '\n')
            self.fOut.flush()

    def Line(self, line, eol='\n'):
        if self.head:
            if self.headCounter < 10:
                self.LineSub(line, eol)
            elif self.tail:
                self.tailQueue = self.tailQueue[-9:] + [[line, eol]]
            self.headCounter += 1
        elif self.tail:
            self.tailQueue = self.tailQueue[-9:] + [[line, eol]]
        else:
            self.LineSub(line, eol)

    def LineTimestamped(self, line):
        self.Line('%s: %s' % (self.FormatTime(), line))

    def WriteBinary(self, data):
        self.Open(True)
        if self.fOut != self.STDOUT:
            self.fOut.write(data)
            self.fOut.flush()
        else:
            IfWIN32SetBinary(sys.stdout)
            StdoutWriteChunked(data)

    def CSVWriteRow(self, row):
        if self.oCsvWriter == None:
            self.StringIOCSV = StringIO()
#            self.oCsvWriter = csv.writer(self.fOut)
            self.oCsvWriter = csv.writer(self.StringIOCSV)
        self.oCsvWriter.writerow(row)
        self.Line(self.StringIOCSV.getvalue(), '')
        self.StringIOCSV.truncate(0)
        self.StringIOCSV.seek(0)

    def Filename(self, filename, index, total):
        self.separateFilename = filename
        if self.progress:
            if index == 0:
                eta = ''
            else:
                seconds = int(float((time.time() - self.starttime) / float(index)) * float(total - index))
                eta = 'estimation %d seconds left, finished %s ' % (seconds, self.FormatTime(time.time() + seconds))
            PrintError('%d/%d %s%s' % (index + 1, total, eta, self.separateFilename))
        if self.separateFiles and self.filename != '':
            oFilenameVariables = cVariables()
            oFilenameVariables.SetVariable('f', self.separateFilename)
            basename = os.path.basename(self.separateFilename)
            oFilenameVariables.SetVariable('b', basename)
            oFilenameVariables.SetVariable('d', os.path.dirname(self.separateFilename))
            root, extension = os.path.splitext(basename)
            oFilenameVariables.SetVariable('r', root)
            oFilenameVariables.SetVariable('ru', self.RootUnique(root))
            oFilenameVariables.SetVariable('e', extension)

            self.Close()
            self.fOut = open(oFilenameVariables.Instantiate(self.filename), self.fileoptions)

    def Close(self):
        if self.head and self.tail and len(self.tailQueue) > 0:
            self.LineSub('...', '\n')

        for line, eol in self.tailQueue:
            self.LineSub(line, eol)

        self.headCounter = 0
        self.tailQueue = []

        if self.fOut != self.STDOUT:
            self.fOut.close()
            self.fOut = None

def ToString(value):
    if isinstance(value, str):
        return value
    else:
        return str(value)

def Quote(value, separator, quote):
    value = ToString(value)
    if len(value) > 1 and value[0] == quote and value[-1] == quote:
        return value
    if separator in value or value == '':
        return quote + value + quote
    else:
        return value

def MakeCSVLine(row, separator, quote):
    return separator.join([Quote(value, separator, quote) for value in row])

class cLogfile():
    def __init__(self, keyword, comment):
        self.starttime = time.time()
        self.errors = 0
        if keyword == '':
            self.oOutput = None
        else:
            self.oOutput = cOutput('%s-%s-%s.log' % (os.path.splitext(os.path.basename(sys.argv[0]))[0], keyword, self.FormatTime()))
        self.Line('Start')
        self.Line('UTC', '%04d%02d%02d-%02d%02d%02d' % time.gmtime(time.time())[0:6])
        self.Line('Comment', comment)
        self.Line('Args', repr(sys.argv))
        self.Line('Version', __version__)
        self.Line('Python', repr(sys.version_info))
        self.Line('Platform', sys.platform)
        self.Line('CWD', repr(os.getcwd()))

    @staticmethod
    def FormatTime(epoch=None):
        if epoch == None:
            epoch = time.time()
        return '%04d%02d%02d-%02d%02d%02d' % time.localtime(epoch)[0:6]

    def Line(self, *line):
        if self.oOutput != None:
            self.oOutput.Line(MakeCSVLine((self.FormatTime(), ) + line, DEFAULT_SEPARATOR, QUOTE))

    def LineError(self, *line):
        self.Line('Error', *line)
        self.errors += 1

    def Close(self):
        if self.oOutput != None:
            self.Line('Finish', '%d error(s)' % self.errors, '%d second(s)' % (time.time() - self.starttime))
            self.oOutput.Close()

def CalculateByteStatistics(dPrevalence=None, data=None):
    averageConsecutiveByteDifference = None
    if dPrevalence == None:
        dPrevalence = {iter: 0 for iter in range(0x100)}
        sumDifferences = 0.0
        previous = None
        if len(data) > 1:
            for byte in data:
                byte = C2IIP2(byte)
                dPrevalence[byte] += 1
                if previous != None:
                    sumDifferences += abs(byte - previous)
                previous = byte
            averageConsecutiveByteDifference = sumDifferences /float(len(data)-1)
    sumValues = sum(dPrevalence.values())
    countNullByte = dPrevalence[0]
    countControlBytes = 0
    countWhitespaceBytes = 0
    countUniqueBytes = 0
    for iter in range(1, 0x21):
        if chr(iter) in string.whitespace:
            countWhitespaceBytes += dPrevalence[iter]
        else:
            countControlBytes += dPrevalence[iter]
    countControlBytes += dPrevalence[0x7F]
    countPrintableBytes = 0
    for iter in range(0x21, 0x7F):
        countPrintableBytes += dPrevalence[iter]
    countHighBytes = 0
    for iter in range(0x80, 0x100):
        countHighBytes += dPrevalence[iter]
    countHexadecimalBytes = 0
    countBASE64Bytes = 0
    for iter in range(0x30, 0x3A):
        countHexadecimalBytes += dPrevalence[iter]
        countBASE64Bytes += dPrevalence[iter]
    for iter in range(0x41, 0x47):
        countHexadecimalBytes += dPrevalence[iter]
    for iter in range(0x61, 0x67):
        countHexadecimalBytes += dPrevalence[iter]
    for iter in range(0x41, 0x5B):
        countBASE64Bytes += dPrevalence[iter]
    for iter in range(0x61, 0x7B):
        countBASE64Bytes += dPrevalence[iter]
    countBASE64Bytes += dPrevalence[ord('+')] + dPrevalence[ord('/')] + dPrevalence[ord('=')]
    entropy = 0.0
    for iter in range(0x100):
        if dPrevalence[iter] > 0:
            prevalence = float(dPrevalence[iter]) / float(sumValues)
            entropy += - prevalence * math.log(prevalence, 2)
            countUniqueBytes += 1
    return sumValues, entropy, countUniqueBytes, countNullByte, countControlBytes, countWhitespaceBytes, countPrintableBytes, countHighBytes, countHexadecimalBytes, countBASE64Bytes, averageConsecutiveByteDifference

def Unpack(format, data):
    size = struct.calcsize(format)
    result = list(struct.unpack(format, data[:size]))
    result.append(data[size:])
    return result

def InstantiateCOutput(options):
    filenameOption = None
    if options.output != '':
        filenameOption = options.output
    return cOutput(filenameOption)

def ExtractStringsASCII(data):
    regex = REGEX_STANDARD + b'{%d,}'
    return re.findall(regex % 4, data)

def ExtractStringsUNICODE(data):
    regex = b'((' + REGEX_STANDARD + b'\x00){%d,})'
    return [foundunicodestring.replace(b'\x00', b'') for foundunicodestring, dummy in re.findall(regex % 4, data)]

def ExtractStrings(data):
    return ExtractStringsASCII(data) + ExtractStringsUNICODE(data)

def DumpFunctionStrings(data):
    return b''.join([extractedstring + b'\n' for extractedstring in ExtractStrings(data)])

def GetInteger(data):
    number = 0
    multiplier = 1
    while True:
        value = struct.unpack('B', data[0:1])[0]
        data = data[1:]
        if value >= 0x80:
            add = value - 0x80
        else:
            add = value
        number += add * multiplier
        if value >= 0x80:
            multiplier *= 0x80
        else:
            break
    return number, data

dRecordTypes = {
    0: 'BrtRowHdr',
    1: 'BrtCellBlank',
    2: 'BrtCellRk',
    3: 'BrtCellError',
    4: 'BrtCellBool',
    5: 'BrtCellReal',
    6: 'BrtCellSt',
    7: 'BrtCellIsst',
    8: 'BrtFmlaString',
    9: 'BrtFmlaNum',
    10: 'BrtFmlaBool',
    11: 'BrtFmlaError',
    19: 'BrtSSTItem',
    20: 'BrtPCDIMissing',
    21: 'BrtPCDINumber',
    22: 'BrtPCDIBoolean',
    23: 'BrtPCDIError',
    24: 'BrtPCDIString',
    25: 'BrtPCDIDatetime',
    26: 'BrtPCDIIndex',
    27: 'BrtPCDIAMissing',
    28: 'BrtPCDIANumber',
    29: 'BrtPCDIABoolean',
    30: 'BrtPCDIAError',
    31: 'BrtPCDIAString',
    32: 'BrtPCDIADatetime',
    33: 'BrtPCRRecord',
    34: 'BrtPCRRecordDt',
    35: 'BrtFRTBegin',
    36: 'BrtFRTEnd',
    37: 'BrtACBegin',
    38: 'BrtACEnd',
    39: 'BrtName',
    40: 'BrtIndexRowBlock',
    42: 'BrtIndexBlock',
    43: 'BrtFont',
    44: 'BrtFmt',
    45: 'BrtFill',
    46: 'BrtBorder',
    47: 'BrtXF',
    48: 'BrtStyle',
    49: 'BrtCellMeta',
    50: 'BrtValueMeta',
    51: 'BrtMdb',
    52: 'BrtBeginFmd',
    53: 'BrtEndFmd',
    54: 'BrtBeginMdx',
    55: 'BrtEndMdx',
    56: 'BrtBeginMdxTuple',
    57: 'BrtEndMdxTuple',
    58: 'BrtMdxMbrIstr',
    59: 'BrtStr',
    60: 'BrtColInfo',
    62: 'BrtCellRString',
    64: 'BrtDVal',
    65: 'BrtSxvcellNum',
    66: 'BrtSxvcellStr',
    67: 'BrtSxvcellBool',
    68: 'BrtSxvcellErr',
    69: 'BrtSxvcellDate',
    70: 'BrtSxvcellNil',
    128: 'BrtFileVersion',
    129: 'BrtBeginSheet',
    130: 'BrtEndSheet',
    131: 'BrtBeginBook',
    132: 'BrtEndBook',
    133: 'BrtBeginWsViews',
    134: 'BrtEndWsViews',
    135: 'BrtBeginBookViews',
    136: 'BrtEndBookViews',
    137: 'BrtBeginWsView',
    138: 'BrtEndWsView',
    139: 'BrtBeginCsViews',
    140: 'BrtEndCsViews',
    141: 'BrtBeginCsView',
    142: 'BrtEndCsView',
    143: 'BrtBeginBundleShs',
    144: 'BrtEndBundleShs',
    145: 'BrtBeginSheetData',
    146: 'BrtEndSheetData',
    147: 'BrtWsProp',
    148: 'BrtWsDim',
    151: 'BrtPane',
    152: 'BrtSel',
    153: 'BrtWbProp',
    154: 'BrtWbFactoid',
    155: 'BrtFileRecover',
    156: 'BrtBundleSh',
    157: 'BrtCalcProp',
    158: 'BrtBookView',
    159: 'BrtBeginSst',
    160: 'BrtEndSst',
    161: 'BrtBeginAFilter',
    162: 'BrtEndAFilter',
    163: 'BrtBeginFilterColumn',
    164: 'BrtEndFilterColumn',
    165: 'BrtBeginFilters',
    166: 'BrtEndFilters',
    167: 'BrtFilter',
    168: 'BrtColorFilter',
    169: 'BrtIconFilter',
    170: 'BrtTop10Filter',
    171: 'BrtDynamicFilter',
    172: 'BrtBeginCustomFilters',
    173: 'BrtEndCustomFilters',
    174: 'BrtCustomFilter',
    175: 'BrtAFilterDateGroupItem',
    176: 'BrtMergeCell',
    177: 'BrtBeginMergeCells',
    178: 'BrtEndMergeCells',
    179: 'BrtBeginPivotCacheDef',
    180: 'BrtEndPivotCacheDef',
    181: 'BrtBeginPCDFields',
    182: 'BrtEndPCDFields',
    183: 'BrtBeginPCDField',
    184: 'BrtEndPCDField',
    185: 'BrtBeginPCDSource',
    186: 'BrtEndPCDSource',
    187: 'BrtBeginPCDSRange',
    188: 'BrtEndPCDSRange',
    189: 'BrtBeginPCDFAtbl',
    190: 'BrtEndPCDFAtbl',
    191: 'BrtBeginPCDIRun',
    192: 'BrtEndPCDIRun',
    193: 'BrtBeginPivotCacheRecords',
    194: 'BrtEndPivotCacheRecords',
    195: 'BrtBeginPCDHierarchies',
    196: 'BrtEndPCDHierarchies',
    197: 'BrtBeginPCDHierarchy',
    198: 'BrtEndPCDHierarchy',
    199: 'BrtBeginPCDHFieldsUsage',
    200: 'BrtEndPCDHFieldsUsage',
    201: 'BrtBeginExtConnection',
    202: 'BrtEndExtConnection',
    203: 'BrtBeginECDbProps',
    204: 'BrtEndECDbProps',
    205: 'BrtBeginECOlapProps',
    206: 'BrtEndECOlapProps',
    207: 'BrtBeginPCDSConsol',
    208: 'BrtEndPCDSConsol',
    209: 'BrtBeginPCDSCPages',
    210: 'BrtEndPCDSCPages',
    211: 'BrtBeginPCDSCPage',
    212: 'BrtEndPCDSCPage',
    213: 'BrtBeginPCDSCPItem',
    214: 'BrtEndPCDSCPItem',
    215: 'BrtBeginPCDSCSets',
    216: 'BrtEndPCDSCSets',
    217: 'BrtBeginPCDSCSet',
    218: 'BrtEndPCDSCSet',
    219: 'BrtBeginPCDFGroup',
    220: 'BrtEndPCDFGroup',
    221: 'BrtBeginPCDFGItems',
    222: 'BrtEndPCDFGItems',
    223: 'BrtBeginPCDFGRange',
    224: 'BrtEndPCDFGRange',
    225: 'BrtBeginPCDFGDiscrete',
    226: 'BrtEndPCDFGDiscrete',
    227: 'BrtBeginPCDSDTupleCache',
    228: 'BrtEndPCDSDTupleCache',
    229: 'BrtBeginPCDSDTCEntries',
    230: 'BrtEndPCDSDTCEntries',
    231: 'BrtBeginPCDSDTCEMembers',
    232: 'BrtEndPCDSDTCEMembers',
    233: 'BrtBeginPCDSDTCEMember',
    234: 'BrtEndPCDSDTCEMember',
    235: 'BrtBeginPCDSDTCQueries',
    236: 'BrtEndPCDSDTCQueries',
    237: 'BrtBeginPCDSDTCQuery',
    238: 'BrtEndPCDSDTCQuery',
    239: 'BrtBeginPCDSDTCSets',
    240: 'BrtEndPCDSDTCSets',
    241: 'BrtBeginPCDSDTCSet',
    242: 'BrtEndPCDSDTCSet',
    243: 'BrtBeginPCDCalcItems',
    244: 'BrtEndPCDCalcItems',
    245: 'BrtBeginPCDCalcItem',
    246: 'BrtEndPCDCalcItem',
    247: 'BrtBeginPRule',
    248: 'BrtEndPRule',
    249: 'BrtBeginPRFilters',
    250: 'BrtEndPRFilters',
    251: 'BrtBeginPRFilter',
    252: 'BrtEndPRFilter',
    253: 'BrtBeginPNames',
    254: 'BrtEndPNames',
    255: 'BrtBeginPName',
    256: 'BrtEndPName',
    257: 'BrtBeginPNPairs',
    258: 'BrtEndPNPairs',
    259: 'BrtBeginPNPair',
    260: 'BrtEndPNPair',
    261: 'BrtBeginECWebProps',
    262: 'BrtEndECWebProps',
    263: 'BrtBeginEcWpTables',
    264: 'BrtEndECWPTables',
    265: 'BrtBeginECParams',
    266: 'BrtEndECParams',
    267: 'BrtBeginECParam',
    268: 'BrtEndECParam',
    269: 'BrtBeginPCDKPIs',
    270: 'BrtEndPCDKPIs',
    271: 'BrtBeginPCDKPI',
    272: 'BrtEndPCDKPI',
    273: 'BrtBeginDims',
    274: 'BrtEndDims',
    275: 'BrtBeginDim',
    276: 'BrtEndDim',
    277: 'BrtIndexPartEnd',
    278: 'BrtBeginStyleSheet',
    279: 'BrtEndStyleSheet',
    280: 'BrtBeginSXView',
    281: 'BrtEndSXVI',
    282: 'BrtBeginSXVI',
    283: 'BrtBeginSXVIs',
    284: 'BrtEndSXVIs',
    285: 'BrtBeginSXVD',
    286: 'BrtEndSXVD',
    287: 'BrtBeginSXVDs',
    288: 'BrtEndSXVDs',
    289: 'BrtBeginSXPI',
    290: 'BrtEndSXPI',
    291: 'BrtBeginSXPIs',
    292: 'BrtEndSXPIs',
    293: 'BrtBeginSXDI',
    294: 'BrtEndSXDI',
    295: 'BrtBeginSXDIs',
    296: 'BrtEndSXDIs',
    297: 'BrtBeginSXLI',
    298: 'BrtEndSXLI',
    299: 'BrtBeginSXLIRws',
    300: 'BrtEndSXLIRws',
    301: 'BrtBeginSXLICols',
    302: 'BrtEndSXLICols',
    303: 'BrtBeginSXFormat',
    304: 'BrtEndSXFormat',
    305: 'BrtBeginSXFormats',
    306: 'BrtEndSxFormats',
    307: 'BrtBeginSxSelect',
    308: 'BrtEndSxSelect',
    309: 'BrtBeginISXVDRws',
    310: 'BrtEndISXVDRws',
    311: 'BrtBeginISXVDCols',
    312: 'BrtEndISXVDCols',
    313: 'BrtEndSXLocation',
    314: 'BrtBeginSXLocation',
    315: 'BrtEndSXView',
    316: 'BrtBeginSXTHs',
    317: 'BrtEndSXTHs',
    318: 'BrtBeginSXTH',
    319: 'BrtEndSXTH',
    320: 'BrtBeginISXTHRws',
    321: 'BrtEndISXTHRws',
    322: 'BrtBeginISXTHCols',
    323: 'BrtEndISXTHCols',
    324: 'BrtBeginSXTDMPS',
    325: 'BrtEndSXTDMPs',
    326: 'BrtBeginSXTDMP',
    327: 'BrtEndSXTDMP',
    328: 'BrtBeginSXTHItems',
    329: 'BrtEndSXTHItems',
    330: 'BrtBeginSXTHItem',
    331: 'BrtEndSXTHItem',
    332: 'BrtBeginMetadata',
    333: 'BrtEndMetadata',
    334: 'BrtBeginEsmdtinfo',
    335: 'BrtMdtinfo',
    336: 'BrtEndEsmdtinfo',
    337: 'BrtBeginEsmdb',
    338: 'BrtEndEsmdb',
    339: 'BrtBeginEsfmd',
    340: 'BrtEndEsfmd',
    341: 'BrtBeginSingleCells',
    342: 'BrtEndSingleCells',
    343: 'BrtBeginList',
    344: 'BrtEndList',
    345: 'BrtBeginListCols',
    346: 'BrtEndListCols',
    347: 'BrtBeginListCol',
    348: 'BrtEndListCol',
    349: 'BrtBeginListXmlCPr',
    350: 'BrtEndListXmlCPr',
    351: 'BrtListCCFmla',
    352: 'BrtListTrFmla',
    353: 'BrtBeginExternals',
    354: 'BrtEndExternals',
    355: 'BrtSupBookSrc',
    357: 'BrtSupSelf',
    358: 'BrtSupSame',
    359: 'BrtSupTabs',
    360: 'BrtBeginSupBook',
    361: 'BrtPlaceholderName',
    362: 'BrtExternSheet',
    363: 'BrtExternTableStart',
    364: 'BrtExternTableEnd',
    366: 'BrtExternRowHdr',
    367: 'BrtExternCellBlank',
    368: 'BrtExternCellReal',
    369: 'BrtExternCellBool',
    370: 'BrtExternCellError',
    371: 'BrtExternCellString',
    372: 'BrtBeginEsmdx',
    373: 'BrtEndEsmdx',
    374: 'BrtBeginMdxSet',
    375: 'BrtEndMdxSet',
    376: 'BrtBeginMdxMbrProp',
    377: 'BrtEndMdxMbrProp',
    378: 'BrtBeginMdxKPI',
    379: 'BrtEndMdxKPI',
    380: 'BrtBeginEsstr',
    381: 'BrtEndEsstr',
    382: 'BrtBeginPRFItem',
    383: 'BrtEndPRFItem',
    384: 'BrtBeginPivotCacheIDs',
    385: 'BrtEndPivotCacheIDs',
    386: 'BrtBeginPivotCacheID',
    387: 'BrtEndPivotCacheID',
    388: 'BrtBeginISXVIs',
    389: 'BrtEndISXVIs',
    390: 'BrtBeginColInfos',
    391: 'BrtEndColInfos',
    392: 'BrtBeginRwBrk',
    393: 'BrtEndRwBrk',
    394: 'BrtBeginColBrk',
    395: 'BrtEndColBrk',
    396: 'BrtBrk',
    397: 'BrtUserBookView',
    398: 'BrtInfo',
    399: 'BrtCUsr',
    400: 'BrtUsr',
    401: 'BrtBeginUsers',
    403: 'BrtEOF',
    404: 'BrtUCR',
    405: 'BrtRRInsDel',
    406: 'BrtRREndInsDel',
    407: 'BrtRRMove',
    408: 'BrtRREndMove',
    409: 'BrtRRChgCell',
    410: 'BrtRREndChgCell',
    411: 'BrtRRHeader',
    412: 'BrtRRUserView',
    413: 'BrtRRRenSheet',
    414: 'BrtRRInsertSh',
    415: 'BrtRRDefName',
    416: 'BrtRRNote',
    417: 'BrtRRConflict',
    418: 'BrtRRTQSIF',
    419: 'BrtRRFormat',
    420: 'BrtRREndFormat',
    421: 'BrtRRAutoFmt',
    422: 'BrtBeginUserShViews',
    423: 'BrtBeginUserShView',
    424: 'BrtEndUserShView',
    425: 'BrtEndUserShViews',
    426: 'BrtArrFmla',
    427: 'BrtShrFmla',
    428: 'BrtTable',
    429: 'BrtBeginExtConnections',
    430: 'BrtEndExtConnections',
    431: 'BrtBeginPCDCalcMems',
    432: 'BrtEndPCDCalcMems',
    433: 'BrtBeginPCDCalcMem',
    434: 'BrtEndPCDCalcMem',
    435: 'BrtBeginPCDHGLevels',
    436: 'BrtEndPCDHGLevels',
    437: 'BrtBeginPCDHGLevel',
    438: 'BrtEndPCDHGLevel',
    439: 'BrtBeginPCDHGLGroups',
    440: 'BrtEndPCDHGLGroups',
    441: 'BrtBeginPCDHGLGroup',
    442: 'BrtEndPCDHGLGroup',
    443: 'BrtBeginPCDHGLGMembers',
    444: 'BrtEndPCDHGLGMembers',
    445: 'BrtBeginPCDHGLGMember',
    446: 'BrtEndPCDHGLGMember',
    447: 'BrtBeginQSI',
    448: 'BrtEndQSI',
    449: 'BrtBeginQSIR',
    450: 'BrtEndQSIR',
    451: 'BrtBeginDeletedNames',
    452: 'BrtEndDeletedNames',
    453: 'BrtBeginDeletedName',
    454: 'BrtEndDeletedName',
    455: 'BrtBeginQSIFs',
    456: 'BrtEndQSIFs',
    457: 'BrtBeginQSIF',
    458: 'BrtEndQSIF',
    459: 'BrtBeginAutoSortScope',
    460: 'BrtEndAutoSortScope',
    461: 'BrtBeginConditionalFormatting',
    462: 'BrtEndConditionalFormatting',
    463: 'BrtBeginCFRule',
    464: 'BrtEndCFRule',
    465: 'BrtBeginIconSet',
    466: 'BrtEndIconSet',
    467: 'BrtBeginDatabar',
    468: 'BrtEndDatabar',
    469: 'BrtBeginColorScale',
    470: 'BrtEndColorScale',
    471: 'BrtCFVO',
    472: 'BrtExternValueMeta',
    473: 'BrtBeginColorPalette',
    474: 'BrtEndColorPalette',
    475: 'BrtIndexedColor',
    476: 'BrtMargins',
    477: 'BrtPrintOptions',
    478: 'BrtPageSetup',
    479: 'BrtBeginHeaderFooter',
    480: 'BrtEndHeaderFooter',
    481: 'BrtBeginSXCrtFormat',
    482: 'BrtEndSXCrtFormat',
    483: 'BrtBeginSXCrtFormats',
    484: 'BrtEndSXCrtFormats',
    485: 'BrtWsFmtInfo',
    486: 'BrtBeginMgs',
    487: 'BrtEndMGs',
    488: 'BrtBeginMGMaps',
    489: 'BrtEndMGMaps',
    490: 'BrtBeginMG',
    491: 'BrtEndMG',
    492: 'BrtBeginMap',
    493: 'BrtEndMap',
    494: 'BrtHLink',
    495: 'BrtBeginDCon',
    496: 'BrtEndDCon',
    497: 'BrtBeginDRefs',
    498: 'BrtEndDRefs',
    499: 'BrtDRef',
    500: 'BrtBeginScenMan',
    501: 'BrtEndScenMan',
    502: 'BrtBeginSct',
    503: 'BrtEndSct',
    504: 'BrtSlc',
    505: 'BrtBeginDXFs',
    506: 'BrtEndDXFs',
    507: 'BrtDXF',
    508: 'BrtBeginTableStyles',
    509: 'BrtEndTableStyles',
    510: 'BrtBeginTableStyle',
    511: 'BrtEndTableStyle',
    512: 'BrtTableStyleElement',
    513: 'BrtTableStyleClient',
    514: 'BrtBeginVolDeps',
    515: 'BrtEndVolDeps',
    516: 'BrtBeginVolType',
    517: 'BrtEndVolType',
    518: 'BrtBeginVolMain',
    519: 'BrtEndVolMain',
    520: 'BrtBeginVolTopic',
    521: 'BrtEndVolTopic',
    522: 'BrtVolSubtopic',
    523: 'BrtVolRef',
    524: 'BrtVolNum',
    525: 'BrtVolErr',
    526: 'BrtVolStr',
    527: 'BrtVolBool',
    530: 'BrtBeginSortState',
    531: 'BrtEndSortState',
    532: 'BrtBeginSortCond',
    533: 'BrtEndSortCond',
    534: 'BrtBookProtection',
    535: 'BrtSheetProtection',
    536: 'BrtRangeProtection',
    537: 'BrtPhoneticInfo',
    538: 'BrtBeginECTxtWiz',
    539: 'BrtEndECTxtWiz',
    540: 'BrtBeginECTWFldInfoLst',
    541: 'BrtEndECTWFldInfoLst',
    542: 'BrtBeginECTwFldInfo',
    548: 'BrtFileSharing',
    549: 'BrtOleSize',
    550: 'BrtDrawing',
    551: 'BrtLegacyDrawing',
    552: 'BrtLegacyDrawingHF',
    553: 'BrtWebOpt',
    554: 'BrtBeginWebPubItems',
    555: 'BrtEndWebPubItems',
    556: 'BrtBeginWebPubItem',
    557: 'BrtEndWebPubItem',
    558: 'BrtBeginSXCondFmt',
    559: 'BrtEndSXCondFmt',
    560: 'BrtBeginSXCondFmts',
    561: 'BrtEndSXCondFmts',
    562: 'BrtBkHim',
    564: 'BrtColor',
    565: 'BrtBeginIndexedColors',
    566: 'BrtEndIndexedColors',
    569: 'BrtBeginMRUColors',
    570: 'BrtEndMRUColors',
    572: 'BrtMRUColor',
    573: 'BrtBeginDVals',
    574: 'BrtEndDVals',
    577: 'BrtSupNameStart',
    578: 'BrtSupNameValueStart',
    579: 'BrtSupNameValueEnd',
    580: 'BrtSupNameNum',
    581: 'BrtSupNameErr',
    582: 'BrtSupNameSt',
    583: 'BrtSupNameNil',
    584: 'BrtSupNameBool',
    585: 'BrtSupNameFmla',
    586: 'BrtSupNameBits',
    587: 'BrtSupNameEnd',
    588: 'BrtEndSupBook',
    589: 'BrtCellSmartTagProperty',
    590: 'BrtBeginCellSmartTag',
    591: 'BrtEndCellSmartTag',
    592: 'BrtBeginCellSmartTags',
    593: 'BrtEndCellSmartTags',
    594: 'BrtBeginSmartTags',
    595: 'BrtEndSmartTags',
    596: 'BrtSmartTagType',
    597: 'BrtBeginSmartTagTypes',
    598: 'BrtEndSmartTagTypes',
    599: 'BrtBeginSXFilters',
    600: 'BrtEndSXFilters',
    601: 'BrtBeginSXFILTER',
    602: 'BrtEndSXFilter',
    603: 'BrtBeginFills',
    604: 'BrtEndFills',
    605: 'BrtBeginCellWatches',
    606: 'BrtEndCellWatches',
    607: 'BrtCellWatch',
    608: 'BrtBeginCRErrs',
    609: 'BrtEndCRErrs',
    610: 'BrtCrashRecErr',
    611: 'BrtBeginFonts',
    612: 'BrtEndFonts',
    613: 'BrtBeginBorders',
    614: 'BrtEndBorders',
    615: 'BrtBeginFmts',
    616: 'BrtEndFmts',
    617: 'BrtBeginCellXFs',
    618: 'BrtEndCellXFs',
    619: 'BrtBeginStyles',
    620: 'BrtEndStyles',
    625: 'BrtBigName',
    626: 'BrtBeginCellStyleXFs',
    627: 'BrtEndCellStyleXFs',
    628: 'BrtBeginComments',
    629: 'BrtEndComments',
    630: 'BrtBeginCommentAuthors',
    631: 'BrtEndCommentAuthors',
    632: 'BrtCommentAuthor',
    633: 'BrtBeginCommentList',
    634: 'BrtEndCommentList',
    635: 'BrtBeginComment',
    636: 'BrtEndComment',
    637: 'BrtCommentText',
    638: 'BrtBeginOleObjects',
    639: 'BrtOleObject',
    640: 'BrtEndOleObjects',
    641: 'BrtBeginSxrules',
    642: 'BrtEndSxRules',
    643: 'BrtBeginActiveXControls',
    644: 'BrtActiveX',
    645: 'BrtEndActiveXControls',
    646: 'BrtBeginPCDSDTCEMembersSortBy',
    648: 'BrtBeginCellIgnoreECs',
    649: 'BrtCellIgnoreEC',
    650: 'BrtEndCellIgnoreECs',
    651: 'BrtCsProp',
    652: 'BrtCsPageSetup',
    653: 'BrtBeginUserCsViews',
    654: 'BrtEndUserCsViews',
    655: 'BrtBeginUserCsView',
    656: 'BrtEndUserCsView',
    657: 'BrtBeginPcdSFCIEntries',
    658: 'BrtEndPCDSFCIEntries',
    659: 'BrtPCDSFCIEntry',
    660: 'BrtBeginListParts',
    661: 'BrtListPart',
    662: 'BrtEndListParts',
    663: 'BrtSheetCalcProp',
    664: 'BrtBeginFnGroup',
    665: 'BrtFnGroup',
    666: 'BrtEndFnGroup',
    667: 'BrtSupAddin',
    668: 'BrtSXTDMPOrder',
    669: 'BrtCsProtection',
    671: 'BrtBeginWsSortMap',
    672: 'BrtEndWsSortMap',
    673: 'BrtBeginRRSort',
    674: 'BrtEndRRSort',
    675: 'BrtRRSortItem',
    676: 'BrtFileSharingIso',
    677: 'BrtBookProtectionIso',
    678: 'BrtSheetProtectionIso',
    679: 'BrtCsProtectionIso',
    680: 'BrtRangeProtectionIso',
    681: 'BrtDValList',
    1024: 'BrtRwDescent',
    1025: 'BrtKnownFonts',
    1026: 'BrtBeginSXTupleSet',
    1027: 'BrtEndSXTupleSet',
    1028: 'BrtBeginSXTupleSetHeader',
    1029: 'BrtEndSXTupleSetHeader',
    1030: 'BrtSXTupleSetHeaderItem',
    1031: 'BrtBeginSXTupleSetData',
    1032: 'BrtEndSXTupleSetData',
    1033: 'BrtBeginSXTupleSetRow',
    1034: 'BrtEndSXTupleSetRow',
    1035: 'BrtSXTupleSetRowItem',
    1036: 'BrtNameExt',
    1037: 'BrtPCDH14',
    1038: 'BrtBeginPCDCalcMem14',
    1039: 'BrtEndPCDCalcMem14',
    1040: 'BrtSXTH14',
    1041: 'BrtBeginSparklineGroup',
    1042: 'BrtEndSparklineGroup',
    1043: 'BrtSparkline',
    1044: 'BrtSXDI14',
    1045: 'BrtWsFmtInfoEx14',
    1046: 'BrtBeginConditionalFormatting14',
    1047: 'BrtEndConditionalFormatting14',
    1048: 'BrtBeginCFRule14',
    1049: 'BrtEndCFRule14',
    1050: 'BrtCFVO14',
    1051: 'BrtBeginDatabar14',
    1052: 'BrtBeginIconSet14',
    1053: 'BrtDVal14',
    1054: 'BrtBeginDVals14',
    1055: 'BrtColor14',
    1056: 'BrtBeginSparklines',
    1057: 'BrtEndSparklines',
    1058: 'BrtBeginSparklineGroups',
    1059: 'BrtEndSparklineGroups',
    1061: 'BrtSXVD14',
    1062: 'BrtBeginSxView14',
    1063: 'BrtEndSxView14',
    1064: 'BrtBeginSXView16',
    1065: 'BrtEndSXView16',
    1066: 'BrtBeginPCD14',
    1067: 'BrtEndPCD14',
    1068: 'BrtBeginExtConn14',
    1069: 'BrtEndExtConn14',
    1070: 'BrtBeginSlicerCacheIDs',
    1071: 'BrtEndSlicerCacheIDs',
    1072: 'BrtBeginSlicerCacheID',
    1073: 'BrtEndSlicerCacheID',
    1075: 'BrtBeginSlicerCache',
    1076: 'BrtEndSlicerCache',
    1077: 'BrtBeginSlicerCacheDef',
    1078: 'BrtEndSlicerCacheDef',
    1079: 'BrtBeginSlicersEx',
    1080: 'BrtEndSlicersEx',
    1081: 'BrtBeginSlicerEx',
    1082: 'BrtEndSlicerEx',
    1083: 'BrtBeginSlicer',
    1084: 'BrtEndSlicer',
    1085: 'BrtSlicerCachePivotTables',
    1086: 'BrtBeginSlicerCacheOlapImpl',
    1087: 'BrtEndSlicerCacheOlapImpl',
    1088: 'BrtBeginSlicerCacheLevelsData',
    1089: 'BrtEndSlicerCacheLevelsData',
    1090: 'BrtBeginSlicerCacheLevelData',
    1091: 'BrtEndSlicerCacheLevelData',
    1092: 'BrtBeginSlicerCacheSiRanges',
    1093: 'BrtEndSlicerCacheSiRanges',
    1094: 'BrtBeginSlicerCacheSiRange',
    1095: 'BrtEndSlicerCacheSiRange',
    1096: 'BrtSlicerCacheOlapItem',
    1097: 'BrtBeginSlicerCacheSelections',
    1098: 'BrtSlicerCacheSelection',
    1099: 'BrtEndSlicerCacheSelections',
    1100: 'BrtBeginSlicerCacheNative',
    1101: 'BrtEndSlicerCacheNative',
    1102: 'BrtSlicerCacheNativeItem',
    1103: 'BrtRangeProtection14',
    1104: 'BrtRangeProtectionIso14',
    1105: 'BrtCellIgnoreEC14',
    1111: 'BrtList14',
    1112: 'BrtCFIcon',
    1113: 'BrtBeginSlicerCachesPivotCacheIDs',
    1114: 'BrtEndSlicerCachesPivotCacheIDs',
    1115: 'BrtBeginSlicers',
    1116: 'BrtEndSlicers',
    1117: 'BrtWbProp14',
    1118: 'BrtBeginSXEdit',
    1119: 'BrtEndSXEdit',
    1120: 'BrtBeginSXEdits',
    1121: 'BrtEndSXEdits',
    1122: 'BrtBeginSXChange',
    1123: 'BrtEndSXChange',
    1124: 'BrtBeginSXChanges',
    1125: 'BrtEndSXChanges',
    1126: 'BrtSXTupleItems',
    1128: 'BrtBeginSlicerStyle',
    1129: 'BrtEndSlicerStyle',
    1130: 'BrtSlicerStyleElement',
    1131: 'BrtBeginStyleSheetExt14',
    1132: 'BrtEndStyleSheetExt14',
    1133: 'BrtBeginSlicerCachesPivotCacheID',
    1134: 'BrtEndSlicerCachesPivotCacheID',
    1135: 'BrtBeginConditionalFormattings',
    1136: 'BrtEndConditionalFormattings',
    1137: 'BrtBeginPCDCalcMemExt',
    1138: 'BrtEndPCDCalcMemExt',
    1139: 'BrtBeginPCDCalcMemsExt',
    1140: 'BrtEndPCDCalcMemsExt',
    1141: 'BrtPCDField14',
    1142: 'BrtBeginSlicerStyles',
    1143: 'BrtEndSlicerStyles',
    1144: 'BrtBeginSlicerStyleElements',
    1145: 'BrtEndSlicerStyleElements',
    1146: 'BrtCFRuleExt',
    1147: 'BrtBeginSXCondFmt14',
    1148: 'BrtEndSXCondFmt14',
    1149: 'BrtBeginSXCondFmts14',
    1150: 'BrtEndSXCondFmts14',
    1152: 'BrtBeginSortCond14',
    1153: 'BrtEndSortCond14',
    1154: 'BrtEndDVals14',
    1155: 'BrtEndIconSet14',
    1156: 'BrtEndDatabar14',
    1157: 'BrtBeginColorScale14',
    1158: 'BrtEndColorScale14',
    1159: 'BrtBeginSxrules14',
    1160: 'BrtEndSxrules14',
    1161: 'BrtBeginPRule14',
    1162: 'BrtEndPRule14',
    1163: 'BrtBeginPRFilters14',
    1164: 'BrtEndPRFilters14',
    1165: 'BrtBeginPRFilter14',
    1166: 'BrtEndPRFilter14',
    1167: 'BrtBeginPRFItem14',
    1168: 'BrtEndPRFItem14',
    1169: 'BrtBeginCellIgnoreECs14',
    1170: 'BrtEndCellIgnoreECs14',
    1171: 'BrtDxf14',
    1172: 'BrtBeginDxF14s',
    1173: 'BrtEndDxf14s',
    1177: 'BrtFilter14',
    1178: 'BrtBeginCustomFilters14',
    1180: 'BrtCustomFilter14',
    1181: 'BrtIconFilter14',
    1182: 'BrtPivotCacheConnectionName',
    2048: 'BrtBeginDecoupledPivotCacheIDs',
    2049: 'BrtEndDecoupledPivotCacheIDs',
    2050: 'BrtDecoupledPivotCacheID',
    2051: 'BrtBeginPivotTableRefs',
    2052: 'BrtEndPivotTableRefs',
    2053: 'BrtPivotTableRef',
    2054: 'BrtSlicerCacheBookPivotTables',
    2055: 'BrtBeginSxvcells',
    2056: 'BrtEndSxvcells',
    2057: 'BrtBeginSxRow',
    2058: 'BrtEndSxRow',
    2060: 'BrtPcdCalcMem15',
    2067: 'BrtQsi15',
    2068: 'BrtBeginWebExtensions',
    2069: 'BrtEndWebExtensions',
    2070: 'BrtWebExtension',
    2071: 'BrtAbsPath15',
    2072: 'BrtBeginPivotTableUISettings',
    2073: 'BrtEndPivotTableUISettings',
    2075: 'BrtTableSlicerCacheIDs',
    2076: 'BrtTableSlicerCacheID',
    2077: 'BrtBeginTableSlicerCache',
    2078: 'BrtEndTableSlicerCache',
    2079: 'BrtSxFilter15',
    2080: 'BrtBeginTimelineCachePivotCacheIDs',
    2081: 'BrtEndTimelineCachePivotCacheIDs',
    2082: 'BrtTimelineCachePivotCacheID',
    2083: 'BrtBeginTimelineCacheIDs',
    2084: 'BrtEndTimelineCacheIDs',
    2085: 'BrtBeginTimelineCacheID',
    2086: 'BrtEndTimelineCacheID',
    2087: 'BrtBeginTimelinesEx',
    2088: 'BrtEndTimelinesEx',
    2089: 'BrtBeginTimelineEx',
    2090: 'BrtEndTimelineEx',
    2091: 'BrtWorkBookPr15',
    2092: 'BrtPCDH15',
    2093: 'BrtBeginTimelineStyle',
    2094: 'BrtEndTimelineStyle',
    2095: 'BrtTimelineStyleElement',
    2096: 'BrtBeginTimelineStylesheetExt15',
    2097: 'BrtEndTimelineStylesheetExt15',
    2098: 'BrtBeginTimelineStyles',
    2099: 'BrtEndTimelineStyles',
    2100: 'BrtBeginTimelineStyleElements',
    2101: 'BrtEndTimelineStyleElements',
    2102: 'BrtDxf15',
    2103: 'BrtBeginDxfs15',
    2104: 'BrtEndDXFs15',
    2105: 'BrtSlicerCacheHideItemsWithNoData',
    2106: 'BrtBeginItemUniqueNames',
    2107: 'BrtEndItemUniqueNames',
    2108: 'BrtItemUniqueName',
    2109: 'BrtBeginExtConn15',
    2110: 'BrtEndExtConn15',
    2111: 'BrtBeginOledbPr15',
    2112: 'BrtEndOledbPr15',
    2113: 'BrtBeginDataFeedPr15',
    2114: 'BrtEndDataFeedPr15',
    2115: 'BrtTextPr15',
    2116: 'BrtRangePr15',
    2117: 'BrtDbCommand15',
    2118: 'BrtBeginDbTables15',
    2119: 'BrtEndDbTables15',
    2120: 'BrtDbTable15',
    2121: 'BrtBeginDataModel',
    2122: 'BrtEndDataModel',
    2123: 'BrtBeginModelTables',
    2124: 'BrtEndModelTables',
    2125: 'BrtModelTable',
    2126: 'BrtBeginModelRelationships',
    2127: 'BrtEndModelRelationships',
    2128: 'BrtModelRelationship',
    2129: 'BrtBeginECTxtWiz15',
    2130: 'BrtEndECTxtWiz15',
    2131: 'BrtBeginECTWFldInfoLst15',
    2132: 'BrtEndECTWFldInfoLst15',
    2133: 'BrtBeginECTWFldInfo15',
    2134: 'BrtFieldListActiveItem',
    2135: 'BrtPivotCacheIdVersion',
    2136: 'BrtSXDI15',
    2137: 'BrtBeginModelTimeGroupings',
    2138: 'BrtEndModelTimeGroupings',
    2139: 'BrtBeginModelTimeGrouping',
    2140: 'BrtEndModelTimeGrouping',
    2141: 'BrtModelTimeGroupingCalcCol',
    3072: 'BrtUID', # https://social.msdn.microsoft.com/Forums/azure/en-US/880eb3f3-395a-4097-ad01-8e0878d0b436/xlsb-brtuid-record-type-not-defined?forum=os_binaryfile
    3073: 'BrtRevisionPtr',
    4096: 'BrtBeginDynamicArrayPr',
    4097: 'BrtEndDynamicArrayPr',
    5002: 'BrtBeginRichValueBlock',
    5003: 'BrtEndRichValueBlock',
    5081: 'BrtBeginRichFilters',
    5082: 'BrtEndRichFilters',
    5083: 'BrtRichFilter',
    5084: 'BrtBeginRichFilterColumn',
    5085: 'BrtEndRichFilterColumn',
    5086: 'BrtBeginCustomRichFilters',
    5087: 'BrtEndCustomRichFilters',
    5088: 'BRTCustomRichFilter',
    5089: 'BrtTop10RichFilter',
    5090: 'BrtDynamicRichFilter',
    5092: 'BrtBeginRichSortCondition',
    5093: 'BrtEndRichSortCondition',
    5094: 'BrtRichFilterDateGroupItem',
    5095: 'BrtBeginCalcFeatures',
    5096: 'BrtEndCalcFeatures',
    5097: 'BrtCalcFeature',
    5099: 'BrtExternalLinksPr',
}

def XLWideStr(data):
    size = struct.unpack('<I', data[:4])[0]
    data = data[4:]
    data = data[:size * 2]
    return data.decode('utf16')

def RichStr(data):
    return XLWideStr(data[1:])

def ProcessBinaryFile(filename, content, cutexpression, flag, oOutput, oLogfile, options, oParserFlag):
    if content == None:
        try:
            oBinaryFile = cBinaryFile(filename, C2BIP3(options.password), options.noextraction, options.literalfilenames)
        except:
            oLogfile.LineError('Opening file %s %s' % (filename, repr(sys.exc_info()[1])))
            return
        oLogfile.Line('Success', 'Opening file %s' % filename)
        try:
            data = oBinaryFile.read()
        except:
            oLogfile.LineError('Reading file %s %s' % (filename, repr(sys.exc_info()[1])))
            return
        data = CutData(data, cutexpression)[0]
        oBinaryFile.close()
    else:
        data = content

    (flagoptions, flagargs) = oParserFlag.parse_args(flag.split(' '))

    try:
        # ----- Put your data processing code here -----
        oOutput.Line('File: %s' % (filename))
        index = 1
        while len(data) > 0:
            recordType, data = GetInteger(data)
            recordSize, data = GetInteger(data)
            if recordSize > 0:
                recordData = data[:recordSize]
                data = data[recordSize:]
            else:
                recordData = b''
            recordTypeString = dRecordTypes.get(recordType, 'NOTFOUND(%d)' % recordType)
            line = '%3d: %s: %s' % (index, recordTypeString, recordSize)
            if recordTypeString in ['BrtFmlaString']:
                line = line + ' ' + XLWideStr(recordData[8:])
            elif recordTypeString in ['BrtSxvcellStr']:
                line = line + ' ' + repr(DumpFunctionStrings(recordData))
            elif recordTypeString in ['BrtSSTItem']:
                line = line + ' ' + RichStr(recordData)
            oOutput.Line(line)
            index += 1
#            oOutput.Line(cDump(data[0:0x100]).HexAsciiDump())
        # ----------------------------------------------
    except:
        oLogfile.LineError('Processing file %s %s' % (filename, repr(sys.exc_info()[1])))
        if not options.ignoreprocessingerrors:
            raise

#    data = CutData(cBinaryFile(filename, C2BIP3(options.password), options.noextraction, options.literalfilenames).Data(), cutexpression)[0]

def ProcessBinaryFiles(filenames, oLogfile, options, oParserFlag):
    oOutput = InstantiateCOutput(options)
    index = 0
    if options.jsoninput:
        items = CheckJSON(sys.stdin.read())
        if items == None:
            return
        for item in items:
            oOutput.Filename(item['name'], index, len(items))
            index += 1
            ProcessBinaryFile(item['name'], item['content'], '', '', oOutput, oLogfile, options, oParserFlag)
    else:
        for filename, cutexpression, flag in filenames:
            oOutput.Filename(filename, index, len(filenames))
            index += 1
            ProcessBinaryFile(filename, None, cutexpression, flag, oOutput, oLogfile, options, oParserFlag)

def Main():
    moredesc = '''

Source code put in the public domain by Didier Stevens, no Copyright
Use at your own risk
https://DidierStevens.com'''

    oParserFlag = optparse.OptionParser(usage='\nFlag arguments start with #f#:')
    oParserFlag.add_option('-l', '--length', action='store_true', default=False, help='Print length of files')

    oParser = optparse.OptionParser(usage='usage: %prog [options] [[@]file|cut-expression|flag-expression ...]\n' + __description__ + moredesc, version='%prog ' + __version__, epilog='This tool also accepts flag arguments (#f#), read the man page (-m) for more info.')
    oParser.add_option('-m', '--man', action='store_true', default=False, help='Print manual')
    oParser.add_option('-o', '--output', type=str, default='', help='Output to file (# supported)')
    oParser.add_option('-p', '--password', default='infected', help='The ZIP password to be used (default infected)')
    oParser.add_option('-n', '--noextraction', action='store_true', default=False, help='Do not extract from archive file')
    oParser.add_option('-l', '--literalfilenames', action='store_true', default=False, help='Do not interpret filenames')
    oParser.add_option('-r', '--recursedir', action='store_true', default=False, help='Recurse directories (wildcards and here files (@...) allowed)')
    oParser.add_option('--checkfilenames', action='store_true', default=False, help='Perform check if files exist prior to file processing')
    oParser.add_option('-j', '--jsoninput', action='store_true', default=False, help='Consume JSON from stdin')
    oParser.add_option('--logfile', type=str, default='', help='Create logfile with given keyword')
    oParser.add_option('--logcomment', type=str, default='', help='A string with comments to be included in the log file')
    oParser.add_option('--ignoreprocessingerrors', action='store_true', default=False, help='Ignore errors during file processing')
    (options, args) = oParser.parse_args()

    if options.man:
        oParser.print_help()
        oParserFlag.print_help()
        PrintManual()
        return

    if len(args) != 0 and options.jsoninput:
        print('Error: option -j can not be used with files')
        return

    oLogfile = cLogfile(options.logfile, options.logcomment)
    oExpandFilenameArguments = cExpandFilenameArguments(args, options.literalfilenames, options.recursedir, options.checkfilenames, '#c#', '#f#')
    oLogfile.Line('FilesCount', str(len(oExpandFilenameArguments.Filenames())))
    oLogfile.Line('Files', repr(oExpandFilenameArguments.Filenames()))
    if oExpandFilenameArguments.warning:
        PrintError('\nWarning:')
        PrintError(oExpandFilenameArguments.message)
        oLogfile.Line('Warning', repr(oExpandFilenameArguments.message))

    ProcessBinaryFiles(oExpandFilenameArguments.Filenames(), oLogfile, options, oParserFlag)

    if oLogfile.errors > 0:
        PrintError('Number of errors: %d' % oLogfile.errors)
    oLogfile.Close()

if __name__ == '__main__':
    Main()