LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default very large text and CONTINUE records

Hi,

This is very urgent so please help me out with this.

I am creating a Excel file using the Biff8 format. My excel file has
two string
1 string is of 10 bytes in length and the other is 12K in length.

Both the strings are writen into the SST record, the way Im writing it
is
SST Header | Data length | String 1 | String 2
but since String 2 is 12K in lnegth it over flows the maximum record
lenth of 8228.
So I add only the first string to the SST record and then add a
CONTINUE record and add the second string to it.

But my Excel sheet when displayed is blank. The size of the file is
equivalent to the data in it but when displayed thru excel it is blank.

Any hints or guidanced will by greatly appreciated.

Thanks in advance

Regards
Arun

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XY Scatter-problems with large data records DataGeek Excel Discussion (Misc queries) 1 May 28th 08 09:53 PM
How to embed large number of variables in text inside a text box? Riva Chase Excel Discussion (Misc queries) 0 October 30th 07 01:42 AM
How do I get the text to continue on the next line when its long Roses00 Excel Discussion (Misc queries) 2 September 14th 06 02:11 PM
Text not continuing to wrap for large block of text in Excel cell Mandra Charts and Charting in Excel 1 May 15th 06 07:13 PM
SST and CONTINUE records [email protected] Excel Programming 1 April 19th 06 04:49 PM


All times are GMT +1. The time now is 09:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"