When could we enjoy of writing formulas? ;)

Hello, I am developing an application for exporting/importing data from/into a database by means of MS Excel files. To do that I convert an Excel file into an XML (I wrote a generator wich gives me 'gmr:' like file), then I use XSLT + another tool (like XML_DBMS, or Oracle XSU) to load data into t

RE: HSSFRow.getLastCellNum()

Yes it does not work use HSSFRow.cellIterator()

RE: XML/XSL without using Cocoon

Title: XML/XSL without using Cocoon Hi, I am using POI with Oracle XSQL Servlet:   import org.w3c.dom.Document;import oracle.xml.parser.v2.XMLDocument;import java.io.PrintWriter;import oracle.xml.xsql.*;import net.sourceforge.poi.serialization.HSSFSerializer;   public class XSQLExcelSerialize

RE: XML/XSL without using Cocoon

Title: XML/XSL without using Cocoon You mean XML DTD? They use XML Shema from Gnumeric project. The file containing the shema definition is included into the POI zip. I have it in 'poi/help/serializer/gnumeric.xsd'

Can not create HSSFWorkbook for the file attached

Could anybody test this file? When I do : HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream("test.xls")); It throws an exception: net.sourceforge.poi.hssf.record.RecordFormatException: Unable to construct record instance net.sourceforge.poi.hssf.record.Record[] net.sourceforge.poi.hssf.rec

Can not compile POI

I downloaded sources from CVS then started "build.bat". And I saw: Buildfile: build.xml init: [echo] -- [echo] Setting up customized ant tasks... [javac] Compiling 1 source file to D:\cvs\jakarta-poi\tools\tmp\anttasks

RE: Can not create HSSFWorkbook for the file attached

Hi Glen, I created the file using POI then I gave it to a user. The user modified it and gave it back. Then I got the problem. I took some lines out of the file (I use MS Excel 2000 (PC)) and sent it to the mail list. I think that what creates the problem is different fonts used inside one cell. I

about "A1" and "R1C1" reference styles

Hi, I have a question about formulas: Does POI support "R1C1" reference style? If yes how one can turn it on? Regards, Iouri. -- To unsubscribe, e-mail: For additional commands, e-mail:

About workbook and sheet protection

Hi guys, I know your position about the protection but I can not agree with you. Have you checked with someone (a lawyer:))? I read the documentation and I even extended workbook and sheet classes so that they support the protection without a password (It was easy because you prepared evrything fo

Warning: Not all rows are read! (May be it is known)

Hi, I have found that sometimes not all rows are read when I create HSSFWorkbook from an existing file. The reason is that sometimes ROW records are not grouped in one set in the excel file. There could be several sets of ROW records and the code is written with assumption that there is only one s

RE: POI Speed...

Are you sure that the POI part is the reason? Why not to put some debug output??? I use POI for almost the same kind of things and I don't have any problems with performance. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 17, 2002 3:03 PM To:

RE: Warning: Not all rows are read! (May be it is known)

Hi Paul, no I think my case is different. -Original Message- From: Paul Krause [mailto:pkrause@;soundbite.com] Sent: Monday, October 14, 2002 8:40 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Warning: Not all rows are read! (May be it is known) If I am not mistaken, this i

RE: Reg WorkBook/WorkSheet Protection

I have my "private" POI version which can make read-only files (but without having password). Unfortunatly I have other stuff in the same version (methods for getting text formula results, "name" support) so I can not produce a patch. But I can give you the jar. I think that it is not good as we ar

RE: Reg WorkBook/WorkSheet Protection

I just mean that I have a working version of POI (I use it in my real system) but I have changed some things and I don't remember which changes are important (as far as it is stable I don't care). Though for making a patch it should be cleanned up. -Original Message- From: Andrew C. Olive

RE: Excel not calculating

It is very strange... I am using POI to create workbooks that contain some data and some cells with formulas. When I open such files all formulas are recalculated automaticaly. Though I don't use a template and create the hole workbook from the scratch. -- To unsubscribe, e-mail:

RE: Recognizing Dates

Hi, I use this code: boolean isCellDateFormatted(HSSFWorkbook book, HSSFCell cell) { boolean result = false; short format = cell.getCellStyle().getDataFormat(); if (HSSFDateUtil.isValidExcelDate(cell.getNumericCellValue())) { if (HSSFDateUtil.isInternalDateFormat(forma

about charts

Hi all! I have a question: If I have an excel file that contains a chart whether I can adjust the "data source region" for it? Is it implemented? If not do you know how it could be done? Any thoughts? Thanks in advance, Iouri. --

RE: Am I realy the only one trying to read a formula value?

Hi Casper, I also needed to read formula values. It was not supported by the version of POI I got at that moment. So i simply changed the source code a bit ;) To get number formula result is very easy it comes with FormulaRecord. For text result you need to catch "text" record (I don't remember the

RE: Excel-Sheets as Templates

Hi, why don't you like cocoon? I agree gnumerc format is a bit complicated. But you can write your own serializer. I did that. Now I have my own simple XML schema describing excel file. And my serializer can open predefined excel file (template) and add cells to it (instead of creating a new fil