You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Tony Harris <To...@Cedar.com> on 2004/05/14 11:37:13 UTC
[HSSF]Named Ranges
Sorry to be a pain, I have asked this question once before, never got a
reply and then the project went on hold.
Question does POI support range names that cover more than one continuous
range of cells. I can access ranges for a single continuous set i.e.
=Sheet1!$C$7:$C$22
But get nothing when looking for a range like
=Sheet1!$E$9:$J$26,Sheet1!$L$17:$R$34
Any help would be greatly appreciated.
Tony
***********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. Any unauthorised distribution or copying is strictly
prohibited.
Whilst Cedar Software Ltd takes steps to prevent the transmission of
viruses via e-mail, we can not guarantee that any email or
attachment is free from computer viruses and you are strongly
advised to undertake your own anti-virus precautions.
Cedar Software Ltd grants no warranties regarding performance,
use or quality of any e-mail or attachment and undertakes no
liability for loss or damage, howsoever caused.
CedAr is a leading UK supplier of Financial, eProcurement, Performance Management and, following the recent acquisition of Goldenhill Computer Systems Ltd, HR and Payroll software. Cedars solutions deliver increased capabilities and offer a direct and measurable financial return on investment. The company has a customer base of more than 500 organisations in both the public and private sector.
Particular sector strengths include Airlines, Business Services,
Education, Emergency Services, Financial Services, Government, Health, Local Authorities, Not for Profit, Retail and Utilities. For more
information, please visit www.cedar.com
2003 CedAr Software Ltd. All Rights Reserved.
Cedar Software Ltd. Incorporation number 3214465
***********************************************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: [HSSF]Named Ranges
Posted by Avik Sengupta <av...@itellix.com>.
AFAIK, the parser does not support that kind of a range assignment. When
writing the "named ranges" parser, it appeared that it had wide ranging
format support, but one is constantly surprised by the range (sic) of
ways in which named ranges can be specified.
On Fri, 2004-05-14 at 15:07, Tony Harris wrote:
> Sorry to be a pain, I have asked this question once before, never got a
> reply and then the project went on hold.
>
> Question does POI support range names that cover more than one continuous
> range of cells. I can access ranges for a single continuous set i.e.
> =Sheet1!$C$7:$C$22
>
> But get nothing when looking for a range like
> =Sheet1!$E$9:$J$26,Sheet1!$L$17:$R$34
>
> Any help would be greatly appreciated.
>
> Tony
>
>
> ***********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. Any unauthorised distribution or copying is strictly
> prohibited.
>
> Whilst Cedar Software Ltd takes steps to prevent the transmission of
> viruses via e-mail, we can not guarantee that any email or
> attachment is free from computer viruses and you are strongly
> advised to undertake your own anti-virus precautions.
>
> Cedar Software Ltd grants no warranties regarding performance,
> use or quality of any e-mail or attachment and undertakes no
> liability for loss or damage, howsoever caused.
>
> CedAr is a leading UK supplier of Financial, eProcurement, Performance Management and, following the recent acquisition of Goldenhill Computer Systems Ltd, HR and Payroll software. Cedars solutions deliver increased capabilities and offer a direct and measurable financial return on investment. The company has a customer base of more than 500 organisations in both the public and private sector.
> Particular sector strengths include Airlines, Business Services,
> Education, Emergency Services, Financial Services, Government, Health, Local Authorities, Not for Profit, Retail and Utilities. For more
> information, please visit www.cedar.com
> 2003 CedAr Software Ltd. All Rights Reserved.
> Cedar Software Ltd. Incorporation number 3214465
> ***********************************************************************
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Another Bug:- Is this Bug in Word API?
Posted by "Koundinya (Sudhakar Chavali)" <su...@yahoo.com>.
Hi Developers,
I wanted to know whether it is bug of POI or POI is not
supporting this document format (It seems The format is in Word
97 only). When I try to extract the text from the attached
document, I got the following error.
Exception in thread "main" java.io.IOException: block[ 0 ]
already removed
at
org.apache.poi.poifs.storage.BlockListImpl.remove(BlockListImpl.java:
96)
at
org.apache.poi.poifs.storage.BlockAllocationTableReader.fetchBlocks(B
lockAllocationTableReader.java:190)
at
org.apache.poi.poifs.storage.BlockListImpl.fetchBlocks(BlockListImpl.
java:128)
at
org.apache.poi.poifs.filesystem.POIFSFileSystem.processProperties(POI
FSFileSystem.java:403)
at
org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSyste
m.java:102)
at TestDocVer.main(TestDocVer.java:16)
You can download from here also
http://www.geocities.com/sudhakar_koundinya/tools.doc
Thanks,
sudhakar
P.S : My test Application
import java.io.*;
import org.apache.poi.poifs.filesystem.*;
import org.apache.poi.util.LittleEndian;
import org.apache.poi.hwpf.model.*;
import org.textmining.text.extraction.sprm.*;
import java.util.*;
import java.io.*;
public class TestDocVer
{
public static void main(String[] args) throws Exception
{
InputStream in=new FileInputStream(args[0]);
POIFSFileSystem fsys = new POIFSFileSystem(in);
// load our POIFS document streams.
DocumentEntry headerProps =
(DocumentEntry)fsys.getRoot().getEntry("WordDocument");
DocumentInputStream din =
fsys.createDocumentInputStream("WordDocument");
byte[] header = new byte[headerProps.getSize()];
din.read(header);
din.close();
// determine the version of Word this document came from.
int nFib = LittleEndian.getShort(header, 0x2);
System.out.println(nFib);
}
}
=====
"No one can earn a million dollars honestly."- William Jennings Bryan (1860-1925)
"Make everything as simple as possible, but not simpler."- Albert Einstein (1879-1955)
"It is dangerous to be sincere unless you are also stupid."- George Bernard Shaw (1856-1950)
__________________________________
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Is this Bug in Word API?
Posted by "Koundinya (Sudhakar Chavali)" <su...@yahoo.com>.
Hi Developers,
I wanted to know whether it is bug of POI or POI is not
supporting this document format (It seems The format is in Word
97 only). When I try to extract the text from the attached
document, I got the following error.
Caused by: java.io.IOException: Invalid header signature; read
598817227515291,
expected -2226271756974174256
Please let me know your comments at earliest
Thanks,
Sudhakar
Detailed Error Message :
Exception in thread "main"
org.prithvi.docparser.microsoft.word.MSWordDocumentPa
rserException: Unable to read the Word Document
Exception Root: The Document is either corrupted or not
in (POI/Text Min
ing) MS Word Format
at
org.prithvi.docparser.microsoft.word.WordDocument.read(WordDocument.j
ava:224)
at ComplexTest.main(ComplexTest.java:6)
Caused by: java.io.IOException: Invalid header signature; read
598817227515291,
expected -2226271756974174256
at
org.apache.poi.poifs.storage.HeaderBlockReader.<init>(HeaderBlockRead
er.java:88)
at
org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSyste
m.java:83)
at
org.textmining.text.extraction.WordExtractor.extractText(WordExtracto
r.java:48)
at
org.prithvi.docparser.microsoft.word.WordDocument.read(WordDocument.j
ava:120)
... 1 more
=====
"No one can earn a million dollars honestly."- William Jennings Bryan (1860-1925)
"Make everything as simple as possible, but not simpler."- Albert Einstein (1879-1955)
"It is dangerous to be sincere unless you are also stupid."- George Bernard Shaw (1856-1950)
__________________________________
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/