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: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 Tags
Subject: RE: How to create ExcelListener?(report to XLS)
Thread ID: 104152 Message ID: 104429 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Wednesday, August 16, 2006 1:34:34 PM         
   


dear BZ Dusk
does the end user have excel installed? if not then this is not going to work.
> What will happens if the End user doesn't have Excel installed?
>
>
> > what i am saying is that u dont exit from the visual foxpro software to create the excel file
> > u first create the html file
> > then in vfp create an excel object
> > then do
> > excelobject.open(the html file you created)
> > and excelobject.saveas( excel file)
> > then you can erase the html file and the end user never even knows that there was an html step involved.
> >
> > > > 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.

> > >
> > > Excel is set to open files with extension XLS etc. If you double click on a HTM or HTML file usually it will open in your default browser and NOT excel. This is the obvious reason for renaming the file. Of course excel can open it and it can also open files with extension TXT but that is not the extension associated with an Excel file.

>
>
>
> Borislav Borissov
>
>


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