Register | Login
Views: 19364387
Main | Memberlist | Active users | ACS | Commons | Calendar | Online users
Ranks | FAQ | Color Chart | Photo album | IRC Chat
11-02-05 12:59 PM
0 user currently in Programming. | 3 guests
Acmlm's Board - I2 Archive - Programming - Converting Excel files to text?
  
User name:
Password:
Reply:
 

UserPost
FreeDOS
Posts: 1105/1657
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.
HyperLamer
Posts: 3219/8210
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
Posts: 1102/1657
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.
Squash Monster
Posts: 532/677
So that's why a blank MSWord file is 11k?
FreeDOS
Posts: 1094/1657
MS Word works about the same way. And the other office programs, for that matter.
HyperLamer
Posts: 3196/8210
Originally posted by dan
Excel's format is basically a memory dump from Excel. I don't think Microsoft knows how it
completely works.

I think I'm going to be sick.
Jesper
Posts: 1937/2390
As dan mentioned, it can do comma separated files. CSV files work everywhere. I think my toaster can handle them.
dan
Posts: 409/782
Originally posted by Squash Monster
Well, someone could learn Excel's format and write a program to do this.


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
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.


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.
neotransotaku
Posts: 2104/4016
if you select a column of cells, and then copy it to notepad, they'll all copy for you line by line...
FreeDOS
Posts: 1085/1657
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
Squash Monster
Posts: 530/677
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.
windwaker
Posts: 1136/1797
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?
Acmlm's Board - I2 Archive - Programming - Converting Excel files to text?


ABII


AcmlmBoard vl.ol (11-01-05)
© 2000-2005 Acmlm, Emuz, et al



Page rendered in 0.012 seconds.