Tag: excel

I have a block of code which write data to .xlsx file. I need to write some date in “dd.MM.yy HH:MM” format. All is work properly, but when I try to open result file and test filter work, I got issue with that. Filter perceives dates just like strings, instead of dates, and I can’t get filter with year and

Using Java 1.8, org.apache.poi 5.1.0 and org.apache.poi.ooxml 5.1.0. I have an excel file that consist of 54 rows. I read through this file in blocks of 5 lines. If I get to line 47 it skips that line and gives me the first line of the new block while it should give me the first empty line above the now

I’m trying to copy an existing excel sheet to the same workbook(it contains 3 sheets ) in java using Apache poi . Here is what i did : after running this code, the workbook contains always 3 sheets , the “copy_file” is not created, i’m not getting any errors or exceptions . any idea ? Answer You need to open

I’m trying to update an empty cell in an existing excel file using Java ( Apache POI ), here is the code I wrote, I don’t get any errors and the values aren’t changed either . I get ” its null 2 ! ” in console . Any solutions? Thanks 🙂 Answer You need to open an output stream and

I am using version 4.1.2 of Apache Poi and I have this dataset: String[] headers = new String[] { “Company”, “Status” }; Object[][] sheetData = { {“Company 1”, “OK”}, …