Limit to how long a string can be in Excel?

[David Thielen]

Hi;

Is there a limit to how long a string can be in an Excel cell? We seem
to be hitting a problem with XLS files we create (using POI) where the
content of the cell is a string that is over 4K in length.

thanks - dave

david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[Jialiang Ge [MSFT]]

Hello Dave

Long time no see! In Excel 2003, the max length of cell contents (text) is
32,767 characters. In Excel 2007, the total number of characters that a
cell can contain is 32,767 characters.

For details, please refer to these two articles:

Excel specifications and limits for Excel 2003
http://office.microsoft.com/en-us/excel/HP051992911033.aspx

Excel specifications and limits for Excel 2007
http://office.microsoft.com/en-us/excel/HP100738491033.aspx

Let me know if you have any other questions.

Regards,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

MSDN Managed Newsgroup support offering is for non-urgent issues where an
initial response from the community or a Microsoft Support Engineer within
2 business day is acceptable. Please note that each follow up response may
take approximately 2 business days as the support professional working with
you may need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[David Thielen]

Hi;

Yep, its been awhile. Just occasional bug fixing now at our end.

It looks like this is a POI bug then.

thanks - dave

Hello Dave

Long time no see! In Excel 2003, the max length of cell contents (text) is
32,767 characters. In Excel 2007, the total number of characters that a
cell can contain is 32,767 characters.

For details, please refer to these two articles:

Excel specifications and limits for Excel 2003
http://office.microsoft.com/en-us/excel/HP051992911033.aspx

Excel specifications and limits for Excel 2007
http://office.microsoft.com/en-us/excel/HP100738491033.aspx

Let me know if you have any other questions.

Regards,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

MSDN Managed Newsgroup support offering is for non-urgent issues where an
initial response from the community or a Microsoft Support Engineer within
2 business day is acceptable. Please note that each follow up response may
take approximately 2 business days as the support professional working with
you may need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm