Example #1
0
    ~~~~~~~~~~~~~~~~~~~
    The lower level ods file format handler using odfpy
    :copyright: (c) 2015-2017 by Onni Software Ltd & its contributors
    :license: New BSD License
"""
# flake8: noqa
# this line has to be place above all else
# because of dynamic import
from pyexcel_io.plugins import IOPluginInfoChain
from pyexcel_io.io import get_data as read_data, isstream, store_data as write_data

__FILE_TYPE__ = 'ods'
IOPluginInfoChain(__name__).add_a_reader(
    relative_plugin_class_path='odsr.ODSBook',
    file_types=[__FILE_TYPE__],
    stream_type='binary').add_a_writer(
        relative_plugin_class_path='odsw.ODSWriter',
        file_types=[__FILE_TYPE__],
        stream_type='binary')


def save_data(afile, data, file_type=None, **keywords):
    """standalone module function for writing module supported file type"""
    if isstream(afile) and file_type is None:
        file_type = __FILE_TYPE__
    write_data(afile, data, file_type=file_type, **keywords)


def get_data(afile, file_type=None, **keywords):
    """standalone module function for reading module supported file type"""
    if isstream(afile) and file_type is None:
Example #2
0
"""
    pyexcel_xlsxw
    ~~~~~~~~~~~~~~~~~~~

    The lower level xlsx file format writer using xlsxwriter

    :copyright: (c) 2016 by Onni Software Ltd & its contributors
    :license: New BSD License
"""
# flake8: noqa
# this line has to be place above all else
# because of dynamic import
from pyexcel_io.plugins import IOPluginInfoChain
from pyexcel_io.io import get_data as read_data, isstream, store_data as write_data

__FILE_TYPE__ = 'xlsx'
IOPluginInfoChain(__name__).add_a_writer(
    relative_plugin_class_path='xlsxw.XLSXWriter',
    file_types=[__FILE_TYPE__],
    stream_type='binary')


def save_data(afile, data, file_type=None, **keywords):
    """standalone module function for writing module supported file type"""
    if isstream(afile) and file_type is None:
        file_type = __FILE_TYPE__
    write_data(afile, data, file_type=file_type, **keywords)
Example #3
0
"""
    pyexcel_io.readers
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    file readers

    :copyright: (c) 2014-2017 by Onni Software Ltd.
    :license: New BSD License, see LICENSE for more details
"""
from pyexcel_io.plugins import IOPluginInfoChain


IOPluginInfoChain(__name__).add_a_reader(
    relative_plugin_class_path='csvr.CSVBookReader',
    file_types=['csv'],
    stream_type='text'
).add_a_reader(
    relative_plugin_class_path='tsv.TSVBookReader',
    file_types=['tsv'],
    stream_type='text'
).add_a_reader(
    relative_plugin_class_path='csvz.CSVZipBookReader',
    file_types=['csvz'],
    stream_type='binary'
).add_a_reader(
    relative_plugin_class_path='tsvz.TSVZipBookReader',
    file_types=['tsvz'],
    stream_type='binary'
)
"""
    pyexcel_io.database
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    database data importer and exporter

    :copyright: (c) 2014-2017 by Onni Software Ltd.
    :license: New BSD License, see LICENSE for more details
"""
from pyexcel_io.plugins import IOPluginInfoChain
from pyexcel_io.constants import DB_DJANGO, DB_SQL


IOPluginInfoChain(__name__).add_a_reader(
    relative_plugin_class_path="exporters.django.DjangoBookReader",
    file_types=[DB_DJANGO],
).add_a_reader(
    relative_plugin_class_path="exporters.sqlalchemy.SQLBookReader",
    file_types=[DB_SQL],
).add_a_writer(
    relative_plugin_class_path="importers.django.DjangoBookWriter",
    file_types=[DB_DJANGO],
).add_a_writer(
    relative_plugin_class_path="importers.sqlalchemy.SQLBookWriter",
    file_types=[DB_SQL],
)
Example #5
0
"""
    pyexcel_odsw
    ~~~~~~~~~~~~~~~~~~~
    The lower level ods file format handler
    :copyright: (c) 2018 by Onni Software & its contributors
    :license: New BSD License
"""
from pyexcel_io.io import isstream
from pyexcel_io.io import store_data as write_data
from pyexcel_io.plugins import IOPluginInfoChain

from ._version import __author__, __version__  # flake8: noqa

__FILE_TYPE__ = "ods"

IOPluginInfoChain(__name__).add_a_writer(
    relative_plugin_class_path="odsw.ODSWriter",
    file_types=[__FILE_TYPE__],
    stream_type="binary",
)


def save_data(afile, data, file_type=None, **keywords):
    """standalone module function for writing module supported file type"""
    if isstream(afile) and file_type is None:
        file_type = __FILE_TYPE__
    write_data(afile, data, file_type=file_type, **keywords)
Example #6
0
    :copyright: (c) 2015-2017 by Onni Software Ltd & its contributors
    :license: New BSD License
"""
from pyexcel_io.plugins import IOPluginInfoChain
from pyexcel_io.io import (
    get_data as read_data,
    isstream,
    save_data as write_data,
)

