"File not loaded completely." When Import To Excel

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
justravis
Forum Commoner
Posts: 53
Joined: Mon Dec 16, 2002 3:18 am
Location: San Diego, CA
Contact:

"File not loaded completely." When Import To Excel

Post by justravis »

Trying to import a tab delimited text file into Excel. I go through the text import wizard. Everything looks great there. When I press Finish, I get the error "File not loaded completely." The workbook shows up, but only the first row is imported.

Anybody know what typical mistake results in this error?
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

Don't Cross Post please.
justravis
Forum Commoner
Posts: 53
Joined: Mon Dec 16, 2002 3:18 am
Location: San Diego, CA
Contact:

Post by justravis »

sorry...didnt intend on people to address this issue on that other thread....i thought new issue..new thread...also, the problems started getting a little too advanced for the Newbie forum.

ANYWAY, I think a solution was found by TheBentinel.com:

It looks like Excel won't import a row with more than 256 columns in it. The column it dies on is PAN1C, which happens to be the 256th column.

I trimmed it down to 250 fields and it loaded fine.

Have a good weekend!
Straterra
Forum Regular
Posts: 527
Joined: Mon Nov 24, 2003 8:46 am
Location: Indianapolis, Indiana
Contact:

Post by Straterra »

What in the world does this have to do with PHP code?
justravis
Forum Commoner
Posts: 53
Joined: Mon Dec 16, 2002 3:18 am
Location: San Diego, CA
Contact:

Post by justravis »

The file was generated by PHP. It was possible that Excel was not accepting the file because I did not format the file right in PHP.
Post Reply