Export to Excel

[Brian Kaney]

Cam Ellison wrote:
> Davey Benson wrote:
>   
>> Hi
>>
>> My accountant uses Excel. Can I export to .xls and if so how? Sorry if 
>> the answer is blatantly obvious :)
>>     
>
> It's not that obvious.  Create the report you want.  Export it - it will 
> become an HTML page.  Load the page in your browser, copy all (Ctrl-A, 
> Ctrl-C), then Paste Special (that's the critical part) it into an 
> OpenOffice.Org spreadsheet.  Save that as a .xls.
>
> Cheers
>
> Cam
>
>   

Here's another quick thing to try...  Excel (and OO) can also read in 
simple HTML, including tables.  So you may want to try to open the HTML 
report right into Excel or OO (make sure to specify the file type as 
HTML when opening).  Then save as xls.


Good Luck,
Brian