Value Format While Reading Excel Data Into Java
Jan 20, 2015
I am reading Excel data using java apache. I got format issue while reading double value such as 869.87929 (in excel) into 869.8792899999999 (in java).
I'm using following files to read excel data.
1. Schema.csv: SheetName,2-int-Double
2. File.xls:
col1 | col2
123 | 869.87929
Sample code:
if(type.equals("Double")){
String str = content[i-1];
//System.out.println(str);
BigDecimal d = new BigDecimal(str);
listObjects.add(d);
}
Note: type from schema.csv & content [] value from file.xls
If I print **str**, it shows value as 869.8792899999999.
But i need to get **str** value as 869.87929. How can I get it?
View Replies
ADVERTISEMENT
Feb 20, 2015
I am working on a project where as an input I need to read to data from PDF.
The PDF data will look like
As shown below:
Serial NoName of bookQuanity of BooksLibrary NamePrice
1aaa1London
2bb2Newyork
3cc1Paris
Total number of books4
Payment info
The number of books are dynamic in every pdf which I am going to receive.
View Replies
View Related
Apr 23, 2015
I am trying to get the excel spreadsheet data and converting it in someway to java. I'm looking for something that will print out the java code itself that way I can embed it into future projects.
View Replies
View Related
Nov 5, 2014
How to we append data in an excel sheet through Java ?
View Replies
View Related
Aug 3, 2014
import data from excel sheet into mysql database through a java program. How coding will be done in Core Java.
View Replies
View Related
Oct 19, 2014
If I want to load data in excel file into table. what is the best way to do it?
View Replies
View Related
Mar 6, 2014
i have to write more than 100000 rows in a excel sheet (file size more than 20 MB) via java.
when i use XSSF, i am getting below Error.
java.lang.OutOfMemoryError: Java heap space
at org.apache.xmlbeans.impl.store.Saver$TextSaver.resize(Saver.java:1592)
at org.apache.xmlbeans.impl.store.Saver$TextSaver.preEmit(Saver.java:1223)
at org.apache.xmlbeans.impl.store.Saver$TextSaver.emit(Saver.java:1144)
[Code]....
when i use HSSF , i am getting the below Error.
java.lang.OutOfMemoryError: Java heap space
I have tried increasing the java heap size , by giving upto -Xms1500m -Xmx2048m
View Replies
View Related
Apr 6, 2015
I am currently working on an application with java and I want to do is upload and download details in .xlsx file. Uploading process is successfully worked but the problem is that when I download the file .xlsx with details at opening the file it gives me the following message :
Excel cannot open the file '(filename)'.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
View Replies
View Related
May 22, 2012
In my project i am facing an problem, The My SQL Data base will accept the date format of yyyy/mm/dd only as "Date" data type but in my program i wants to use dd/mm/yyyy format. (i have this same format now) that's why I am unable to insert / retrieve it..
View Replies
View Related
Feb 4, 2014
This is the code for reading and sending the mail
package com.abhi;
import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.io.InputStreamReader;
[Code] ....
Its showing error like..
BIFFVIEWER REQUIRES A FILENAME***
java.lang.NullPointerException
at java.io.FileInputStream.<init>(Unknown Source)
at java.io.FileInputStream.<init>(Unknown Source)
at org.apache.poi.hssf.dev.BiffViewer.run(BiffViewer. java:68)
at org.apache.poi.hssf.dev.BiffViewer.main(BiffViewer .java:649)
View Replies
View Related
Jan 20, 2015
A method in Java returns a schema. In .net, we use DataTable to get the data from the schema. How to write the following code in Java:
/* Result r = method();
r.DataSchema; */
using (DataTable tbl = new DataTable())
{
using (MemoryStream ms = new MemoryStream())
using (StreamWriter sr = new StreamWriter(ms))
[code]....
View Replies
View Related
Feb 8, 2014
We have an autosys job running in our production on daily basis. It calls a shell script which in turn calls a java servlet. This servlet reads these files and inserts the data into two different tables and then does some processing. Java version is 1.6 & application server is WAS7 and database is oracel-11g.
We get several issues with this process like it takes time, goes out of memory etc etc. Below are the details of the way we have coded this process.
1. When we read the file using BufferedReader, do we really get a lot of strings created in the memory as returned by readLine() method of BufferedReader? These files contain 4-5Lacs of line. All the records are separated by newline character. Is there a better way to read files in java to achieve efficiency? I couldnt find any provided the fact that all the record lines in the file are of variable length.
2. When we insert the data then we are doing a batch process with statement/prepared statement. We are making one batch containing all the records of the file. Does it really matter to break the batch size to have better performance?
3. If the tables has no indexes defined nor any other constraints and all the columns are VARCHAR type, then which operation will be faster:- inserting a new row or updating an existing row based upon some matching condition?
View Replies
View Related
Oct 5, 2014
How to append the data in excel .. Checking the file if its known or unknown then save it to excel file like example
when i first run the program 3 files there in excel
when i run for the second time same it will be 6 files there in java
Here is the code
public String QueryACL(String myFilePaths) {
try {
SHAOneReported = new PrintWriter(new FileOutputStream(TodayDate.format(date) + "-SHA1SummaryReport.xls", true));
} catch (FileNotFoundException exc) {
JOptionPane.showMessageDialog(null, "File not Found.");
[Code] ....
View Replies
View Related
Feb 8, 2015
I am creating a program where it reads the data inside a file and then places this data into arrays. The file I created has numbers 1-30 in it, file named, testing1.txt .
Java Code:
public static void main(String[] args) {
// TODO Auto-generated method stub
// Variables Declaration Section
//******************************
BufferedReader br;
String sCurrentLine;
String str;
[Code] ....
My issue is that the 'str' value is not initialized, but if I initialize it, it ruins the code. I'm not sure what to do in the situation.
View Replies
View Related
Apr 10, 2014
Here's a link to it : [URL] ....
The basic gist is it's "A program that reads in a text file that uses a specific input format and uses it to produce a formatted report for output."
Specifically :"For this lab you will write a Java program that produces a simple formatted report. The program will prompt the user to enter a file name. This file must contain information in a specific format (detailed below). Each "block" of the file contains information for one player in a competition -- the name of the player followed by a number of different scores that that player achieved. The program should find each player's average score, median score and best and worst scores and display them in a line on the final summary report. The program should also determine which player has the highest average score and which player has the lowest average score."
I get the following errors when I try and compile it:
Enter an input file name: Project11.txt
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException... -1
at java.util.ArrayList.elementData(Unknown Source)
at java.util.ArrayList.get(Unknown Source)
at Project11.getMedian(Project11.java:68)
at Project11.main(Project11.java:27)
I get that the error(s) reside in lines 68 and 27, among problem other areas, but I'm not exactly sure how I can fix them.
Here's my code:
import java.io.*;
import java.util.*;
public class Project11 {
public static void main(String[] args) throws IOException{
Scanner in = new Scanner(System.in);
System.out.print("Enter an input file name: ");
String input = in.nextLine();
[Code] ....
View Replies
View Related
Jul 19, 2014
I am using JSF,richfaces. Need to import data from Excel file and show it in datatable.
How to achieve this?
View Replies
View Related
May 27, 2010
I have a requirement to download the data from DB to CSV/Excel. What I did is retrieving all the records from DB and store in the List and pass that list to the jsp page. In JSP page, I am using the below setting to download it to CSV/EXCEL.
response.setContentType("application/vnd.ms-excel");
String fileName = "Report"+System.currentTimeMillis()+".xls";
response.setHeader("Content-disposition","attachment;filename="+fileName);
It was working fine. But I have an issues in it. Excel is capable of storing it only 65,536 rows. Even all the data getting downloaded to CSV/excel (> 65,536), while saving I am getting error from excel saying that it can't save more than 65,536 rows and the below data won't be saved.
This workbook contains data in cells outside of the row and column limit of the selected file format.
Data beyond 256 (IV) columns by 65,536 rows will not be saved.
Formula references to data in this region will return a #REF! error.
I am not opt for POI apache third party at this point of time. Is it possible to download it in other sheets if it exceeds the max limit.
Example: Having data of around 100,000.
Download 65,536 - Sheet 1
Remaining in Sheet 2,3.. of the same excel.
View Replies
View Related
Jun 9, 2014
Export data to excell using XSSFWorkbook ... I am having error
javax.el.ELException: java.lang.OutOfMemoryError: Java heap space
Now I what to modify my code to BigGridDemo.java
[URL] ....
[URL] ....
How can I modify my code to BigGridDemo.java. This is my code
import com.bea.common.security.xacml.context.Result;
import com.sun.jmx.snmp.Timestamp;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.OutputStream;
[Code] ....
View Replies
View Related
Jun 9, 2014
I have to export data to excel using XSSFWorkbook
I am having error javax.el.ELException: java.lang.OutOfMemoryError: Java heap space now i what to modify my code to BigGridDemo.java
org.apache.poi.xssf.usermodel.examples: BigGridDemo.java
POI - User - HSSF and XSSF memory usage, some numbers
How can i modify my code to BigGridDemo.java
Java Code:
import com.bea.common.security.xacml.context.Result;
import com.sun.jmx.snmp.Timestamp;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.OutputStream;
import java.util.HashMap;
[Code] ....
Currently am geting this error with above code
<FileDownloadActionListener> <processAction>
javax.el.ELException: java.lang.OutOfMemoryError: Java heap space
at com.sun.el.parser.AstValue.invoke(Unknown Source)
at com.sun.el.MethodExpressionImpl.invoke(Unknown Source)
[Code] ......
View Replies
View Related
Apr 2, 2014
I'm trying to insert data into an excel sheet with the below Servlet.
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
import java.beans.Statement;
import java.io.IOException;
import java.io.PrintWriter;
import java.io.StringWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
[Code] ....
But it is giving me the below Exception and stacktrace
java.text.ParseException: Unparseable date: "2-Apr"
at java.text.DateFormat.parse(DateFormat.java:357)
at Serv1.doPost(Serv1.java:53)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
[Code] ....
i found that the problem is within the date field(, if the problem is with the date, how i can fix it and where am i going wrong.
View Replies
View Related
Jan 31, 2014
Recently we got an issue about file download. We are using below code to fetch the data from backend(DB2) and export to excel.
Before Jan 15 it use to take 2 minutes to download the file (2 MB size). But now its taking half an hour to download.
response.setContentType("application/vnd.ms-excel");
response.setHeader("content-disposition","attachment; filename=Attendance_Report.xls");
We have restarted server, system but still problem exists. We found that there is no code level or data base level or network level issues.
Now we have to see server level issue. What are the factors which effects the file downloading at server level.
We are using websphere 6.1 ,java1.4
View Replies
View Related
Mar 26, 2014
The below is the existing data in a file running over 24768 lines
There are duplicate names link (abc) , width and FLof which stands for offset
file A
------------------
###########################################################################
# F Name Gro Width FLof Class
###########################################################################
1cbb abc - 6 2 INDIRECT
1cbc xyz - 3 0 INDIRECT
1cbd abc - 4 0 INDIRECT
1cf3 bcd - 3 5 INDIRECT
1cf4 pqr - 3 0 INDIRECT
1cf5 bcd - 8 0 INDIRECT
---------
---------- so on
I want a script to convert the file data to as folowing data :
file B
-----------------
###########################################################################
# F Name Gro Width FLof Class
###########################################################################
1cbb abc_7_2 - 6 2 INDIRECT
1cbc xyz - 3 0 INDIRECT
1cbd abc_11_8 - 4 0 INDIRECT
1cf3 bcd_7_5 - 3 5 INDIRECT
1cf4 pqr - 3 0 INDIRECT
1cf5 bcd_15_8 - 8 0 INDIRECT
Explanation for conversion is here :
first row abc has width as 6 and FLof as 2 in file A, so it occupies position 2,3,4,5,6,7 accounting to 6 position so represented as abc_7_2 in file B
Now row three of file A has duplicate of abc so now the new offset will be previous offset plus one ie. position will start from 8 and it goes as follows 8,9,10,11 so represented as abc_11_8
This will create unique and informative names, the same goes with other rows :
</pre> mh_sh_highlight_all('xml');
View Replies
View Related
Jul 16, 2014
When I am trying to read data from BufferedReader and writing into excel using FileOutputStream object with POI APIs then i am getting the data in excel file in bad formats. you can check the log file and excel file attached for more information.
Here my problem is I cannot use BufferedWriter in place of FileOutputStream because POI class XSSFWorkbook only have one write method and we can only pass FileOutputStream class object there.
public void readFile()throws IOException {
BufferedReader inputStream = null;
FileInputStream fis=null;
InputStreamReader isr = null;
//Blank workbook
XSSFWorkbook workbook = new XSSFWorkbook();
[Code] .....
View Replies
View Related
Apr 22, 2015
The intent of the code is to read date from a file, does calculation and then displays that data in a table format on the screen. Then creates another file with those values:
Reads file: Beginningbalance.txt
Displays Data with calculation
Creates a file called "Newbalance.txt" with the following values:
111
251.41
222
402.00
With the way the code is written I can get it to create the file but it only displays one of the customers (111). I know that I need to create a loop but I am not sure how to build that. I tried creating another while loop and changing it to outFile but that was without success.
import java.io.*;
import java.util.Scanner;
import java.text.DecimalFormat;
public class Output {
public static void main(String[]args) throws IOException {
[Code] .....
View Replies
View Related
Jan 21, 2015
I have two programs that talk to each other over a TCP connection. When I write the data "STX+1234" where STX is the Ascii character STX or Ctrl B and I expect the written String length to be 6 which it is. On the other side of the socket I create the ServerSocket and use the client socket's InputStream to create a BufferedReader. When I receive the string it now has 12 characters where each original character has been replaced by NUL and the character. How do I read the string as it is originally specified without the conversion? And is the problem on the reader side or the writer side?
View Replies
View Related
Oct 11, 2014
Ok so I know how to import a csv using java. What I'm curious about doing is importing a csv using file chooser, reading the data, sorting the data out by certain parameters, and then outputting a count of each parameter I chose. Say for example I have columns 1,2 and 3. Column 1 has the name, column 2 has the percentage, column 3 has an o'clock time. I want to use queries to sort through the parameters and have a count of each parameter I choose...
View Replies
View Related