Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yousfi Benameur
  Where is Yousfi Benameur?
 El Bayadh
 Algeria
 Yousfi Benameur
 To: Amol Pawar
  Where is Amol Pawar?
 Nasik
 India
 Amol Pawar
 Tags
Subject: RE: Send Report In Excel
Thread ID: 188958 Message ID: 189009 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Reports and Printers
Date: Tuesday, August 12, 2008 11:38:49 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

Hi
I make recently a program but with vfp9 to send a report to excel (or html) but i dont know if it works with vfp8
adapt the folders and the name report.
 clea all
SET DEFAULT TO "c:\program files\microsoft visual foxpro 9\samples\solution\"
USE ADDBS(HOME()) + 'Samples\Northwind\Orders'

loListener = .NULL.
do (_reportoutput) with 5, loListener
loListener.TargetFileName = 'MyReport.xls'   &&'myReport.html
loListener.QuietMode      = .T.
afile='c:\program files\microsoft visual foxpro 9\samples\solution\europa\EmployeesMD.FRX'
report form (afile)   object loListener  
use

&&show the result in Excel
DECLARE INTEGER ShellExecute IN shell32.dll ; 
  INTEGER hndWin, STRING cAction, STRING cFileName, ; 
  STRING cParams, STRING cDir, INTEGER nShowWin
  af='c:\program files\microsoft visual foxpro 9\samples\solution\MyReport.xls'
ShellExecute(0,"open",af,"","",1)

if not done for vfp8:
If you can send a report to html (see _genhtml in foxhelp) you can then open it as a web page by excel and can save it as excel.

regards
Yousfi benameur

ENTIRE THREAD

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