Questions tagged as 'apache-poi'

1
answer

Convert PDF to DOC

Is it possible to convert a PDF to a word document by keeping all formatting, alignments, fonts and tables in the converted document using apache-poi or some other api?     
asked by 22.04.2015 / 17:01
1
answer

Can not get a text value from a numeric cell "Poi"

I'm trying to consume data from an excel spreadsheet, but I always try to format the spreadsheet for text and number, and even then the error persists. How do you arrange this? I saw that a person resolved using this cell.setCellType(Ce...
asked by 08.05.2015 / 15:42
1
answer

HSSFWorkbook - How to copy one worksheet to another? [closed]

I have an excel worksheet that I need to copy some data to another worksheet. This old spreadsheet is like a "base", I need to copy only the header and caption part (with the style of the cell, in addition to the text). I'm using the HSSFW...
asked by 05.09.2017 / 20:21
2
answers

Toggle the colors of a column using the java library - apache poi

I'm using java with the api poi library to create an excel spreadsheet. I need to keep alternating colors, from the 1st column (that is from department), between yellow and blue, when the data are different too.Ex .: Dep = 1 - Color = yellow...
asked by 20.09.2017 / 20:23
1
answer

Formula Excel - Apache POI

I created an excel file using the Apache Poi API, in it I set one of the cells with a formula, but when I open the file I need to "enter" in the cell with the formula so that it will print the result in the file. Would there be a way to make thi...
asked by 10.11.2017 / 17:19
1
answer

What do I do to read a column in excel with very large numbers?

How do I read a column of excel whose number is too large and prevent it from being interpreted as overflow? In Excel, the column has the number 26468314801 . As a number it loads 2.6468314801E10 , I looked for the solution and so...
asked by 15.10.2015 / 18:58
0
answers

Apache POI - How to put Hyperlink in an image in Excel?

This is the method I use to put images in Excel: public void insertIcons(String URL, Sheet sheet, int colBegin, int colEnd, int rowBegin, int rowEnd) { try { InputStream iconInput = new FileInputStream(URL); byte[] byteTran...
asked by 07.01.2018 / 19:28
0
answers

Problem to read formulas using Apache POI

I'm creating a method to hide elements that are zeroed out of an excel file, but the problem is that it can not pick up the values when the column is a formula. How can I get these values? My code: private static ByteArrayOutputStream ocult...
asked by 02.05.2016 / 22:30
1
answer

Error message after opening an Excel file generated by an application

I have an application that reads a xml file, takes the data and passes it to a file in xls format. But when I open the file that was gerardo the following message appears: Would anyone explain the cause of this error?    ...
asked by 24.07.2015 / 13:52
2
answers

Java error when inserting image into worksheet. Apache Poi

I'm trying to insert an image into a sheet using Apache POI, but I'm getting the following error: 03-03 20:21:50.898: E/SELinux(28413): selinux_android_seapp_context_reload: Error reading /seapp_contexts, line 16, name levelFrom, value contain...
asked by 04.03.2016 / 00:57