All Questions
177 questions
0
votes
1
answer
9k
views
how to convert byte array to excel file in spring boot
I want to create an excel file from byte[]. and I'm using jxl library in spring boot.
I need a file with XLS format, convert to Base64 and return that.
ByteArrayOutputStream outputStream = new ...
- 133
0
votes
1
answer
1k
views
transferring data read from excel to array
I want to transfer this data to an array to perform mathematical operations with the data I read from excel. how can I do that?
import java.io.IOException;
import jxl.Cell;
import jxl....
- 13
1
vote
2
answers
829
views
how to lock cell while creating an excel (xls) file using a java library
how we can create an excel file (xls) using any java library in a way so that cells are not selectable, i.e.: the user should not be able able to select or copy any of the data.
I know we can achieve ...
- 2,144
0
votes
1
answer
3k
views
get column value from excel based on column names in java
I want to read a excel sheet based on column name in java.
I want to get column values correponding to column name like get TXT_Policy_no in policy no string etc.
as the excel sheet values can be ...
- 25
0
votes
0
answers
366
views
How to create and update Excel files through Java using JXL library?
Everything I have seen on this issue has been in a main method, however, I am working on a larger system and require a class that can create an Excel workbook, sheets and then write into a cell by the ...
- 303
1
vote
2
answers
1k
views
Add a new sheet in an existing workbook with java jxl
I have an application in Java and I manage Excel workbooks with JXL API.
I would like to create a new sheet in an existing workbook that already has a sheet (so I want to create a second sheet).
But I ...
- 147
0
votes
0
answers
99
views
Changing tabs color of excel sheets with Java JXL library
The question I have is, is it possible to change the color of the tabs in an excel by programming them with the JXL library?. I can’t attach code since I don’t even know how I would do it. Thank you ...
0
votes
0
answers
89
views
Excel file downloaded without VBA module
I have developed a code which allows me to download an Excel file based on a prepared template that contains vba code and macro.
The code below allow me to create calendar workbook from template file....
- 217
1
vote
2
answers
5k
views
How to write an array data into excel using java
I have an array of Strings that needs to be inserted into an Excel sheet
I tried with the below code snippet, but only the first value is inserting and for the rest, I am getting null in my console. ...
- 13
1
vote
1
answer
413
views
Java Jxl read/writing to workbook
I have an asset spreadsheet(excel) with decimal mumbers (ie. 30.50), but can only run the code below if the cells are formatted to "no decimal places" (30) otherwise it gives me the error below.
The ...
- 43
1
vote
1
answer
366
views
If string contains with get getContents (JXL)
UPDATE: POSSIBLE SOLUTION POSTED BELOW BY MYSELF
I need my program to read a cell. If it contains a specific string, lets say the name "Jacob", then it needs to execute a certain static function ...
- 21
2
votes
1
answer
138
views
JXL(Java) change to 1904 date system
I need to change date system to 1904 calendar using JXL (rather than 1900 calendar).
Everytime I write something in Excel using JXL API, date system is set to default and I need to change date system....
- 1,009
0
votes
2
answers
267
views
divide excel sheet based on spesific cell values
i have a data sheet in excel about 950000 row with 7 col.and i want to divide it based on V5 col data. V5 holds data for time in seconds into one hour so i need to divide the data into sheets each ...
- 69
3
votes
1
answer
4k
views
Apache POI generates corrupted Excel File
I am using Apache POI to create an excel file with the help of database. I tried searching a lot with different codes and all I got was corrupted excel sheet over and over again. As of now, here is ...
- 37
0
votes
0
answers
849
views
Getting exception java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 , while generating excel file using java
We are getting below exception in log during to generate excel file , we are using jxl version 2.6:
SEVERE: Servlet.service() for servlet [webui] in context with path [/newui] threw exception [...
- 607