Page 1 of 1
Reports in Excel
Posted: Thu Feb 08, 2018 10:13 pm
by frankieorabona
There is a way to export reports into excel?
Re: Reports in Excel
Posted: Sun Feb 11, 2018 6:45 pm
by Nikolay
Excel can read HTML
Re: Reports in Excel
Posted: Mon Feb 12, 2018 8:53 pm
by frankieorabona
Nikolay wrote:Excel can read HTML
When I export the reports in HTML MMEX give me only a blank page...
Re: Reports in Excel
Posted: Tue Feb 20, 2018 12:06 pm
by Nikolay
I can't reproduce this.
Re: Reports in Excel
Posted: Sat Jun 30, 2018 6:36 pm
by mikhailo2608il
frankieorabona wrote:Nikolay wrote:Excel can read HTML
When I export the reports in HTML MMEX give me only a blank page...
When I export the report in HTML from MMEX I get a 0 byte Chrome HTML Document presumably because chrome is my default browser. And this empty file cannot be propertly imported into Excel.
However if I right mouse click into the Report output and select Properties I can view an Address (URL) field and if I copied the file path that is given there into Excel it inputs the Report output just fine. file:///C:/Users/admin/AppData/Local/Temp/MoneyManagerEx_admin_tmp/index.html is an example file path.
So the problem is that the Export to HTML option under the File menu is not properly copying the file referred to in the Properties from within the Report window.
Re: Reports in Excel
Posted: Fri Nov 16, 2018 10:51 pm
by hocko
I use Libreoffice Calc and when I right click anywhere in the report there is an option "Export to Microsoft Excel". When I click this it opens excel.
My fix was:
When you run the report in MMEX it produces an index.html file in C:\Users\"username"\AppData\Local\Temp\MoneyManagerEx_lct01_tmp
This can be dragged into Calc
The amount column can be copied and pasted as unformatted text after removing the commer in 1,000’s
All good!
Re: Reports in Excel
Posted: Thu May 23, 2019 3:19 pm
by ccabanil
mikhailo2608il wrote:frankieorabona wrote:Nikolay wrote:Excel can read HTML
When I export the reports in HTML MMEX give me only a blank page...
When I export the report in HTML from MMEX I get a 0 byte Chrome HTML Document presumably because chrome is my default browser. And this empty file cannot be propertly imported into Excel.
However if I right mouse click into the Report output and select Properties I can view an Address (URL) field and if I copied the file path that is given there into Excel it inputs the Report output just fine. file:///C:/Users/admin/AppData/Local/Temp/MoneyManagerEx_admin_tmp/index.html is an example file path.
So the problem is that the Export to HTML option under the File menu is not properly copying the file referred to in the Properties from within the Report window.
Podrías explicar como haces esto, ya que compre una computadora nueva y reinstale Money Manager y me pasa esto mismo, ya he revisado el foro y nada no hay manera Incluso en el otro ordenador me aparecía si pulsaba el botón derecho encima un menú donde podía exportar directamente a excel.