__FILE_TYPE__ = "xlsx"
IOPluginInfoChain(__name__).add_a_reader(
    relative_plugin_class_path="xlsxr.XLSXBook",
    file_types=[__FILE_TYPE__, "xlsm"],
    stream_type="binary",
).add_a_writer(
    relative_plugin_class_path="xlsxw.XLSXWriter",
    file_types=[__FILE_TYPE__, "xlsm"],
    stream_type="binary",
)


def save_data(afile, data, file_type=None, **keywords):
    """standalone module function for writing module supported file type"""
    if isstream(afile) and file_type is None:
        file_type = __FILE_TYPE__
    write_data(afile, data, file_type=file_type, **keywords)


def get_data(afile, file_type=None, **keywords):
    """standalone module function for reading module supported file type"""
Example #7
0
"""
    pyexcel_io.writers
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    file writers

    :copyright: (c) 2014-2017 by Onni Software Ltd.
    :license: New BSD License, see LICENSE for more details
"""
from pyexcel_io.plugins import IOPluginInfoChain

IOPluginInfoChain(__name__).add_a_writer(
    relative_plugin_class_path="csvw.CSVBookWriter",
    file_types=["csv"],
    stream_type="text",
).add_a_writer(
    relative_plugin_class_path="tsv.TSVBookWriter",
    file_types=["tsv"],
    stream_type="text",
).add_a_writer(
    relative_plugin_class_path="csvz.CSVZipBookWriter",
    file_types=["csvz"],
    stream_type="binary",
).add_a_writer(
    relative_plugin_class_path="tsvz.TSVZipBookWriter",
    file_types=["tsvz"],
    stream_type="binary",
)
    The lower level ods file format handler using odfpy
    :copyright: (c) 2015-2020 by Onni Software Ltd & its contributors
    :license: New BSD License
"""

# flake8: noqa
from pyexcel_io.io import get_data as read_data
from pyexcel_io.io import isstream
from pyexcel_io.io import store_data as write_data

# this line has to be place above all else
# because of dynamic import
from pyexcel_io.plugins import IOPluginInfoChain, IOPluginInfoChainV2

__FILE_TYPE__ = "ods"
IOPluginInfoChain(__name__)
IOPluginInfoChainV2(__name__).add_a_reader(
    relative_plugin_class_path="odsr.ODSBook",
    locations=["file", "memory"],
    file_types=[__FILE_TYPE__],
    stream_type="binary",
).add_a_reader(
    relative_plugin_class_path="odsr.ODSBookInContent",
    locations=["content"],
    file_types=[__FILE_TYPE__],
    stream_type="binary",
).add_a_writer(
    relative_plugin_class_path="odsw.ODSWriter",
    locations=["file", "memory"],
    file_types=[__FILE_TYPE__],
    stream_type="binary",
    The lower level xls/xlsx/xlsm file format handler using xlrd/xlwt

    :copyright: (c) 2016-2017 by Onni Software Ltd
    :license: New BSD License
"""
# flake8: noqa
# this line has to be place above all else
# because of dynamic import
from pyexcel_io.plugins import IOPluginInfoChain
from pyexcel_io.io import get_data as read_data, isstream, store_data as write_data

__FILE_TYPE__ = 'xls'
IOPluginInfoChain(__name__).add_a_reader(
    relative_plugin_class_path='xlsr.XLSBook',
    file_types=[__FILE_TYPE__, 'xlsx', 'xlsm'],
    stream_type='binary').add_a_writer(
        relative_plugin_class_path='xlsw.XLSWriter',
        file_types=[__FILE_TYPE__],
        stream_type='binary')


def get_data(afile, file_type=None, **keywords):
    """standalone module function for reading module supported file type"""
    if isstream(afile) and file_type is None:
        file_type = __FILE_TYPE__
    return read_data(afile, file_type=file_type, **keywords)


def save_data(afile, data, file_type=None, **keywords):
    """standalone module function for writing module supported file type"""
    if isstream(afile) and file_type is None:
Example #10
0
    :copyright: (c) 2015-2017 by Onni Software Ltd & its contributors
    :license: New BSD License
"""
from pyexcel_io.plugins import IOPluginInfoChain
from pyexcel_io.io import (get_data as read_data, isstream, store_data as
                           write_data)

__FILE_TYPE__ = 'xlsx'
IOPluginInfoChain(__name__).add_a_reader(
    relative_plugin_class_path='xlsxr.XLSXBook',
    file_types=[__FILE_TYPE__, 'xlsm'],
    stream_type='binary').add_a_writer(
        relative_plugin_class_path='xlsxw.XLSXWriter',
        file_types=[__FILE_TYPE__],
        stream_type='binary').add_a_reader(
            relative_plugin_class_path='csvr.CSVBook',
            file_types=['csv', 'tsv', 'txt', 'gz', 'bz2', 'zip', 'xz'],
            stream_type='binary').add_a_writer(
                relative_plugin_class_path='csvw.CSVWriter',
                file_types=['csv', 'txt', 'tsv', 'gz', 'bz2', 'zip', 'xz'],
                stream_type='binary')


def save_data(afile, data, file_type=None, **keywords):
    """standalone module function for writing module supported file type"""
    if isstream(afile) and file_type is None:
        file_type = __FILE_TYPE__
    write_data(afile, data, file_type=file_type, **keywords)