Export to Excel

[Davey Benson]

Thanks for all the helpful replies.


Brian Kaney wrote:
> 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
>
>
>