Re: Is there any alternative way to cell style for all cells in a row, instead of setting it Cell by Cell

2019-01-25 Thread Greg Woolsey
I often use a "template" document instead of creating a workbook from scratch. This isn't an Excel template (XLST), just a plain XLSX file with no data, only boilerplate like labels. In that file I can define workbook default styles in Excel, table themes, and, possibly most important for you, co

Re: Is there any alternative way to cell style for all cells in a row, instead of setting it Cell by Cell

2019-01-25 Thread Rob Sargent
Define your styles up front, apply the correct style when you make the cell. On 1/24/19 4:47 AM, Venkata Sagar Varma Muppala wrote: Hi, As part of our project, we have to build an excel report, which will have thousands of rows and columns. in this many of the cells in each row will have differ

Is there any alternative way to cell style for all cells in a row, instead of setting it Cell by Cell

2019-01-25 Thread Venkata Sagar Varma Muppala
Hi, As part of our project, we have to build an excel report, which will have thousands of rows and columns. in this many of the cells in each row will have different cell styling like, text in green color, text in red color, different background fills etc.. I have tried applying CellStyle to each

How to limit SetRowStyle() to apply style only to a set of cells

2019-01-25 Thread Venkata Sagar Varma Muppala
using Apache POI, i am trying to setRowStyle() to all rows. but it sets the style to all the cells in a row. Is there anyway to limit that style to a particular number of cells? i know we can set the cellStyle to each cell but that slow downs my execution as i have thousands of rows and columns. So

Re: AW: Problems using poi with JDK 11 in a modularized application

2019-01-25 Thread Andreas Beeker
Hi Achim, But please don't waste your time in explaining it to me when it is easier for you to build it by yourself and not necessary for me to understand. I've tried to change the schema generation via the repackage parameter, which is only available by using the org.apache.xmlbeans.impl.to

Re: Problems using poi with JDK 11 in a modularized application

2019-01-25 Thread discreta discrecion
Please unsusbscribe me Obtener Outlook para Android From: Alexander, Achim Sent: Friday, January 25, 2019 2:32:53 PM To: user@poi.apache.org Subject: AW: Problems using poi with JDK 11 in a modularized application Hi Andi, > We could tr

AW: Problems using poi with JDK 11 in a modularized application

2019-01-25 Thread Alexander, Achim
Hi Andi, > We could try to provide a new XmlBeans version and/or POI schemas with custom > packages, to get rid of the name clash. It would be a great help and timesaver if you can provide me with such a version. At the moment we are just reading and writing data to existing excel files, and