Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Barbara Peisch
  Where is Barbara Peisch?
 California - United States
 Barbara Peisch
 To: Amol Pawar
  Where is Amol Pawar?
 Amol Pawar
Subject: RE: Send Report In Excel
Thread ID: 188958 Message ID: 188980 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Reports and Printers
Date: Tuesday, August 12, 2008 9:08:07 PM         

> Hi Experts,
> I am trying to send report in excel.
> i follow 2 types for send report in excel
> 1 ) Frx2any
> I am not Satisfied . Because that report data can't come in excel row format
> 2 ) OLEcontrol.
> I am write a program to direct accessing in Microsoft Excel , that was sucess .
> but utility work only for one Table.
> Means I send my foxpro table data in Excel.
> But i wan't Send Report in to the Excel . in Excel Column Format
> Can u help me any body.
> Regards
> Amol Pawar

As Cathy says, XFRX can output to Excel, however, I find the format very unsatisfactory. The reason is that if you have any columns that overlap, like headings often do, then you get multiple columns in the result.

I've found the best way to export to excel is to use EXPORT to get the data into the spreadsheet, and then use automation to manipulate things the way I want them to look.



Send Report In Excel Posted by Amol Pawar @ 8/12/2008 7:28:51 PM
RE: Send Report In Excel Posted by Cathy Pountney @ 8/12/2008 7:42:20 PM
RE: Send Report In Excel Posted by Barbara Peisch @ 8/12/2008 9:08:07 PM
RE: Send Report In Excel Posted by Yousfi Benameur @ 8/12/2008 11:38:49 PM
RE: Send Report In Excel Posted by Barbara Peisch @ 8/13/2008 12:02:50 AM