def get_sheet(self, file_name, sheet_name):
sig = file_name, sheet_name
if sig not in self.sheet_cache:
logger.info("sheet %s not in cache")
table = Table()
table.build_from_sheet(file_name, sheet_name)
self.sheet_cache[sig] = table
return self.sheet_cache[sig]
def get_sheet(self, file_name, sheet_name):
sig = file_name, sheet_name
if sig not in self.sheet_cache:
logger.info("sheet %s not in cache")
table = Table()
table.build_from_sheet(file_name, sheet_name)
self.sheet_cache[sig] = table
return self.sheet_cache[sig]
self.parts.append(indent)
self.parts.append(")")
def dump_element(self, e, level):
if type(e) in CONTAINER:
self.dump_list(e, level)
elif type(e) is unicode:
self.dump_unicode(e, level)
else:
self.dump_basic(e, level)
def write_file(self):
body = "".join(self.parts)
if self.module_name is None:
print(body)
return
file_path = self.get_tmp_path(self.module_name)
file_dir = os.path.dirname(file_path)
if not os.path.exists(file_dir):
os.makedirs(file_dir)
with open(file_path, "w") as target:
target.write(body)
if __name__ == "__main__":
from excel2data.table import Table
t = Table()
t.build_from_sheet(u"../test_input/调试.xlsx", u"一些例子")
t.key_column = 0
exp = PyExporter(None, t)
exp.run()
self.parts.append(indent)
self.parts.append(")")
def dump_element(self, e, level):
if type(e) in CONTAINER:
self.dump_list(e, level)
elif type(e) is unicode:
self.dump_unicode(e, level)
else:
self.dump_basic(e, level)
def write_file(self):
body = "".join(self.parts)
if self.module_name is None:
print(body)
return
file_path = self.get_tmp_path(self.module_name)
file_dir = os.path.dirname(file_path)
if not os.path.exists(file_dir):
os.makedirs(file_dir)
with open(file_path, "w") as target:
target.write(body)
if __name__ == "__main__":
from excel2data.table import Table
t = Table()
t.build_from_sheet(u"../test_input/调试.xlsx", u"一些例子")
t.key_column = 0
exp = PyExporter(None, t)
exp.run()
