I have a problem converting xls files to xlsx and it is that when reading the cells where the dates have the data type in the xls cell, it appears as 13/04/2016 (The data type in the document says custom) but when I generate the new document in...
How can I assign to word that the horizontal sheet creates me ?, by default I create it vertical
XWPFDocument document = new XWPFDocument();
def doc = document.getDocument();
def body = doc.getBody();
def section = body.getSectPr();
if(!sect...
I have:
XWPFTable header = document.createTable(1 , 2);
header.getRow(0).getCell(0).setColor("dbdbdb")
header.getRow(0).getCell(0).setText("titulo")
header.getRow(0).getCell(1).setText("valor1")
When the word is generated, the width of the...
I have a function that creates an excel file, however the function that the excel generates saves on disk. What I want to know is how to get the excel that I generate can be downloaded by pressing a button from a form of primefaces.
xhtml:...
I am doing a converter of xsl and xlsx to csv but I am having problems with the dates. When a date comes to me in one of the cells, does not it remain in dd/mm/yyyy , if not change it to mm/dd/yyy , any solution?...
Is there any way that the values of a column can not be copied in excel?
I tried to make the column not selectable and protected it with a password, but you can still copy the values by selecting the columns on the sides.
I think the solut...
Use Apache POI XSSFWorkbook, when reading a cell with format: 12:55 identifies it as numeric and returns Numero(0.010416666666666666) .
XSSFSheet datatypeSheet = workbook.getSheetAt(0);
Iterator<Row> iterator = datatypeSheet...
One question, I am using apache poi and I would like to know if anyone here knows how to apply a border style to a cellrangeaddress, I am using apache poi 3.14.
I really have little using this tool, what I have done is:
-assign in the cell...
I am using XSSFWorkbook to generate an Excel document (.xlsx), but, I have not managed to apply borders to the cells using:
XSSFCellStyle style3 = workbook.createCellStyle();
style3.setBorderBottom(XSSFCellStyle.BORDER_MEDIUM);
style3.setBor...
I've been looking for a way to generate an excel from java with the correct format for a couple of days. I have to make a table with their column names and above the name of the columns should put a title. The problem is that if a title is added...