Store number in Excel using Apache POI.

Posted by Manoj on Stack Overflow See other posts from Stack Overflow or by Manoj
Published on 2010-05-06T13:35:15Z Indexed on 2010/05/06 13:38 UTC
Read the original article Hit count: 274

Filed under:

apache-poi

Hi All,

I am using Apache POI to store data in excel sheet. I can store data like "50%" in the cell. Excel also shows up, but it show error like "Number stored as String".

If i click that message and click "convert number to String". It shows perfectly.

How to store it without errror using POI

Related posts about apache-poi

Problem with using APACHE-POI to convert PPT to Image

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I got a problem when I try to use Apache POI project to convert my PPT to Images.My code as follows: FileInputStream is = new FileInputStream("test.ppt"); SlideShow ppt = new SlideShow(is); is.close(); Dimension pgsize = ppt.getPageSize(); Slide[] slide = ppt.getSlides(); for (int… >>> More
Maven jetty download dependencies

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, Why does every time I do "mvn jetty:run", maven tries to download some dependencies (apache poi and ojdbc jars) ? How can I disable this? [INFO] Scanning for projects.. [INFO] Searching repository for plugin with prefix: 'jetty'. [INFO] ------------------------------------------------------------------------ [INFO]… >>> More
How do I determine that an instance of org.apache.poi.hwpf.model.ListData belongs to a numbered lis

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way to determine if an instance of a org.apache.poi.hwpf.model.ListData belongs to a numbered list or bulleted list? I am using Apache Poi's org.apache.poi.hwpf.HWPFDocument class to read the contents of a word document in order to generate HTML. I can identify the list items in the document… >>> More
Java apache poi setting the cell formula

as seen on Stack Overflow - Search for 'Stack Overflow'
I am try to set a cell formulat that references cells from other workbooks. However, when I open the programmatically generated workbook, the formula cells show up as #REF!. I print out the formulas that were generated in a log. If I cut and paste those into the cells, the numbers from the external… >>> More
Where to get apache poi port for .net

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to know if there is a website where I could download the Apache POI ported for .net? I already found this link in the web http://www.apache.org/~avik/dist/poi-2.5.1-dev-20040708.dll But the version of apache poi now is 3.6, I was wondering if there is a latest version out there? Does… >>> More

Developer IT

Store number in Excel using Apache POI. - Developer IT

Store number in Excel using Apache POI.

apache-poi

Related posts about apache-poi

Problem with using APACHE-POI to convert PPT to Image

Maven jetty download dependencies

How do I determine that an instance of org.apache.poi.hwpf.model.ListData belongs to a numbered lis

Java apache poi setting the cell formula

Where to get apache poi port for .net

Categories cloud