Top "Apache-poi" questions

Apache POI is a Java library for reading and writing various Microsoft file formats, especially Office related ones.

How can I read numeric strings in Excel cells as string (not numbers)?

I have excel file with such contents: A1: SomeString A2: 2 All fields are set to String format. When I read …

java excel apache-poi
Apache POI Excel - how to configure columns to be expanded?

I am using Apache POI API to generate excel spreadsheet to output some data. The problem I am facing is …

java excel expand apache-poi
How do I set cell value to Date and apply default Excel date format?

I've been using Apache POI for some time to read existing Excel 2003 files programmatically. Now I have a new requirement …

java date apache-poi
Cannot import XSSF in Apache POI

I am referencing the version 3.7 of the Apache POI and I am getting a "cannot be resolved" error when I …

java apache-poi
Get Cell Value from Excel Sheet with Apache Poi

How to get cell value with poi in java ? My code is look like this String cellformula_total__percentage= "(1-E" + (…

java apache-poi
How to apply bold text style for an entire row using Apache POI?

How to make an entire excel row cells bold text using Apache POI? E.g: Column headings should be in …

java apache-poi
Merging cells in Excel using Apache POI

Is there any other way to merge cells in Excel using Apache POI library? I was trying using the following, …

java android excel apache-poi
How to read Excel cell having Date with Apache POI?

I'm using Apache POI 3.6, I want to read an excel file which has a date like this 8/23/1991. switch (cell.getCellType()) { ... ... …

java apache excel apache-poi
Cannot get a text value from a numeric cell “Poi”

I'm trying to consume data from a spreadsheet in Excel, but always of this error, already tried formatting the worksheet …

java apache-poi
How to get row count in an Excel file using POI library?

Guys I'm currently using the POI 3.9 library to work with excel files. I know of the getLastRowNum() function, which returns …

java excel apache-poi poi-hssf