Hey, this looks cool...
But should HyperlinkRecord be a CellValueRecordInterface? When you read in the
file, what record do you get at the cell.. an SSTRecord? Maybe the HLINK is
only indirectly linked to the cell? You'll probably just have to pore over
BiffViewer output to understand the semantics of this.. that's the only way, as
Andy suggested earlier.
As far as implementing serialize, check our the other records... dont look at SST, which is probably most complicated.. look at NumberRecord for simple, Formula record for intermediate ..
Getsize... well, you will just have to count :) .. ie, add up the sizes of the individual elements... and if you mess up the count, subsequent records will not be read.. dont you just love the format :) !! Again, check formularecord for a useful example.
HTH - Avik
Quoting Mark Hissink Muller <[EMAIL PROTECTED]>:
I'm not sure the attachment worked; find the draft here:
http://www.hissinkmuller.nl/poi/HyperlinkRecord.java
Thanks, - Mark
On Sun, 20 Feb 2005 21:14:34 +0100, Mark Hissink Muller <[EMAIL PROTECTED]> wrote:POI-dev members,
Thanks again for your support on my attempt to add an Excel Hyperlinked cell to HSSF.
Things are going fairly well. With help of Avik's document, I've been able to read the label and the actual URL into a new HyperlinkRecord, which works fine.
When testing the HyperlinkRecord-class fully integrated, and trying to read the hyperlink from the modified HSSFCell, I have some problems.
Instead of finding my new HSSFCell.CELL_TYPE_HYPERLINK (with record HyperlinkRecord), I find a LabelSSTRecord, which, as I understand it, is a basic kind of text-record.
Zooming in on:
public static Workbook createWorkbook(List recs)
I see that 161 Record(s) from the InputStream [1] are input but that after 81 records the processing breaks because an EOFRecord is found. Commenting the break, I learn that my HyperlinkRecord is number 101 in the List. I am puzzled; why is the EOF found before all the records are property processed?
Another thing which I could use a suggestion is the implementation of:
public int serialize( int offset, byte[] data ) // and public int getRecordSize()
For your convenience, I've added my current (draft) version of the HyperlinkRecord as an attachment to this mail.
Any thoughts are highly appreciated.
Cheers, - Mark
[1] - I have a simple example where I try to read an Hyperlink+Label from cell A1. Apart from this, the workbook is empty (new Excel-file)
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
