Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: Phillip Davies
  Where is Phillip Davies?
 TRURO
 United Kingdom
 Phillip Davies
 Tags
Subject: RE: XLS
Thread ID: 373355 Message ID: 373357 # Views: 61 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Projects and Design
Date: Thursday, March 21, 2013 3:01:15 PM         
   


> I need to write a program that produces an XLSX sheet with over 1000 columns from a DBF file
> so e.g. 1200 rows in a DBF table become 1200 columns in an XLSX sheet
>
>
>
> Before I start, does anyone have any advice or wisdom in terms of methodology
>
>
> Many Thanks
>
> Phillip

Phillip,
That might be easier than you think but you need to give us more info. What type of row/column translation would be needed? Is that a pivot table? If it is, you can do that in very few lines of code.

You can also transfer the data as row/col just in VFP and than transpose rows/cols.

IOW to give more specific idea, can you give us a very small model of data you have and the result you need.



Cetin Basoz

.Net has got better.Think about moving - check my blog:
My Blog


MongoDb Certified Developer
MongoDb Certified DBA


Support Wikipedia

ENTIRE THREAD

XLS Posted by Phillip Davies @ 3/21/2013 2:26:27 PM
RE: XLS Posted by Cetin Basoz @ 3/21/2013 3:01:15 PM
RE: XLS Posted by Phillip Davies @ 3/21/2013 8:45:13 PM
RE: XLS Posted by Anders Altberg @ 3/21/2013 9:20:37 PM
RE: XLS Posted by Cetin Basoz @ 3/21/2013 10:17:07 PM
RE: XLS Posted by Phillip Davies @ 3/21/2013 11:49:04 PM