Hello,

I just converted libpst http://www.five-ten-sg.com/libpst/ code to pure
java.
I think it can be useful for other developers and POI is the best place to
share code.

But there some issues
1) uglu API
2) no documentation
3) i have no time to support the code
4) legal issues?

Any ideas?

Thanks,
Andrey

Hi guys

I just want to let you know about a sub-product I developed using POI :
http://sourceforge.net/projects/workbooktag/

If one of you guys think it can be nice to put a link from your web site to
this sub-product do not hesitate to reference it and/or talk about it !

Still in development but I think it's can be very usefull specially in
interactive mode using (see ajax demo part)

Thanks

André Masson

     I am trying to write a program that will read an .xlsx file, sort through the data counting
instances it finds based on the if statements, and count each true instance.  I have gotten
this program to work with the HSSF library (with the same file converted to .xls) but have
a problem when trying to use the XSSF library.  Here is my code:

package logsheetsorter;

//Import libraries here
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFCell;

class SLMonthlyClosed
{
    //Declare attributes here.
    XSSFWorkbook logBook;  //Declare a workbook to capture the excel page to be read.
    XSSFSheet slLotSheet;  //Declare a sheet to hold the ML Lot number information.
    XSSFCell currentCell;  //Declare a cell to hold the current cell being looked at.
    String cellContents;  //Declare a string object to be used to analyze the cell contents.
    String monthSelected;  //Declare a string attribute to convert the month object to.
    String yearSelected;  //Declare a string attribute to convert the year object to.
    String lotMonth;  //Declare a string attribute for the month substring of the lot number.
    String lotYear;  //Declare a string attribute for the year substring of the lot number.
    int count = 0;  //Declare an attribute to count the number of instances that found that
match the user input.

    SLMonthlyClosed()
    {
        try
        {
            logBook = new XSSFWorkbook("C:/Documents and Settings/Cory/Desktop/LOT_NUMBER_LOG.xlsx");
            slLotSheet = logBook.getSheet("SL LOTS");
        }

        catch (Exception e)
        {
            System.out.println("WorkBook Read Error: " + e);
        }
    }

    int SLMonthlyClosedCount(Object year, Object month)
    {

        yearSelected = year.toString();  //Convert the object year to a string attribute.
        monthSelected = month.toString();  //Convert the object month to a string attribute.

        yearSelected = yearSelected.substring(3);  //Get the last digit of the year selected
in order to compare to the lot number year.

        try
        {
            for (int row = 2; slLotSheet.getRow(row).getCell(1) !=null || slLotSheet.getRow(row).getCell(2)
!= null || slLotSheet.getRow(row).getCell(3) != null; row++)  //Search through each row that
is filled in in the worksheet.
            {
                cellContents = slLotSheet.getRow(row).getCell(1).getStringCellValue();  //Get
the lot number of the current row being examined.
                
                if (cellContents.length() > 5)
                {
                    lotYear = cellContents.substring(3, 4);  //Get the substring of the lotYear
to compare to the year selected.

                    if (lotYear.equals(yearSelected))  //Compare the lot year to the year
selected.
                    {
                        lotMonth = cellContents.substring(4, 6);  //Get the substring of the
lot number representing the month.

                        if (lotMonth.equals(monthSelected))  //Compare the lot number month
with the selected month.
                        {
                            if (slLotSheet.getRow(row).getCell(8) != null)
                            {
                                count++;
                            }
                        }
                    }
                }
            }
        }

        catch (Exception a)
        {
            System.out.println("SL Monthly Closed Count Error: " + a);
        }

        return count;
    }
}


     I get the following error(s):

log4j:WARN No appenders could be found for logger (org.openxml4j.opc).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "AWT-EventQueue-0" java.lang.OutOfMemoryError: Java heap space
        at org.apache.xmlbeans.impl.store.Cur$CurLoadContext.attr(Cur.java:3039)
        at org.apache.xmlbeans.impl.store.Cur$CurLoadContext.attr(Cur.java:3060)
        at org.apache.xmlbeans.impl.store.Locale$SaxHandler.startElement(Locale.java:3250)
        at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.reportStartTag(Piccolo.java:1082)
        at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseAttributesNS(PiccoloLexer.java:1802)
        at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseOpenTagNS(PiccoloLexer.java:1521)
        at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseTagNS(PiccoloLexer.java:1362)
        at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseXMLNS(PiccoloLexer.java:1293)
        at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseXML(PiccoloLexer.java:1261)
        at org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.yylex(PiccoloLexer.java:4808)
        at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yylex(Piccolo.java:1290)
        at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yyparse(Piccolo.java:1400)
        at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.parse(Piccolo.java:714)
        at org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3439)
        at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1270)
        at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1257)
        at org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:345)
        at org.openxmlformats.schemas.spreadsheetml.x2006.main.WorksheetDocument$Factory.parse(Unknown
Source)
        at org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:126)
        at org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:118)
        at org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:201)
        at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:164)
        at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:173)
        at logsheetsorter.SLMonthlyClosed.<init>(SLMonthlyClosed.java:25)
        at logsheetsorter.LogSheetSorter.actionPerformed(Main.java:225)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
        at java.awt.Component.processMouseEvent(Component.java:6041)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)

     I'm not expereienced with using the log4j class.  I understand I need to configure a
