Tagged Questions

Apache POI is a Java library for reading and writing various Microsoft file formats, especially Office related ones, based on OLE2 and OOXML, such as XLS and DOCX.

learn more… | top users | synonyms (1)

0
votes
3answers
27 views

Read Excel Numeric cell values as they are in Java

When I am reading excel numeric cell values, i am getting the output with decimals. eg: 79 is reading as 79.0, 0.00 reading as 0.0. The code for my application I have written is: int type = ...
-1
votes
1answer
23 views

Apache poi - customize text cell

how can I set in apache poi library customize text to cell? E.g.: I have got one cell, but text it's longest than cell, so, I like format text as in excel - adjust the text size cell. Thank you.
1
vote
0answers
15 views

How can I 'ignore' images when reading in a document with Apache POI?

When I read a document with Apache POI, even if I do nothing with images they are still read in. Is there a way to 'skip over' the image reading part of the code? We have a lot of documents to read, ...
0
votes
1answer
26 views

How to store values from excel to some collection in java

i have a excel file like the following, **Method Name** **Status Code** **user** **password** getLoggedinUserDetails 400 anto test createRequisition ...
1
vote
0answers
30 views

Converting doc into PDF in android,Unable to execute dex

I am converting doc file into pdf format in android using following libraries, itext-1.4.8.jar poi-3.0-FINAL.jar poi-scratchpad-3.2-FINAL.jar here is my sample code package ...
0
votes
0answers
6 views

Autofilter in apache POI range not working

Does anyone know what could be wrong with the following filter I am trying to set for a report generated with apache POI? I'm using this code: sheet.setAutoFilter(CellRangeAddress.valueOf("A4:A6")); ...
0
votes
1answer
15 views

How to read docx file content in java api using poi jar

I have done reading doc file now i'm trying to read docx file content. when i searched for sample code i found many, nothing worked. check the code for reference... import java.io.*; import ...
0
votes
2answers
28 views

XLS - Conditional Formatting - Java POI Example

:) Finally after the research I found the solution to my problem, which is not yet satisfied I would like to use conditional formatting to show a line with a yellow color if column B and C to the ...
0
votes
0answers
18 views

XLSX removing sheets OutOfMemory Exception

I am trying to load the XLSX file using POI library that has 5 sheets. Size of the file is 5 MB. Total records in all sheets are around 30,000. Once the file is loaded i need to delete the 1 or more ...
0
votes
1answer
39 views

Conditional format on Excel file

Is that possible to do some conditional format on Excel file with JXL or Apache POI or something else? API java Like Macro VBA for example? ' Mise en forme couleur pour différence For i = 3 To fin ...
0
votes
1answer
24 views

How to group the values which are in excel to a HashMap

i have the following excel: Method Name Status Code getLoggedinUserDetails 400 createRequisition 400 excelMDM 400 and i am able to print the values as they are in excel using ...
0
votes
0answers
13 views

JExcel formatcondition java [duplicate]

I'm new on JExcel jxl API . I wloud like to add this formatcondition on my program java with jxl but I don't get any tutrorial or any thing ..is jxl not have this methode this is my exemple with ...
0
votes
2answers
37 views

How to format the values which comes from excel using java

I have a excel file with some values like : **Status Code** **Method Name** 400 createRequest 401 testRequest 402 mdm 403 ...
0
votes
0answers
45 views

POI Apache - Excel - number of page

I'm using POI Apache for create *.xls. I need write to file about few pages and when I begin write new page, I need write something, but it isn't directly top. It's few rows. How can I do it? It is ...
0
votes
0answers
11 views

Arabic language support for word doc using java poi api

I am using XWPFDocument,XWPFParagarph and XWPFRun POI 3.7 classes to generate .docx file with hardcoded arabic text in it.But there's a problem in text appearance as explained below: hardcoded arabic ...
0
votes
0answers
24 views

Unicode Filtering Problems

I have a small Problem in Java. I am using Apache POI to get Text from doc, pdf and docx Files. However, its getting some weird symbols and signs that I can't seem to get filtered. Somehow I even cant ...
-3
votes
0answers
14 views

How to evaluate Correl function using Apache POI [closed]

I need to evaluate a cell which contains Correl function. Is there a way to achieve it using Apache POI? I have .xlsx spreadsheets.
-6
votes
0answers
20 views

List conversion for apache poi [closed]

I'm new to Apache POI. and I'm trying to export List< EmployeeInfo > into an Excel file. This List contains emp name, id, address, etc. What are my options to convert Employee List and ...
0
votes
1answer
22 views

Spring MVC / AbstractExcelView / Apache POI : File Error

I'm using Apache POI and extending Springs AbstractExcelView to create Excel sheets. public class ExcelSpreadsheetView extends AbstractExcelView { protected void buildExcelDocument(Map<String, ...
1
vote
1answer
34 views

How can I open an xls file, save it, and then close it all in java?

How can I open an xls file, save it, and then close it all in java? I currently have a workaround where I make java write a vbs script that does the same thing Set excel = ...
1
vote
0answers
28 views

Counting pages in a Word document

I'm trying to count pages from a word document with java. This is my actual code, i'm using the Apache POI libraries String path1 = "E:/iugkh"; File f = new File(path1); File[] files = ...
0
votes
0answers
16 views

how to draw line using setShapeType in apache poi XSSF usermodel

I'm updating the code to use 3.8 poi, so I'm changing the code from HSSF to XSSF. I have setShapeType to OBJECT_TYPE_LINE in HSSF, how to change the setShapeType for XSSF usermodel. I need to draw a ...
-1
votes
1answer
9 views

Apache POI removing picture from template when setting auto filters on columns

Using Apache poi 3.7 HSSF package to generate xls file from a template. The template xls has png picture. After calling HSSFSheet.setAutoFilter method the picture is disappearing in the generated xls. ...
0
votes
0answers
29 views

autoSizeColumn POI Java is not working properly

I am using POI 3.9 & jdk1.6.0_14. I am using the below code to autoSizeColumn, but the issue is when the excel is generated, its not completely autosized to column, when i double click on between ...
0
votes
2answers
10 views

XSSF prefix for POI

I am not able to use XSSF prefix for POI . When i run the code following error is given . Please help me out Error:run: Exception in thread "main" java.lang.NoClassDefFoundError: ...
0
votes
0answers
23 views

Unable to append rows in excel using POI api in java

I am trying to append rows to an existing excel using POI api following the steps mentioned below: try { lFout = new FileOutputStream(lOutputFileName); lFin = new ...
0
votes
1answer
27 views

locking the cell value in excell sheet

I have generated an excel using Apache POI, anf the excel sheet is generated succesfully now the issue is that in my generated excel if somebody forcefully remove the cells value and add the new value ...
0
votes
2answers
42 views

Reading excel 2007 and writing file in java

I want to retrieve file from ftp server, I have also used Apache poi client.retrieveFile() method, but I'm unable to open it which is showing: excel cannot open file check file extension and file ...
-4
votes
0answers
26 views

Fetching Data from database and putting in excel sheet [closed]

I have to develop an application in which data is stored in an Oracle database. I need to fetch that data from the database and export into an Excel sheet. For that I need to use Apache POI and ...
0
votes
0answers
27 views

Apach POI, convert xls (excel 2003) to xlsx (excel 2007)

I would like to convert a xls to a xlsx file. Since I have only one tab, is it best to just iterate the rows and cells and copy them from one sheet to the other? Should the API provide a why to set ...

1 2 3 4 5 … 49
15 30 50 per page