Link to home
Start Free TrialLog in
Avatar of Eduardo Fuerte
Eduardo FuerteFlag for Brazil

asked on

Could you point a way or possibly free tool you ever know to convert a complex report FRT to an Excell sheet?

Hi Experts

Could you point a way or possibly free  tool you ever know to convert a complex report FRT to an Excell sheet?

By complex I mean, accordingly with the picture, data for 03 diferent DBF(s)

User generated image
So by using:

Copy Fields Desp, Tp_mv, Val1, Val2, Val3, Val4, Val5, Val6, Val7, Val8, Val9, Val10   To (n_cx) Type Xl5

Open in new window


Doesn't solve the entire needs.

Thanks in advance!
Avatar of jrbbldr
jrbbldr

Apparently you already have VFP.   That's good since it already gives you a 'free' tool to create the Excel file as you want/need..
That tool is VFP Automation of Excel.  

By using VFP's Automation you can write your data to the Excel file directly cell-by-cell and put anything else into the Excel file you want.
Sure it may not be quick-and-easy to write all of your Automation code, but it works very well and it is 'free' for owners of VFP.

From the web you can get many examples of VFP Automation of Excel.

Good Luck
Avatar of Eduardo Fuerte

ASKER

Hi

I had used VFP automation before, a very impredictable and time consuming operation....
SOLUTION
Avatar of jrbbldr
jrbbldr

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi

Since I  avoid VFP automation as I could due its impredictable behavour my option was to do an UNION between the tables.