Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel truncates text file
Message
De
16/02/2001 19:26:12
Fausto Garcia
Independent Developer
Lima, Pérou
 
 
À
Tous
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Titre:
Excel truncates text file
Divers
Thread ID:
00476920
Message ID:
00476920
Vues:
50
Hi,

I have an Excel worksheet with 20 columns, and need to save it in text format. When I save it as text with delimiters (to a .prn file) the resulting file has the last 3 columns saved at the bottom of the file, as if a right boundary had been reached. It looks like this:

A B C ... O P
1 1 1 ... 1 1
2 2 2 ... 2 2
...
n n n

Q R S
1 1 1
2 2 2
...
n n n

while I expected to get

A B C ... R S
1 1 1 ... 1 1
...
n n n ... n n

Any ideas on how to solve this?

TIA,
Solo se que nada se

Fausto J. Garcia Pino - MCSD.NET
.NET, Oracle, Tronador & Fondismo!
Répondre
Fil
Voir

Click here to load this message in the networking platform