6 examples of 'read xlsb file in python' in Python

8
def read(self):
9
    workbook = self.open_workbook()
10
    worksheet = self.get_worksheet(workbook)
11
12
    data = self.extract_data(worksheet)
13
    data = data[self.options.get('skip', 0):]
14
15
    headers = self.options.get('headers', True)
16
    if headers is True:
17
        headers, data = data[0], data[1:]
18
    if headers:
19
        return [dict(zip(headers, row)) for row in data]
20
    else:
21
        return data

34
def read_excel_file(f):
35
    dialect = csv.Sniffer().sniff(codecs.EncodedFile(f, "utf-8").read(1024))
36
    #f.open()
37
    return UnicodeCsvReader(codecs.EncodedFile(f, "utf-8"),
38
                            "utf-8", dialect=dialect)

81
def parse_workbook(self):
82
    raise NotImplementedError

29
def load_workbook(self, filepath_or_buffer):
30
    from xlrd import open_workbook
31
32
    if hasattr(filepath_or_buffer, "read"):
33
        data = filepath_or_buffer.read()
34
        return open_workbook(file_contents=data)
35
    else:
36
        return open_workbook(filepath_or_buffer)

90
def open_content(self, file_content, skip_hidden_sheets=True, **keywords):
91
    self._keywords = keywords
92
    self._file_content = file_content
93
    self.__skip_hidden_sheets = skip_hidden_sheets

20
def test_xls_with_sheet(self):
21
    with open('examples/sheets.xls', 'rb') as f:
22
        output = xls.xls2csv(f, sheet='data')
23
24
    with open('examples/testxls_converted.csv', 'r') as f:
25
        self.assertEquals(f.read(), output)