How to use the pyexcel.get_book_dict function in pyexcel

To help you get started, we’ve selected a few pyexcel examples, based on popular ways it is used in public projects.

Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.

github pyexcel-webwares / Flask-Excel / tests / test_database_io.py View on Github external
datetime(2015, 1, 20, 23, 28, 30), "Sports"]
            ]
        }
        for upload_file_type in ['xls']:
            with app.app_context():
                db.drop_all()
                db.create_all()
            print("Uploading %s" % upload_file_type)
            file_name = "test.%s" % upload_file_type
            io = pe.save_book_as(bookdict=data,
                                 dest_file_type=upload_file_type)
            response = self.app.post('/upload/all',
                                     buffered=True,
                                     data={"file": (io, file_name)},
                                     content_type="multipart/form-data")
            ret = pe.get_book_dict(file_type="xls", file_content=response.data)
            self.assertEqual(data['category'], ret['category'])
            sheet = pe.Sheet(data['post'], name_columns_by_row=0)
            sheet.column.format("pub_date", lambda d: d.isoformat())
            sheet2 = pe.Sheet(ret['post'], name_columns_by_row=0)
            for key in sheet.colnames:
                if key == "category":
                    continue
                assert sheet.column[key] == sheet2.column[key]
            assert sheet2.column['category_id'] == [1, 2]
github pyexcel / pyexcel / tests / test_signature_fuction.py View on Github external
def test_save_book_to_memory_from_sql(self):
        test_file = pe.save_book_as(
            dest_file_type="xls",
            session=Session(),
            tables=[Signature, Signature2],
        )
        book_dict = pe.get_book_dict(
            file_content=test_file.getvalue(), file_type="xls"
        )
        expected = OrderedDict()
        expected.update({"signature": [["X", "Y", "Z"], [1, 2, 3], [4, 5, 6]]})
        expected.update(
            {"signature2": [["A", "B", "C"], [1, 2, 3], [4, 5, 6]]}
        )
        assert book_dict == expected
github patarapolw / pyexcel-export / tests / test_save_data.py View on Github external
def test_update_classic(in_file, test_file, out_file, request):
    in_file = test_file(in_file)

    assert isinstance(in_file, Path)

    shutil.copy(str(in_file.absolute()), str(out_file(out_base=request.node.name, out_format=".xlsx").absolute()))

    data = pyexcel.get_book_dict(file_name=str(in_file.absolute()))
    debugger_logger.debug(data)

    data['TagDict'].append([
        'new rosai-dorfman disease',
        '''Typically massive lymph node involvement that may also involve extranodal sites
Associated with systemic symptoms (fever, leukocytosis, anemia)
Large histiocytes with abundant pale eosinophilic cytoplasm, mildly atypical round
vesicular nuclei
Lymphocytophagocytosis (emperipolesis) in background of mature lymphocytes and
plasma cells''',
        '“Dorfman disease” emperipolesis, HNB'
    ])

    pyexcel_export.save_data(out_file(out_base=request.node.name, out_format=".xlsx", do_overwrite=True), data)
github pyexcel / pyexcel-xlsx / tests / test_bug_fixes.py View on Github external
def test_issue_8_hidden_sheet():
    test_file = get_fixtures("hidden_sheets.xlsx")
    book_dict = pe.get_book_dict(file_name=test_file,
                                 library="pyexcel-xlsx")
    assert "hidden" not in book_dict
    eq_(book_dict['shown'], [['A', 'B']])
github pyexcel / pyexcel / tests / test_signature_fuction.py View on Github external
def test_get_book_dict(self):
        content = _produce_ordered_dict()
        io = pe.save_book_as(dest_file_type="xls", bookdict=content)
        adict = pe.get_book_dict(file_content=io.getvalue(), file_type="xls")
        assert adict == content
github pyexcel / pyexcel / tests / test_signature_fuction.py View on Github external
def test_save_book_as_file_from_sql(self):
        test_file = "book_from_sql.xls"
        pe.save_book_as(
            dest_file_name=test_file,
            session=Session(),
            tables=[Signature, Signature2],
        )
        book_dict = pe.get_book_dict(file_name=test_file)
        expected = OrderedDict()
        expected.update({"signature": [["X", "Y", "Z"], [1, 2, 3], [4, 5, 6]]})
        expected.update(
            {"signature2": [["A", "B", "C"], [1, 2, 3], [4, 5, 6]]}
        )
        assert book_dict == expected
        os.unlink(test_file)
github usc-isi-i2 / t2wml / Code / utility_functions.py View on Github external
def excel_to_json(file_path: str, sheet_name: str = None, want_sheet_names: bool = False) -> dict:
    """
    This function reads the excel file and converts it to JSON
    :param file_path:
    :param sheet_name:
    :param want_sheet_names:
    :return:
    """
    sheet_data = {'columnDefs': [{'headerName': "", 'field': "^", 'pinned': "left"}], 'rowData': []}
    column_index_map = {}
    result = dict()
    if not sheet_name or want_sheet_names:
        result['sheetNames'] = list()
        book_dict = pyexcel.get_book_dict(file_name=file_path)
        for sheet in book_dict.keys():
            result['sheetNames'].append(sheet)
        if not sheet_name:
            sheet_name = result['sheetNames'][0]
    else:
        result["sheetNames"] = None
    result["currSheetName"] = sheet_name
    add_row_in_data_file(file_path, sheet_name)
    book = pyexcel.get_book(file_name=file_path)
    sheet = book[sheet_name]
    for i in range(len(sheet[0])):
        column = get_column_letter(i + 1)
        column_index_map[i + 1] = column
        sheet_data['columnDefs'].append({'headerName': column_index_map[i + 1], 'field': column_index_map[i + 1]})
    for row in range(len(sheet)):
        r = {'^': str(row + 1)}
github pyexcel-webwares / pyexcel-webio / pyexcel_webio / __init__.py View on Github external
def get_book_dict(self, **keywords):
        """Get a dictionary of two dimensional array from the file

        :param keywords: additional key words
        :returns: A dictionary of two dimensional arrays
        """
        params = self.get_params(**keywords)
        return pe.get_book_dict(**params)
github patarapolw / pyexcel-export / pyexcel_export / app.py View on Github external
def _load_pyexcel_xlsx(self):
        updated_data = pyexcel.get_book_dict(file_name=str(self.in_file.absolute()))
        self.meta.setdefault('_styles', dict())['excel'] = ExcelFormatter(self.in_file).data

        return self._set_updated_data(updated_data)