All Questions
83 questions
0
votes
1
answer
204
views
getting a blank line as first line in apache poi spreadsheet creation
Recently upgraded from poi-2.5.1 to poi-4.1.2 and what is happening is that a blank line is being inserted as the first line in the resulting .xls file. This was determined from comparing the file ...
1
vote
3
answers
7k
views
Reading Excel File Column in Java
I have a sample of Excel data that needs to be read and store in the database.
Example:
Code | BO1 | BO2 | BO3 | .....
10001 | 200.00 | 400.00 | 0.00 | .....
10002 | 0.00 | 100.00 | 500....
- 63
1
vote
0
answers
314
views
How to export HTML table to Excel (xlsx) in JSP?
I need to export an html table to Excel with xlsx format in my .jsp file with font edition (I need my headers in bold).
Hello,
I'm trying to do an excel export from html (html table) with font ...
- 57
0
votes
0
answers
218
views
how can I modify exporting .xls to xssfworkbook
I have used HSSFWorkbook for importing .xls files but I need to import both .xls and .xlsx files using XSSFWorkbook. I need to convert both hssf sheets and xssf sheets into MySQL database..
Someone ...
0
votes
1
answer
4k
views
How to convert a jsp file into excel file in .xlsx format
We are using page content type as below. The excel file(.xlsx format) generates correctly from the application. But not able to open it. While opening it's giving a blank page.
<%@ page ...
1
vote
2
answers
2k
views
How to download a file from Java Controller to javascript
In the html file I have a table with the contacts of employees.
The table has different filters and there is also a download file button.
When the button is pressed, the function is called
function ...
0
votes
0
answers
16
views
Generated excel has contents for one user, but only headers for others?
I have a pre-written code about which I do not have much knowledge.
So I need some help to understand what exactly is being done over here.
The generated excel contains content for one user, but ...
- 112
1
vote
1
answer
389
views
How to download excel sheet which fetch resultset from database
I have used Apache POI library and generated excel sheet from database using query to obtain list of doctors and their details. I have to go to the below mentioned location "C:\Users\Mohan\Downloads\...
- 11
3
votes
1
answer
6k
views
Could not initialize class org.apache.poi.poifs.filesystem.FileMagic
while uploading .xlsx java.lang.NoClassDefFoundError: Could not initialize class org.apache.poi.poifs.filesystem.FileMagic and while uploading .xls file getting error java.io.IOException: Unable to ...
- 41
2
votes
2
answers
539
views
How to view excel file in jsp page using java code?
How to view Excel file in JSP page using Java code?
I want to show the Excel page directly in JSP page not only the data. Fully Excel page with Excel format.
public static void main(String args[]) {
...
0
votes
1
answer
672
views
How to enter data from excel sheet to mysql database using JSP? JSP + Servlet + MySQL Project
So, basically what I want to do is, on a jsp page give option to browse and select an excel file. Then when the user clicks on Upload button, the data from excel is saved into database table.
I am ...
- 921
0
votes
0
answers
75
views
Connecting independent Excel File Upload and Parsing Code in Java - NewBee :)
I have a .jsp file and a Controller (.java file) to upload an excel file. I have an another java code to read an excel file. Both the codes are working fine independently. My question is how do I ...
0
votes
1
answer
444
views
Uploading excel in servlet
I’m trying to upload an excel in servlet and process it. While uploading I set enctype=“multipart/form-data” in my form. But in my servlet .isMultiPart(request) returns false.
JSP code:
function ...
- 143
-1
votes
1
answer
2k
views
export html table to excel sheet using javascript or java [closed]
I am trying to export a table in a jsp page to excel sheet using a button. The button on clicking should give a dialogue box to save or cancel. I need the code using java or javascript.
- 33
0
votes
1
answer
595
views
java.lang.OutOfMemoryError: GC overhead limit exceeded Error while Reading Macro enabled excel sheet through Apache POI
I have a Macro Enabled Excel file in XLSM format. Inside this excel, 2-3 dependent dropdowns are there. I have written a macro code to stop delete for a particular column.
I am uploading this excel ...
- 15