diff options
Diffstat (limited to 'python/report_ops')
| -rw-r--r-- | python/report_ops/cash.py | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/python/report_ops/cash.py b/python/report_ops/cash.py index ddf6d180..3d2ddab2 100644 --- a/python/report_ops/cash.py +++ b/python/report_ops/cash.py @@ -132,8 +132,12 @@ class SeleneScotiaCashReport( ): def to_db(self): p = self.get_cash_report() - df = pd.read_excel(p) - return + df = pd.read_excel(p, skipfooter=1) + self.stage_from_row( + ((int(df.loc[0]["Account"]), df.loc[0]["Curr."]), df.loc[0]["Closing Bal."]) + ) + self.commit() + self._staging_queue.clear() def get_cash_report(self, prefix=None): self.download_reports(self.date) |