I am creating Excel file using apache XSSFWorkbook. I need to draw the chart so I am using another excel as a templete file. Chart is getting created using template but chart is showing empty space for the rows that I have data in template file but not in my output file. How to modify chart data rage so my chart will show data only for the rows that I have populated in output excel file.

I am creating Excel file using apache XSSFWorkbook. I need to draw the chart so I am using another excel as a templete file. Chart is getting created using template but chart is showing empty space for the rows that I have data in template file but not in my output file. How to modify chart data rage so my chart will show data only for the rows that I have populated in output excel file.

I am processing an .xlsx using Java and Apache POI. I read a .xlsx row, process the data, store it in an object then do operations on it. Then, I do that to another sheet. I use multiple ways to read the rows, including formula evaluator. For some reason, when I get to the next sheet it recalculates the values of the formulas and I want them to stay the same.