From: Cetin Basoz
To: Phillip Davies
Visual FoxPro 9 SP2
Projects and Design
Thursday, March 21, 2013 3:01:15 PM
This message was rated by:
> 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
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.
.Net has got better.
Think about moving - check my blog:
MongoDb Certified Developer
MongoDb Certified DBA
Posted by Phillip Davies @ 3/21/2013 2:26:27 PM
Posted by Cetin Basoz @ 3/21/2013 3:01:15 PM
Posted by Phillip Davies @ 3/21/2013 8:45:13 PM
Posted by Anders Altberg @ 3/21/2013 9:20:37 PM
Posted by Cetin Basoz @ 3/21/2013 10:17:07 PM
Posted by Phillip Davies @ 3/21/2013 11:49:04 PM