poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Avik Sengupta <avik.sengu...@itellix.com>
Subject RE: Reading value from formula cell
Date Thu, 13 Jan 2005 14:53:49 GMT
basic questions.. sorry!

1. Do you SAVE the file in Excel before closing.

2. Are you sure you're opening the SAVED file, and not the ORIGINAL
file?

Regards
-
Avik


On Thu, 2005-01-13 at 09:48 -0500, Kashikar, Yogita (SSD Technology)
wrote:
> No macros are processed when closing the excel file. Any other pointers ???
> 
> Thanks,
> Yogita.
> 
> -----Original Message-----
> From: KHZ (SAW) [mailto:karl-heinz.zengerle@sawag.com] 
> Sent: Thursday, January 13, 2005 5:11 AM
> To: 'POI Users List'
> Subject: AW: Reading value from formula cell
> 
> 
> Hi Yogita.
> 
> Can you deny that any macros are processed when closing the Excel file?
> 
> Regards,	Karl-Heinz.
> 
> 
> -----Urspr√ľngliche Nachricht-----
> Von: Kashikar, Yogita (SSD Technology) [mailto:Yogita_Kashikar@ml.com] 
> Gesendet: Mittwoch, 12. Januar 2005 23:53
> An: POI Users List
> Betreff: RE: Reading value from formula cell
> 
> I understand that POI doesn't evaluate the formula and Excel does it.
> This is what I am doing:
> 
> -I am creating a spreadsheet.
> -Writing a formula cell.
> -Saving the file to disk
> - then opening it manually. I can see the correct results in the formula
> cell. I close it.
> - then I open the same file in java program using poi
> - read the formula cell using getNumericCellValue
> It returns me the value 0.0.
> Should it not retun me the calculated value ?
> Is it a bug in POI ?
> Is there any alternate solution to do this ?
> 
> We are sort of stuck on this. Would appriciate any quick response.
> 
> Thanks,
> Yogita.
> 
> 
> 
> 
> -----Original Message-----
> From: Kashikar, Yogita (SSD Technology) 
> Sent: Wednesday, January 12, 2005 3:23 PM
> To: POI Users List
> Subject: RE: Reading value from formula cell
> 
> 
> Hi Tony,
> 
> Thanks for your reply.
> I am creating the spread sheet and creating a cell as stated in previous
> message.
> As a second step( after creating the spread sheet and saving in excel
> file) I am opening the excel file and re-reading the formula cell. This
> read is always returning me 0.0.
> What could be the problem with this ?
> Is teher any alternate way to read value from formula cell.
> 
> Thanks,
> Yogita.
> 
> 
> -----Original Message-----
> From: Tony Nelson [mailto:tnelson@starpoint.com] 
> Sent: Wednesday, January 12, 2005 3:17 PM
> To: POI Users List
> Subject: Re: Reading value from formula cell
> 
> 
> Quoting Yogita <yogita_kashikar@ml.com>:
> 
> > Hi,
> > 
> > I am facing difficulties while reading formula cell values with POI
> version 
> > 2.5.
> > 
> > I have created formula cell as follows:
> > 			cell.setCellType(HSSFCell.CELL_TYPE_FORMULA);
> > 			cell.setCellFormula("SUM(D8..F8)");
> > 
> > And I am reading it as follow:
> >    double formulaCellValue = row.getCell((short)
> 7).getNumericCellValue();
> > 
> > When read this way(using getNumericCellValue()), I am always getting
> the
> > value 
> > of 0.0. 
> > 
> > Any quick help in this regard would be highly appriciated.
> > 
> 
> POI does not evaluate formulas.  Excel does that.
> 
> POI simply puts the forumla in the cell.   In order to get a value, you
> would
> have to create the spreadsheet, open it in excel, and then re-read it
> with
> POI.
> 
> This was discussed in detail less than two weeks ago on the list.
> Please read
> the archives.
> 
> 
> 
> This email message from Starpoint Solutions LLC is for the sole use of
> the intended recipient(s) and may contain confidential and privileged
> information.  Any unauthorized review, use, disclosure or distribution
> is prohibited.  If you are not the intended recipient, please contact
> the sender by reply email and destroy all copies of the original
> message.  Opinions, conclusions and other information in this message
> that do not relate to the official business of Starpoint Solutions shall
> be understood as neither given nor endorsed by it.
> --------------------------------------------------------
> 
> If you are not an intended recipient of this e-mail, please notify the
> sender, delete it and do not read, act upon, print, disclose, copy,
> retain or redistribute it. Click here for important additional terms
> relating to this e-mail.     http://www.ml.com/email_terms/
> --------------------------------------------------------
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> 
-- 


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message