python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - xssf

Apache-poi protect sheet locks sheet from autofilter when using Excel O365, but not when using LibreOffice

The issue I am trying to create and populate an Excel sheet while locking specific columns and adding autofilter to the header rows. The application currently generates the Excel sheet with the correc...
test-img

Zaccie

java

excel

apache-poi

xssf

excel-365

Votes: 0

Answers: 0

download an xlsx file with sorted column in Java with XSSF

In my app, users can download an xlsx but now i want to sort this file by alphabetic order for the column 'Supplier' AND by Ascending date for the column 'ETD'. I have a method to create my xlsx file ...
test-img

Kiordan

java

spring

spring-boot

sorting

xssf

Votes: 0

Answers: 1

Latest Answer

You can get the sorted data from database using ORDER BY
test-img

Harichand Hs

removeRow using XSSF libraries is not working

I tried the below code, but it's not working File src = new File("E:\\TestData.xlsx"); FileInputStream fs = new FileInputStream(src); XSSFWorkbook workbook = new XSSFWorkbook(fs)...
test-img

Mitali Jaiswal

java

selenium

apache-poi

xssf

Votes: 0

Answers: 1

Latest Answer

You need to save file after row deletion FileOutputStream outputStream = new FileOutputStream(File Path); workbook.write(outputStream); workbook.close(); outputStre...
test-img

Tarun Dabbs

How to create a new column when editing an Excel file C# NPOI

I am trying to create a new column in the middle of an existing .xlsx sheet, but I can't find any way to do it. XSSFWorkbook workbook; await using (var file = new FileStream(@"File.xlsx", Fi...
test-img

d51

c#

npoi

xssf

Votes: 0

Answers: 1

Latest Answer

I think, that You can operate only just on rows and cells.
test-img

TheNa2rat

Posts

Questions

Blogs

Jobs