Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: Bernard Bout
  Where is Bernard Bout?
 Brisbane
 Australia
 Bernard Bout
 Tags
Subject: RE: How to create ExcelListener?(report to XLS)
Thread ID: 104152 Message ID: 104247 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Monday, August 14, 2006 8:58:39 AM         
   


i dont think a renaming of extension is necessary. Excel should open an html file directly. so should word. then you use office automation to save it as a doc or xls file using saveas
create xlobject
xlobject.open ( html file)
xlobject.saveas( excel file)

saveas has a parameter in which you give the format to save it in. choose excel workbook to get your excel file.
same procedure for word should work
> > Hi!
> >
> > How can I convert my reports to excel using Reportoutput and ReportListener of vfp9? I've seen vfp 9 samples of converting reports to html and xml format but there is no excel listener type. Does anyone was able to do an excellistener?
> >
> >
> > thanks

>
> What tushar means is that Excel can open and read a HTML file. So what you do is send your output to a HTML file but name it with a XLS extension - MyReport.XLS rather than MyReport.HTML. This way you just double click and open the file in Excel.


ENTIRE THREAD

How to create ExcelListener?(report to XLS) Posted by BZ Dusk @ 8/12/2006 5:42:50 AM
RE: How to create ExcelListener?(report to XLS) Posted by tushar @ 8/12/2006 1:24:36 PM
RE: How to create ExcelListener?(report to XLS) Posted by Bernard Bout @ 8/13/2006 3:53:00 AM
RE: How to create ExcelListener?(report to XLS) Posted by Adam Nurrohman @ 8/14/2006 3:58:48 AM
RE: How to create ExcelListener?(report to XLS) Posted by tushar @ 8/14/2006 8:58:39 AM
RE: How to create ExcelListener?(report to XLS) Posted by Bernard Bout @ 8/15/2006 8:03:13 AM
RE: How to create ExcelListener?(report to XLS) Posted by tushar @ 8/15/2006 5:51:29 PM
RE: How to create ExcelListener?(report to XLS) Posted by Borislav Borissov @ 8/15/2006 5:55:38 PM
RE: How to create ExcelListener?(report to XLS) Posted by Bernard Bout @ 8/16/2006 4:57:01 AM
RE: How to create ExcelListener?(report to XLS) Posted by tushar @ 8/16/2006 1:34:34 PM
RE: How to create ExcelListener?(report to XLS) Posted by BZ Dusk @ 8/23/2006 4:10:02 AM