The BIFF5 documentation shows the LABEL type has a maximum length of 255.
One byte is expected to hold that length so again FFh or 255 is the max. It
looks as if the only workaround is BIFF8.
--
Jim
| On Jun 27, 2:54 pm, ShaneDevenshire
| > If your program outputs to Excel 5 with 255 limit you might find out if
the
| > manufacturer of that program allows output to a later file type. I
don't
| > know PHP, and Excel can't control how that program outputs. You might
try
| > copy and paste directly from the original program into a later version
of
| > Excel.
| > --
| > Cheers,
| > Shane Devenshire
| >
| >
| >
| > "ircmaxell" wrote:
| > > I'm generating excel documents via PHP, and am running into a wall
| > > with the 255 character limit for a cell in Excel 5 (the format the
| > > script exports in). Is there any way around this?- Hide quoted text -
| >
| > - Show quoted text -
|
| I am the manufacturer of the program (I am a programmer). I'm using
| Excel 5 because it's easy to do a lot of neat things with from php.
| The problem is that it's restricted to BIFF5 and it's 255 character
| limit... I was wondering if there was an easy way around it, or if I
| needed to rewrite the thing for a newer version of Excel. (Sorry for
| any confusion)...
|
