All Questions
64 questions
0
votes
0
answers
55
views
UTF-8 issue with excel
I am trying to make excel recognize UTF-8 file and exporting file with UTF-8-BOM file with code
BufferedWriter bufferedWriter = new BufferedWriter(
new OutputStreamWriter(new FileOutputStream(...
- 29
0
votes
0
answers
42
views
problems creating an excel file with Java
I have a unique problem (or maybe not).
We have a tool on a website provided by someone else. This tool uploads an excel file, and then processes it. The excel file has columns and values, and ...
- 1,165
0
votes
0
answers
288
views
How to Convert List to Excel in android?
I took references from Generate excel from android listview and planned to convert List data to excel sheet but the basic functioning of this is not working when clicked on button.
public void ...
0
votes
0
answers
1k
views
How to speed up the formation of excel file?
I have such a code that generates using the POI library. The list contains 250,000 lines. The formation of an Excel file takes 30-40 minutes. Reading about POI, I realized that this is not normal. How ...
- 854
3
votes
3
answers
2k
views
Cannot get boolean value from excel cell
I am getting an error when trying to access a boolean value from an Excel file.
final Cell enabledCell = row.getCell(6);
enabledCell.getBooleanCellValue() // this throws an exception
java.lang....
- 253
0
votes
2
answers
133
views
How can I upload a file multiple times?
This is my code, I am here accept excell file and read it .After than I read of excell file of row values and insert them to database,which to the appropriate columns. At the end, I put the file in ...
2
votes
1
answer
643
views
cellIterator.hasNext() returns false even the cell has value
I use the following approach to read data from excel (csv) sheet:
InputStream inputStream = new BufferedInputStream(multipartFile.getInputStream());
XSSFWorkbook myWorkBook = new XSSFWorkbook(...
- 1
0
votes
1
answer
2k
views
Java 1.6 Encode Base64 inputStream of a Excel file byte[] stream
I have been searching the web for this particular problem. Maybe I'm doing something wrong or I'm missing something here...
I'm trying to convert a file stream (an Excel file) -> mimetype (...
- 978
2
votes
1
answer
14k
views
Java POI - convert Workbook to File
I need to return a Workbook but converted to Java File object.
For now I only know how to write the Workbook to the disk with workbook.write(outputStream). However, I want to return the File object in ...
1
vote
1
answer
68
views
How to print the correct values input from a .csv file -- JAVA?
When I run the test program it just returns zeros instead of years. I can't figure out why. It seems like the stats are calculating correctly. I need for it to display the years for the range of ...
- 11
0
votes
0
answers
559
views
Writing Excel file with Java
I am writing a functionality to write and save Excel file.
In the first case, the code is working and properly saving a valid .xlsx file in Eclipse folder (however it overwrites previous file if used ...
- 157
0
votes
0
answers
282
views
How to write xls file in java?
I tried out this approach: link
It works fine with csv file, but i need to do the same for .xls file
In java side
public StringBuilder columnsForCsv(){
StringBuilder result = new StringBuilder()...
- 233
1
vote
0
answers
142
views
How to protect metadata in a office file which was generating by java?
I have a issue, but i cannot find out a way to resolve it:
I generate a word file or a excel file using java code. But i don't know how to protect its metadata.
I do right click on the file, choose ...
- 11
0
votes
1
answer
226
views
Writing to csv/excel based on header in Java
I have a JSON which has entries that look like
[{ "key": { "keyLabel": "Label1" }, "specs": [{ "specKey":
"spec1", "specValue": ["s11"] }, { "specKey": "spec2",...
- 7,133
0
votes
0
answers
21
views
I have to convert English filename to some other international language using java
I'm facing an issue while encoding the zip file name into UTF-8. This is my code.
String filename1=URLEncoder.encode(fileName,"UTF-8");
"fileName" is the name of the zip file name. Please anyone can ...
