[geeks] Microsoft Excel
Jonathan C. Patschke
jp at celestrion.net
Fri Aug 10 15:34:17 CDT 2007
On Fri, 10 Aug 2007, Sridhar Ayengar wrote:
> For various reasons, I need to use a non-printable character as a
> delimiter in a text file. I thought ASCII fs (0x1c) would probably be
> a good choice. It works fine in my scripts and it's easy to generate
> in Servlets.
>
> The problem is that I can't convince fucking Microsoft Excel to import
> files delimited with fs.
Have you considered generating a file with fixed-width columns instead
of a delimiter? Excel can usually swallow those pretty well.
--
Jonathan Patschke )
Elgin, TX ( "I detest logging filesystems."
USA ) --Linus Torvalds
More information about the geeks
mailing list