View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] arun.darra@gmail.com is offline
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