Report format conversion to Excel

[muraliambt]

Hi all,

I am using FPW 2.6a.

How can i convert the report format ( exactly the same way it appears in screen preview ) to Excel.

I can conver to excel using COPY TO command but it is converting exactly the same as the structur of the table.

I need to include all the format which is there in the report.

I will need full guide on how to do this.

currently what i am doing is.
sele temp ( cursor )
copy to temp type xls

Thanks in advance.

Rgds,
Murali.

 

[rgbean]

Murali,
Even VFP 8.0 beta doesn't have this capability. In FPW, the best you can do use DDE to "write" the data to Excel, but it's all new code, and some of Excel's capabilities are lost to DDE, and automation isn't available in FPW (it's a 32-bit technology).

There are some 3rd party report writers that might be able to provide you this capability, but again you'll have to re-write these reports. (Look at Crystall Report, R&R Report Writer, FoxFire! and StoneField Query, to name just a few of the more popular that work with FoxPro tables.)

Rick

 

[muraliambt]

Thanks rgbean,

murali.