Export to excel

[Andrew Sackville-West]

On Mon, May 31, 2010 at 05:47:49PM -0400, Anthony Dardis wrote:
> I just requested an Account Report within one of my accounts, then
> Export, saved the file with an .html extension, then opened it in
> Excel. Looks perfect and useful. (OS X 10.5)

I typically do something like this:

html2text -nobs <filename> | sed -e 's/\> \</_/g; s/,//g; s/\$//g; s/\> /,/g; s/ //g; s/,$//; s/=//g' > filename.csv

to the html export and it generates a reasonably usable csv file. Note
that I effectively just pasted this in from a script that wraps that
in some other stuff, so I can't speak to the quality of the
output... not sure when I last used it.

A
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20100531/4dd2e004/attachment.bin>