log4j.properties file in order for this to work.  There are not that many examples out there
after looking around (or I'm looking in the wrong spots).  Anyone have any suggestions or
references I can look at to learn this library and be able to read the .xlsx file?  Also,
I tried to use org.apache.poi.ss.usermodel.* (Workbook, Sheet, Cell, and WorkbookFactory)
to read the file with the same result.

Cory

I will be out of the office starting  02/23/2009 and will not return until
03/09/2009.

I will be on Paternity leave.  For emergencies concerning @task please
contact Tony Ferrante or Gwen Bradford.  For other emergencies contact Paul
Mitchell.


Any U.S. tax advice contained in the body of this e-mail was not intended or written to be
used, and cannot be used, by the recipient for the purpose of avoiding penalties that may
be imposed under the Internal Revenue Code or applicable state or local tax law provisions.
________________________________________________________________________
The information contained in this message may be privileged and confidential and protected
from disclosure.  If the reader of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this communication is strictly
prohibited. If you have received this communication in error, please notify us immediately
by replying to the message and deleting it from your computer. 

Notice required by law:  This e-mail may constitute an advertisement or solicitation under
U.S. law, if its primary purpose is to advertise or promote a commercial product or service.
  You may choose not to receive advertising and promotional messages from Ernst & Young
LLP (except for Ernst & Young Online and the ey.com website, which track e-mail preferences
through a separate process) at this e-mail address by forwarding this message to no-more-mail@ey.com.
 If you do so, the sender of this message will be notified promptly. Our principal postal
address is 5 Times Square, New York, NY 10036. Thank you.  Ernst & Young LLP

---------------------------------------------------------------------
To unsubscribe, e-mail: general-unsubscribe@poi.apache.org
For additional commands, e-mail: general-help@poi.apache.org

When I click on subscribe or unsubscribe (on this page 
http://poi.apache.org/mailinglists.html)  in any of the mailing list I get 
a email address that is not valid. For example 
general-subscribe.at.poi.apache.org
dev-subscribe.at.poi.apache.org

You probably already know this but the issue is this 
 <a href="mailto:user-subscribe.at.poi.apache.org">  should be   <a 
href="mailto:user-subscribe@poi.apache.org">



Willis C White III 
IQ Technology Projects
IBM CIO Technology & Innovation
Home office 845 331-5134
Cell 845 853-3827
 

 

On Thu, 4 Dec 2008, Steve Ruzila wrote:
> I'm working on a project that would use Lucene/Solr as the backend for 
> searching through thousands of MS Office and PDF files. I want to be 
> able to do keyword searches on these files. I'm not quite clear as to 
> how POI works with Lucene and what relationship the Tika project has 
> with it....since Tika seems to use POI.

You might find it easier to just use tika, and let it handle the poi 
specifics

Otherwise, we do have lots of dedicated text extractors in poi. You'd 
probably want to use those

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: general-unsubscribe@poi.apache.org
For additional commands, e-mail: general-help@poi.apache.org

I'm working on a project that would use Lucene/Solr as the backend for
searching through thousands of MS Office and PDF files. I want to be
able to do keyword searches on these files. I'm not quite clear as to
how POI works with Lucene and what relationship the Tika project has
with it....since Tika seems to use POI.

Steve

---------------------------------------------------------------------
To unsubscribe, e-mail: general-unsubscribe@poi.apache.org
For additional commands, e-mail: general-help@poi.apache.org

3.5-FINAL will be released in early 2009 (January or February).

Yegor

> Good morning,
> 
> We are planning to use POI-3.5 to be able to read and generate Excel files 
> in the new 2007 format based on XML. However, we are a little bit 
> concerned about the current version of POI being a beta version.
> Could you give an estimation about when the final version of POI-3.5 will 
> be released, please...? We wouId like to know if there is any roadmap for 
> future releases.
> 
> Thank you very much and kind regards.
> 
> --------------------------------------------------------------------------------
> Juan Hidalgo-Saavedra
> 
> TMG - Cartman VSE
> GVCG - VCM Database
> GVCG - VCR Consolidation
> 
> GFT Iberia, Valencia, Spain
> Tel: +34 - 96 310 2418
> --------------------------------------------------------------------------------
> This mail is transmitted to you on behalf of GFT.
> Diese Post wird Ihnen im Namen der GFT übermittelt.
> --------------------------------------------------------------------------------
> 
> 
> 
> ---
> 
> This e-mail may contain confidential and/or privileged information. If you are not the
intended recipient (or have received this e-mail in error) please notify the sender immediately
and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material
in this e-mail is strictly forbidden.
> 
> Please refer to http://www.db.com/en/content/eu_disclosures.htm for additional EU corporate
and regulatory disclosures.


---------------------------------------------------------------------
To unsubscribe, e-mail: general-unsubscribe@poi.apache.org
For additional commands, e-mail: general-help@poi.apache.org

Good morning,

We are planning to use POI-3.5 to be able to read and generate Excel files 
in the new 2007 format based on XML. However, we are a little bit 
concerned about the current version of POI being a beta version.
Could you give an estimation about when the final version of POI-3.5 will 
be released, please...? We wouId like to know if there is any roadmap for 
future releases.

Thank you very much and kind regards.

--------------------------------------------------------------------------------
Juan Hidalgo-Saavedra

TMG - Cartman VSE
GVCG - VCM Database
GVCG - VCR Consolidation

GFT Iberia, Valencia, Spain
Tel: +34 - 96 310 2418
--------------------------------------------------------------------------------
This mail is transmitted to you on behalf of GFT.
Diese Post wird Ihnen im Namen der GFT übermittelt.
--------------------------------------------------------------------------------



---

This e-mail may contain confidential and/or privileged information. If you are not the intended
recipient (or have received this e-mail in error) please notify the sender immediately and
delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in
this e-mail is strictly forbidden.

Please refer to http://www.db.com/en/content/eu_disclosures.htm for additional EU corporate
and regulatory disclosures.

Nick Burch <nick@torchbox.com> writes:

> On Sat, 25 Oct 2008, Adrian Aichner wrote:
>> I noticed above 404 link at the bottom of
>>
>> http://poi.apache.org/hssf/formula.html
>
> Thanks for pointing this out, now fixed on the site

Hello Nick and All!

Please pardon the off-topic mail.

I tried again today to find information how in general one is supposed
to report broken links and such in the huge apache.org webspace.

I failed.

Can you please provide me a pointer?

The problem I would like to report today is the broken link

http://www.gnupg.org/(en)/documentation/faqs.html#q4.19

I found that one in http://ant.apache.org/bindownload.cgi

Thanks!

Adrian

>
> Nick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: general-unsubscribe@poi.apache.org
> For additional commands, e-mail: general-help@poi.apache.org
>
>

-- 
Adrian Aichner
 mailto:adrian@elisp.de

---------------------------------------------------------------------
To unsubscribe, e-mail: general-unsubscribe@poi.apache.org
For additional commands, e-mail: general-help@poi.apache.org

On Sat, 25 Oct 2008, Adrian Aichner wrote:
> I noticed above 404 link at the bottom of
>
> http://poi.apache.org/hssf/formula.html

Thanks for pointing this out, now fixed on the site

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: general-unsubscribe@poi.apache.org
For additional commands, e-mail: general-help@poi.apache.org

Hi!

I noticed above 404 link at the bottom of

http://poi.apache.org/hssf/formula.html

General feedback:

I found it relatively difficult to find a way to report a broken link
in the
http://poi.apache.org/
website.

I hope this is the way to do it.

Might be worth putting some hint how to contact the webmaster in the
footer or sidebar of the apache.org webpages.

I can understand you may not want to put mailto links there, to be
collected by crawlers.

But the information could be made available in a form not easily
collected by programs, like some free-form description of how to
contact the webmaster.

-- 
Adrian Aichner
 mailto:adrian@elisp.de

---------------------------------------------------------------------
To unsubscribe, e-mail: general-unsubscribe@poi.apache.org
For additional commands, e-mail: general-help@poi.apache.org

On Mon, 28 Jul 2008, Ajnala Ali wrote:
> How about implementing reading/text-extraction of OneNote 2007 files 
> (*.one, *.onepkg)?

There's no file format documentation available, so it would be a reverse 
engineering job.

Firstly, you'd need to figure out the file structure (one poifs stream? 
many?). Then, the format inside that (8 byte records? something else?). 
Finally, you'd need to make sense of the data

Basic text extraction might be possible in a day, or it might be over a 
week, depending on how the format turned out to have been done. If you're 
interested in doing this work, join the dev list and people can give you 
pointers

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: general-unsubscribe@poi.apache.org
For additional commands, e-mail: general-help@poi.apache.org

How about implementing reading/text-extraction of OneNote 2007 files (*.one,
*.onepkg)?

On Wed, 4 Jun 2008, Chris Metcalf wrote:
> We're interested in adding support for The Office Open XLSX format to 
> some of our tools.
>
> According to http://poi.apache.org/ it is currently in a development 
> branch and is scheduled to be finalized later this summer.
>
> What is the current state of the development code?

It's in svn, and many people are using it just fine. However, it isn't yet 
feature complete, so for example not everything in hssf is currently 
supported in xssf

I'd suggest giving it a try, and see if it already does all you need. You 
can get nightly builds from
 	http://encore.torchbox.com/poi-svn-build/OOXML-Branch/

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: general-unsubscribe@poi.apache.org
For additional commands, e-mail: general-help@poi.apache.org

Chris Metcalf ha scritto:
> We're interested in adding support for The Office Open XLSX format to 
> some of our tools.
>
> According to http://poi.apache.org/ it is currently in a development 
> branch and is scheduled to be finalized later this summer.
>
> What is the current state of the development code? Is it in a usable 
> and reliable state or should we wait until later in the year when the 
> wrinkles have been ironed out?
>
> Thanks,
> Chris Metcalf
>
Hi Chris,

i suggest you to wait a more stable release of POI, we also introduced 
support for the Office2007 format in our commercial solution called 
LogicalDOC(the commercial version of Contineo).
In this case we decided to develop our own text etractors.

Best Regards
---------------------------------------------------------------
ing. Marco Meschieri
e-mail: m.meschieri@logicalobjects.it <mailto:m.meschieri@logicalobjects.it>
---------------------------------------------------------------
Logical Objects snc
Via Bonasi, 2/A 41012 Carpi (MO) Italy
Tel./Fax. 059 688969
web: http://www.logicalobjects.it
-- 
AVVERTENZE AI SENSI DEL DLGS 196/2003:
Le informazioni contenute in questo messaggio di posta elettronica e/o 
nel/i file/s allegato/i, sono da considerarsi strettamente riservate. Il 
loro utilizzo e' consentito esclusivamente al destinatario del 
messaggio, per le finalita' inidcate nel messaggio stesso. Qualora 
riceveste questo messaggio senza esserne il destinatario Vi preghiamo 
cortesemente di darcene notizia via e-mail e di procedere alla 
distruzione del messaggio stesso, cancellando dal vostro sistema; 
costituisce comportamento contrario ai principi dettati dal Dlgs196/2003 
il trattenere il messaggio stesso, divulgandolo anche in parte, 
distribuirlo ad altri soggetti,copiarlo, od utilizzarlo per 
finalita'diverse. Titolare del trattamento e' Logical Objects SNC Via 
Bonasi 2/A 41012 CARPI (MO) Tel. 059/688969 Fax 059/688969

This e-mail and any file transmitted with it is intended only for the 
person or entity to which is addressed and may contain information that 
is privileged, confidential or otherwise protected from disclosure. 
Copying, dissemination or use of this e-mail or the information herein 
by anyone other than the intended recipient is prohibited. If you have 
received this e-mail by mistake, please notify us immediately by 
telephone or fax. Proprietor of treatment is Logical Objects SNC Via 
Bonasi 2/A 41012 CARPI (MO) Tel. 059/688969 Fax 059/688969

We're interested in adding support for The Office Open XLSX format to  
some of our tools.

According to http://poi.apache.org/ it is currently in a development  
branch and is scheduled to be finalized later this summer.

What is the current state of the development code? Is it in a usable  
and reliable state or should we wait until later in the year when the  
wrinkles have been ironed out?

Thanks,
Chris Metcalf

---------------------------------------------------------------------
To unsubscribe, e-mail: general-unsubscribe@poi.apache.org
For additional commands, e-mail: general-help@poi.apache.org

Hi,
   
  I was trying to change the template of a word document, and was not able to do so. What
format of the file path is the setTemplate() function of SummaryInformation expecting ?
   
  I tried to use the removeTemplate() function as well, and it doesn't work either.
   
  I am using POI 3.0.1.
   
  My function goes something like this
   
  ----------------------------------------
   
  try
  {
  DocumentEntry siEntry = (DocumentEntry)
  dir.getEntry(SummaryInformation.DEFAULT_STREAM_NAME);
  DocumentInputStream dis = new DocumentInputStream(siEntry);
  PropertySet ps = new PropertySet(dis);
  dis.close();
  
  si = new SummaryInformation(ps);
  }
  catch (FileNotFoundException ex)
  {
  /* There is no summary information yet. We have to create a new
  * one. */
  si = PropertySetFactory.newSummaryInformation();
  
  }
  
   
  
  if (p_template != null && p_template.length() > 0) {
  si.removeTemplate();
  si.setTemplate("c:\temp\icaseworkmacro.dot");
   
  si.write(dir, SummaryInformation.DEFAULT_STREAM_NAME);
   
  -----------------------------------
   
   
  Am I missing something ?
   
  Please help !!!
   
  Satish
   

       
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.

Note: forwarded message attached.
       
---------------------------------
Never miss a thing.   Make Yahoo your homepage.

On Tue, 11 Dec 2007, Viktor Dalinger wrote:
> The Excel-formula, that are stored in one Excel-worksheet and referenced 
> to some other Excel-worksheets, will not be refreshed / calculated after 
> opening of the document.

You will need to either re-calculate the formula values, or add a macro to 
your sheet to tell excel to do it for you. Otherwise, excel will just 
display the previous (cached) value without updating it.

See http://poi.apache.org/hssf/eval.html for details about how to 
re-calculate

Also, this sort of question would be better asked on the users list

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: general-unsubscribe@poi.apache.org
For additional commands, e-mail: general-help@poi.apache.org

Hey,

Here it only happens with documents stored and opened by MS Excel.
If you store the template with OO Calc, and use POI to generate Excels
from that, the problem does not occur.
Also, even with the version stored by MS Excel, OO Calc will open it
just fine.

Not sure what causes this...

Regards,

Elvis Willems




On Tue, 2007-12-11 at 15:15 +0100, Viktor Dalinger wrote:
> Hi all,
> 
>  
> 
> We have a problem by generation of Excel-sheets after the switch from
> poi 2.5.1 to poi 3.0-FINAL-20070503.
> 
>  
> 
> The Excel-formula, that are stored in one Excel-worksheet and
> referenced to some other Excel-worksheets, will not be refreshed /
> calculated after opening of the document.
> 
> Just if some cell-values are changed, the calculation will be
> processed.
> 
> We tried to call calculatemethod on worksheet in order to interrupt
> the calculation of formula in worksheet, but without success.
> 
>  
> 
> Best regards
> 
> Viktor
> 
>  
> 
> Viktor Dalinger
> 
> FERNBACH-Software S.A.
> 
> Software Engineer
> 
> Tel. + 352 / 40 22 44 330
> 
> viktor.dalinger@fernbach.com
> 
> http://www.fernbach.com
> 
>  
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: general-unsubscribe@poi.apache.org
> For additional commands, e-mail: general-help@poi.apache.org

 **** DISCLAIMER ****
 http://www.schaubroeck.be/maildisclaimer.htm

Hi all,

 

We have a problem by generation of Excel-sheets after the switch from
poi 2.5.1 to poi 3.0-FINAL-20070503.

 

The Excel-formula, that are stored in one Excel-worksheet and referenced
to some other Excel-worksheets, will not be refreshed / calculated after
opening of the document.

Just if some cell-values are changed, the calculation will be processed.

We tried to call calculate method on worksheet in order to interrupt the
calculation of formula in worksheet, but without success.

 

Best regards

Viktor

 

Viktor Dalinger

FERNBACH-Software S.A.

Software Engineer

Tel. + 352 / 40 22 44 330

viktor.dalinger@fernbach.com

http://www.fernbach.com <http://www.fernbach.com/> 

 

Hello,

Sorry for the wide distribution.

I was wondering if there are any capabilities, either already in POI or being planned for,
to have a Java API for the Visio file format.  Also, is there anywhere an open source Java
converter from the native Visio format to XML?

Any info would be appreciated.

Thanks,
- Dmitry