FrontAccounting forum — Export to Excel / CSV

Re: Export to Excel / CSV

null@example.com (t2webby) — Fri, 27 Feb 2009 17:40:48 +0000

Ya this looks to be pretty good Joe! I agree that for moving to the XBRML standard this is probably a good choice.

Re: Export to Excel / CSV

null@example.com (joe) — Fri, 27 Feb 2009 10:42:56 +0000

Personly, I don't like the PEAR approach. I have been looking at a SF project called Excel Writer (XML) for PHP.
This is was they claim:

Set of classes for PHP that allow Excel XML files to be generated dynamically. Nearly a full implementation of the MS XML architecture. Requires PHP 5+ Does not require any XML libraries

It is very small and elegant. It is written in PHP 5.0 but as it is very small it is easy to fix so it runs in both 4 and 5.
It creates XML files, which of course is a good thing, especially for the XBRML standard. A standard for Accounting applications. This implementation is also for the future.
And it is easy to later create a class like pdf_report.inc, where similar routines are created. Then we only have to switch to the right include pdf_report or excel_report.
This is what I think we should do.
I will do some further research on this one. Please have a look and comment on this.

/Joe

Re: Export to Excel / CSV

null@example.com (itronics) — Thu, 26 Feb 2009 22:13:34 +0000

I haven't know this one, interesting thing. I was also thinking about integration of some lighter solution available on SF.net.
Janusz

Re: Export to Excel / CSV

null@example.com (t2webby) — Thu, 26 Feb 2009 20:45:59 +0000

Best to adopt the pear component http://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.php

It does wonders

Re: Export to Excel / CSV

null@example.com (itronics) — Mon, 23 Feb 2009 06:38:02 +0000

Not to be done before final 2.1 release. Probably this will be addressed in 2.2 release, or even some next 2.1.x issues.
Janusz

Re: Export to Excel / CSV

null@example.com (MozMan) — Sun, 22 Feb 2009 18:01:27 +0000

I second that notion. Big time.

I think it might already be in progress?
https://frontaccounting.com/wbt/pages/products/the-future.php

Export to Excel / CSV

null@example.com (t2webby) — Wed, 18 Feb 2009 20:13:31 +0000

Would be handy in the future be able to export reports to excel / CSV electronic forms instead of just PDF. Eg. Balance Sheets, GL, etc.