ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SST and CONTINUE records (https://www.excelbanter.com/excel-programming/359259-sst-continue-records.html)

[email protected]

SST 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


[email protected]

SST and CONTINUE records
 
I Any one has any idea about this pls so let me know



All times are GMT +1. The time now is 10:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com