BIFF5 (Excel 5) 255 char limit

[ircmaxell]

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?

 

[Guest]

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.

 

[ircmaxell]

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





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

 

[Jim Rech]

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