Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: anand kulkarni
  Where is anand kulkarni?
 sholapur
 India
 anand kulkarni
 To: Shaheryar Rashed
  Where is Shaheryar Rashed?
 Multan
 Pakistan
 Shaheryar Rashed
 Tags
Subject: RE: Foxy Previewer
Thread ID: 325699 Message ID: 325729 # Views: 32 # Ratings: 1
Version: Visual FoxPro 6 Category: Reports and Printers
Date: Friday, October 28, 2011 1:00:48 PM         
   


> >
> > HI
> >
> > use this
> >
> >
> >
> > lPath="c:\temp\Report"+".txt"
> > REPORT FORM test TO FILE  &lPath ASCII noreset
> > oxL.Workbooks.Open(lpath)
> > oActiveSheet = oxL.ActiveSheet
> > oActiveSheet.Name = "MyData"
> > oActiveSheet.columns(1).font.name="Courier New"
> > oActiveSheet.columns(1).font.size=10
> > oActiveSheet.columns(1).select 
> > oxL.Application.CommandBars.ActiveMenuBar.Controls("Data").Controls("Text to Columns...").Execute
> > oActiveSheet.cells.entirecolumn.autofit
> > oxL.visible = .T.
> > 
> > 

> >
> >
> > Thanks & Regards
> > Manoj Patel
> Hi Manoj!
> finally i added following code:
> lPath="d:\Ledger"+".txt"
> REPORT FORM led_double_en.frx TO FILE &lPath ASCII &&&noreset
> oxL=CREATEOBJECT('excel.application')
> oxL.Workbooks.Open(lpath)
> oActiveSheet = oxL.ActiveSheet
> oActiveSheet.Name = "MyData"
>
> oActiveSheet.columns(1).font.name="Arial"
> oActiveSheet.columns(1).font.size=10
> oActiveSheet.columns(1).select
> oxL.Application.CommandBars.ActiveMenuBar.Controls("Data").Controls("Text to Columns...").Execute
> oActiveSheet.cells.entirecolumn.autofit
> oxL.visible = .T.
> preview result is as below:
>

>
>
>
>
>
>
>
> and excel file views as below:
>
>
> give me more sudgestions

hi Shaheryar rashed
i think dont use lines,spacing in the report then you will get the same convert in excel ! , while converting it can't consider lines or graphical things in excel
it converts only data ! :)


rgards
Anand S. Kulkarni

When it rains ... all Birds occupy shelter , but Eagle is the only bird with its capacity to fly over the sky to avoid rains !!!

COMPLETE THREAD

Foxy Previewer Posted by SHAHERYAR RASHED @ 10/28/2011 8:25:33 AM
RE: Foxy Previewer Posted by Anil Sharma @ 10/28/2011 8:33:00 AM
RE: Foxy Previewer Posted by SHAHERYAR RASHED @ 10/28/2011 8:42:12 AM
RE: Foxy Previewer Posted by Manoj Patel @ 10/28/2011 8:45:30 AM
RE: Foxy Previewer Posted by SHAHERYAR RASHED @ 10/28/2011 9:20:12 AM
RE: Foxy Previewer Posted by Manoj Patel @ 10/28/2011 10:28:43 AM
RE: Foxy Previewer Posted by SHAHERYAR RASHED @ 10/28/2011 10:43:01 AM
RE: Foxy Previewer Posted by SHAHERYAR RASHED @ 10/28/2011 10:45:30 AM
RE: Foxy Previewer Posted by Manoj Patel @ 10/28/2011 10:48:42 AM
RE: Foxy Previewer Posted by SHAHERYAR RASHED @ 10/28/2011 10:53:09 AM
RE: Foxy Previewer Posted by Manoj Patel @ 10/28/2011 11:11:43 AM
RE: Foxy Previewer Posted by SHAHERYAR RASHED @ 10/28/2011 11:23:50 AM
RE: Foxy Previewer Posted by Manoj Patel @ 10/28/2011 11:41:34 AM
RE: Foxy Previewer Posted by SHAHERYAR RASHED @ 10/28/2011 11:45:55 AM
RE: Foxy Previewer Posted by anand kulkarni @ 10/28/2011 1:00:48 PM
RE: Foxy Previewer Posted by Manoj Patel @ 10/28/2011 1:25:24 PM
RE: Foxy Previewer Posted by SHAHERYAR RASHED @ 10/28/2011 1:37:08 PM
RE: Foxy Previewer Posted by anand kulkarni @ 10/28/2011 10:17:24 AM