[geeks] Microsoft Excel

[Michael Parson]

On Fri, Aug 10, 2007 at 03:34:17PM -0500, Jonathan C. Patschke wrote:
> 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.

Or write a perl script that writes out an Excel file directly?

use Spreadsheet::WriteExcel;

-- 
Michael Parson
mparson at bl.org