示例#1
0
            return XLSXSheetWriter(self.native_book,
                                   self.native_book.create_sheet(), name)

    def close(self):
        """
        This call actually save the file
        """
        self.native_book.save(filename=self.file)


READERS.update({
    "xlsm": XLSXBook,
    "xlsx": XLSXBook
})
WRITERS.update({
    "xlsm": XLSXWriter,
    "xlsx": XLSXWriter
})

def save_data(afile, data, file_type=None, **keywords):
    if isstream(afile) and file_type is None:
        file_type='xlsx'
    write_data(afile, data, file_type=file_type, **keywords)


def get_data(afile, file_type=None, **keywords):
    if isstream(afile) and file_type is None:
        file_type='xlsx'
    return read_data(afile, file_type=file_type, **keywords)

示例#2
0
    def write(self, sheet_dicts):
        if self.keywords.get('single_sheet_in_book', False):
            keys = list(sheet_dicts.keys())
            sheet = self.create_sheet(keys[0])
            sheet.write_array(sheet_dicts[keys[0]])
            sheet.close()
        else:
            import json
            self.f.write(json.dumps(sheet_dicts))

    def create_sheet(self, name):
        return JsonSheetWriter(self.f, name)

    def close(self):
        TextWriter.close(self)


WRITERS.update({
    "simple": TextWriter,
    "plain": TextWriter,
    "grid": TextWriter,
    "pipe": TextWriter,
    "orgtbl": TextWriter,
    "rst": TextWriter,
    "mediawiki": TextWriter,
    "latex": TextWriter,
    "latex_booktabs": TextWriter,
    "json": JsonWriter
})
示例#3
0
    def close(self):
        """
        This call actually save the file
        """
        self.wb.save(self.file)


READERS.update({
    "xls": XLBook,
    "xlsm": XLBook,
    "xlsx": XLBook
})


WRITERS.update({
    "xls": XLWriter
})


def get_data(afile, file_type=None, **keywords):
    if isstream(afile) and file_type is None:
        file_type='xls'
    return read_data(afile, file_type=file_type, **keywords)


def save_data(afile, data, file_type=None, **keywords):
    if isstream(afile) and file_type is None:
        file_type='xls'
    write_data(afile, data, file_type=file_type, **keywords)

示例#4
0
                           encoding=encoding)

    def create_sheet(self, name):
        """Create a xlwt writer"""
        return XLSheetWriter(self.wb, None, name)

    def close(self):
        """
        This call actually save the file
        """
        self.wb.save(self.file)


READERS.update({"xls": XLBook, "xlsm": XLBook, "xlsx": XLBook})

WRITERS.update({"xls": XLWriter})


def get_data(afile, file_type=None, **keywords):
    if isstream(afile) and file_type is None:
        file_type = 'xls'
    return read_data(afile, file_type=file_type, **keywords)


def save_data(afile, data, file_type=None, **keywords):
    if isstream(afile) and file_type is None:
        file_type = 'xls'
    write_data(afile, data, file_type=file_type, **keywords)


__VERSION__ = "0.0.8"