Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with columns with long info in Excel
Message
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01152063
Message ID:
01152138
Views:
29
>>What is the maximum for the Excel column's width?
>>
>Looks like it could not be done using DBF4 format. Is where a simple way to save other formats into DBF without knowing data structure in advance?
>
>Thanks in advance.

I was thinking of using the other formats (TAB delimited, probably). Create the original table with the fields of 250 chars each and append from TAB Delimited. But it looks a bit involved and convoluted.

May be I'm missing some options in SaveAs method?

Or do you have any more ideas?

UPDATE. I was able to make some progress using this:
if 	.columns[m.lnI].columnwidth > 15
	.columns[m.lnI].columnwidth = 240
endif
However, I'm having trouble with dates. This file is created at work, then send to the third party and then additional data is imported. The fields I've created came up correctly in D format or numeric format. But the fields which were filled by the third party are converted wrongly. Date fields have 9 or 7 characters, which is obviously not enough. Is there a way to make sure the fields are created as dates? These dates may be empty for all cells.

Thanks in advance.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform