Register | Login | |||||
Main
| Memberlist
| Active users
| ACS
| Commons
| Calendar
| Online users Ranks | FAQ | Color Chart | Photo album | IRC Chat |
| |
0 user currently in Programming. | 3 guests |
Acmlm's Board - I2 Archive - Programming - Converting Excel files to text? | | | |
Add to favorites | "RSS" Feed | Next newer thread | Next older thread |
User | Post | ||
windwaker Ball and Chain Trooper WHY ALL THE MAYONNAISE HATE Level: 61 Posts: 1136/1797 EXP: 1860597 For next: 15999 Since: 03-15-04 Since last post: 4 days Last activity: 6 days |
| ||
Well, I have this Excel file that I need to convert to text, having each row in Excel being a new line in text. I don't want to type all of this out myself, so does anyone know an easy way to do this? | |||
Squash Monster New Age Retro Hippie Togateiru Fohku Kohgeki!! GRUNGE no HAMSTER otona bite Peace love and turnpike! Level: 40 Posts: 530/677 EXP: 430507 For next: 10802 Since: 03-15-04 From: Maryland (of the Country Between Canada and Mexico) Since last post: 5 hours Last activity: 5 hours |
| ||
Well, someone could learn Excel's format and write a program to do this. But, Excel should be able to do this on its own: Open the file, and choose save as. One of the options should be "text, tab deliminated". That should be about what you want. The file you get might look spaced poorly -- Excel will use a tab for the space between columns, whether or not that looks right in a text program. If it's a problem, I can think of three solutions to this: fixing the spacing by hand (ew), find-replacing tabs with <td> and making the whole document in HTML, or writing a quick program. I'd write the program for you, but I don't know if one of the other solutions would be more reasonable. (edited by Squash Monster on 02-10-05 02:39 AM) |
|||
FreeDOS Lava Lotus Wannabe-Mod :< Level: 59 Posts: 1085/1657 EXP: 1648646 For next: 24482 Since: 03-15-04 From: Seattle Since last post: 6 hours Last activity: 4 hours |
| ||
You can see if antiexcel works: http://sourceforge.net/projects/antiexcel/ I've never used it, nor had the need. I came up with the name because I know that antiword works well |
|||
neotransotaku Baby Mario 戻れたら、 誰も気が付く Level: 87 Posts: 2104/4016 EXP: 6220548 For next: 172226 Since: 03-15-04 From: Outside of Time/Space Since last post: 11 hours Last activity: 1 hour |
| ||
if you select a column of cells, and then copy it to notepad, they'll all copy for you line by line... | |||
dan Snap Dragon Level: 43 Posts: 409/782 EXP: 534516 For next: 30530 Since: 03-15-04 Since last post: 20 hours Last activity: 14 hours |
| ||
Originally posted by Squash Monster Excel's format is basically a memory dump from Excel. I don't think Microsoft knows how it completely works. Originally posted by Squash Monster There's also an option for comma delimited files if you scroll down the list of available file types. That might be easier to work with. |
|||
Jesper Busy, busy, busy. Level: 69 Posts: 1937/2390 EXP: 2856000 For next: 13743 Since: 03-15-04 From: Sweden. Since last post: 176 days Last activity: 79 days |
| ||
As dan mentioned, it can do comma separated files. CSV files work everywhere. I think my toaster can handle them. | |||
HyperLamer <||bass> and this was the soloution i thought of that was guarinteed to piss off the greatest amount of people Sesshomaru Tamaranian Level: 118 Posts: 3196/8210 EXP: 18171887 For next: 211027 Since: 03-15-04 From: Canada, w00t! LOL FAD Since last post: 2 hours Last activity: 2 hours |
| ||
Originally posted by dan I think I'm going to be sick. |
|||
FreeDOS Lava Lotus Wannabe-Mod :< Level: 59 Posts: 1094/1657 EXP: 1648646 For next: 24482 Since: 03-15-04 From: Seattle Since last post: 6 hours Last activity: 4 hours |
| ||
MS Word works about the same way. And the other office programs, for that matter. | |||
Squash Monster New Age Retro Hippie Togateiru Fohku Kohgeki!! GRUNGE no HAMSTER otona bite Peace love and turnpike! Level: 40 Posts: 532/677 EXP: 430507 For next: 10802 Since: 03-15-04 From: Maryland (of the Country Between Canada and Mexico) Since last post: 5 hours Last activity: 5 hours |
| ||
So that's why a blank MSWord file is 11k? | |||
FreeDOS Lava Lotus Wannabe-Mod :< Level: 59 Posts: 1102/1657 EXP: 1648646 For next: 24482 Since: 03-15-04 From: Seattle Since last post: 6 hours Last activity: 4 hours |
| ||
yeah, probably. Smarter word processors are usually far more efficient at file formats. AbiWord uses only 2.4 kilobytes for a blank document. Uncompressed, for that matter. | |||
HyperLamer <||bass> and this was the soloution i thought of that was guarinteed to piss off the greatest amount of people Sesshomaru Tamaranian Level: 118 Posts: 3219/8210 EXP: 18171887 For next: 211027 Since: 03-15-04 From: Canada, w00t! LOL FAD Since last post: 2 hours Last activity: 2 hours |
| ||
Hmm... Come to think of it, wouldn't that make exploiting MSWord files ridiculously easy? I'd always wondered why there seemed to be so much garbage in those files. |
|||
FreeDOS Lava Lotus Wannabe-Mod :< Level: 59 Posts: 1105/1657 EXP: 1648646 For next: 24482 Since: 03-15-04 From: Seattle Since last post: 6 hours Last activity: 4 hours |
| ||
It's also the reason that Microsoft Word is just about the only word processor that is capable of infecting the operating system with viruses. That, and weak security in macros. |
Add to favorites | "RSS" Feed | Next newer thread | Next older thread |
Acmlm's Board - I2 Archive - Programming - Converting Excel files to text? | | | |