def table_loading(reduced=True, type='html', full_path=None):
# Load database
df = Devis.load_db()
table_man = TableLoader(Devis.l_index, Devis.l_fields(), limit=10, type=type)
if type == 'excel':
# Get processed table
df = table_man.load_full_table(df)
# Save excel file
writer = pd.ExcelWriter(full_path, engine='xlsxwriter')
df.to_excel(writer, sheet_name='Feuille1', index=False)
writer.save()
return
if reduced:
df, kwargs = table_man.load_reduce_table(df)
d_footer = None
else:
table_man = TableLoader(Devis.l_index, Devis.l_fields())
df, d_footer, kwargs = table_man.load_full_table(df)
return df, d_footer, kwargs
def table_loading(type='html'):
# Load database
df = Affaire.load_db()
table_man = TableLoader(Affaire.l_index,
Affaire.l_fields(),
limit=10,
type=type)
df, kwargs = table_man.load_reduce_table(df)
d_footer = None
return df, d_footer, kwargs