BIFF5 (Excel 5) 255 char limit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ircmaxell - 27 Jun 2007 19:19 GMT

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?

Reply to this Message

ShaneDevenshire - 27 Jun 2007 19:54 GMT

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.

Signature

Cheers,
Shane Devenshire

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

Reply to this Message

ircmaxell - 27 Jun 2007 20:02 GMT

On Jun 27, 2:54 pm, ShaneDevenshire
<ShaneDevensh...@discussions.microsoft.com> wrote:

> 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
[quoted text clipped - 10 lines]
>
> - 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)...

Reply to this Message

Jim Rech - 27 Jun 2007 20:49 GMT

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.

Signature

Jim

| On Jun 27, 2:54 pm, ShaneDevenshire
| <ShaneDevensh...@discussions.microsoft.com> wrote:
[quoted text clipped - 19 lines]
| needed to rewrite the thing for a newer version of Excel. (Sorry for
| any confusion)...

Reply to this Message

Rate this thread: