Questions tagged as 'apache-poi'

Tagged questions
1
answer

Spring 4 - Apache POI - Security: Error 403 when generating Excel spreadsheet

I'm in a project with Spring MVC 4, and I need to generate an Excel with a set of data on the screen. For this I use Apache POI to make the generation integrating it with Spring. However, when the file download runs, I get a 403 error. The appli...
asked by 13.12.2016 / 21:25
2
answers

Export recursive listing directories

I'm doing a recursive directory tour and I want to export the directories and files found to an excel file. This is my code package packages; import java.io.File; import java.io.FileOutputStream; import org.apache.poi.xssf.usermodel.XSSFCell;...
asked by 08.04.2016 / 17:36
1
answer

Excel generation with Apache POI, do not write in the same line in different cells

I am currently working on the generation of an Excel, this is done by supporting me from Apache POI. I found myself with a problem when writing the information in Excel, this is because with the code that I'm doing I can not write two different...
asked by 03.01.2019 / 22:19
1
answer

JMenuItem does not work correctly in JFrame

I have a window created with a JMenuBar placed at the top. Until then I had 2 JMenuItems that worked as a button and opened another frame. Until then everything works correctly. Today, I have the need to put another item to that menu, and follow...
asked by 20.12.2018 / 12:39
0
answers

How to combine cells in excel using Apache POI in Java?

I request help in the combination of cells when creating excel with apache POI, the cells are combined without problem using sheet.addMergedRegion(new CellRangeAddress(0,0,0,1)); , however, it only shows me the values on the left and the v...
asked by 28.11.2018 / 22:07
0
answers

how to use JFileChooser in a servlet and call this servlet from a jsp so that it allows to select the location where you want to save the file

I have this main that works correctly: public static void main(String args[]) throws IOException, Exception { JFileChooser chooser = new JFileChooser(); chooser.setCurrentDirectory(new java.io.File(".")); chooser.setDia...
asked by 05.11.2018 / 22:04
0
answers

configure JProgressBar when assigning the .xls to WorkbookFactory poi java

I am using the Apache POI library in a JAVA project to work with Excel files and I need to show the load percentage in a JProgressBar when this line is executed: libro = WorkbookFactory.create(new FileInputStream(ruta)); Note: I already kno...
asked by 31.10.2018 / 23:13
0
answers

Overwrite word templates with Apache POI

I have a template created in word and what I want is that using Apache POI replace variables in that template. For example: in my template word I put the tag $ {address} and in my code java I do the following: try (XWPFDocument template = new...
asked by 06.09.2018 / 01:23
0
answers

eclipse Ant Build build.xml

I am using apache poi and the poi.jar does not contain the xssf package to work with XSSFWorkbook, this is done with the jar poi-ooxml.jar. In eclipse it works correctly, but when I compile with Ant Build, the functions related to XSSF do not wo...
asked by 24.08.2018 / 13:29
0
answers

excel sheet printing with poi and netbeans

I have a question I'm doing a project with poi and java everything comes out perfectly but they ask me to print the excel sheet listed as well as modify the print to make it look bigger letters, can this be done inside the code ?     
asked by 23.08.2018 / 23:36