Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: M. Akram Bhatti
  Where is M. Akram Bhatti?
 Riyadh
 Saudi Arabia
 M. Akram Bhatti
 To: Raju S
  Where is Raju S?
 Mumbai
 India
 Raju S
 Tags
Subject: RE: export to excel
Thread ID: 228386 Message ID: 228455 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Active X Controls & OLE Automation
Date: Tuesday, May 19, 2009 7:03:38 AM         
   


> Hi Experts,
>
> I have an excel sheet where some formulas are put and heading is in 1st row. Formulas are also put in totals row.
>
> Now I want to export data to this sheet in a way that the alignment, formulas, totals remain as they are.
>
> Is it possible ?
>
> Thanks everyone.

You should open the excel sheet using Automation commands. Make object of "Excel.Application" class, and by referencing cells you can simply write your data. In this way you will not loose your formatting plus formulas.

Regards,
Akram

ENTIRE THREAD

export to excel Posted by Raju S @ 5/18/2009 5:46:07 PM
RE: export to excel Posted by Vincent Byrne @ 5/18/2009 7:55:46 PM
RE: export to excel Posted by M. Akram Bhatti @ 5/19/2009 7:03:38 AM