Re: Suggestion on how to read huge excel files.

2015-06-23 Thread Renjith R
time. If yes, i can start contributing. Thaks in advance. Renjith On Thu, Jun 4, 2015 at 10:09 AM, Renjith R wrote: > Able to access this file? Kindly let me know your comments. > > On Thu, May 28, 2015 at 7:04 PM, Renjith R wrote: > >> Uploaded the code to my google dri

Re: Suggestion on how to read huge excel files.

2015-06-03 Thread Renjith R
Able to access this file? Kindly let me know your comments. On Thu, May 28, 2015 at 7:04 PM, Renjith R wrote: > Uploaded the code to my google drive. See if you can access. > > https://drive.google.com/open?id=0BwDzHx011EuvbWpjNEZzanNrV1U&authuser=0 > > com.big.excel.reader

Re: Suggestion on how to read huge excel files.

2015-05-28 Thread Renjith R
, May 27, 2015 at 6:58 PM, Renjith R wrote: > Please see the trailing mails. Thought of sharing it with users too. Let > me know your suggestions. > -- Forwarded message -- > From: "Renjith R" > Date: 26 May 2015 19:50 > Subject: Suggestion on how to

illegal character for 'rgb' on creating report on z/os macnine

2014-06-27 Thread Renjith R
or. Out of curiocity, i checked the Styles.xml inside the excel document. Folowing is what i found. I tried to generate the same report in Windows machine, it gave me correct result. Can any one help me to resolve this issue? -- *RENJITH R* 9446011990

Re: OutofMemory error on using SXSSF

2014-06-05 Thread Renjith R
at 3:32 PM, Renjith R wrote: > I am using SXSSF to write 1 Million(worst case scenario) records. > > Following is the way i have coded it. > I have to write the records to an already existing excel template. This > template is > available in the class path. I will copy this te

OutofMemory error on using SXSSF

2014-06-04 Thread Renjith R
memory is gradually increasing and it ends up in Outofmemory exception. Maximum heap memory size of my machine is about 1.5 GB. Is it an expected behaviour? ie. is it expected to go beyond 1.5 GB while writing record of size ~ 1 Million? -- *RENJITH R* 9446011990

Re: Inconsistancy in row numbers

2014-05-19 Thread Renjith R
to edit the excel file? On Sat, May 17, 2014 at 12:18 PM, Renjith R wrote: > Thanks a lot for the response, David & Scott. > > This is how my excel looks like. > > [image: Inline image 2] > > Following is that data read by SAX parser. I am storing the row numbers 2

Re: Inconsistancy in row numbers

2014-05-17 Thread Renjith R
1(as seen in excel) and apache poi will start at '0' ? On Thu, May 15, 2014 at 5:26 PM, Renjith R wrote: > Hi, > > I am reading an excel file using SAX+XSSF method. While reading I am > saving the row numbers of each row from 'attributes.getValue("r")

Inconsistancy in row numbers

2014-05-16 Thread Renjith R
on is correct or not, if yes, how can i resolve it? -- *RENJITH R* 9446011990

Editing big excel using SXSSF

2014-05-11 Thread Renjith R
ve it. -- *RENJITH R* 9446011990

Re: Validating the excel date for MM/dd/yyyy format

2014-04-25 Thread Renjith R
nks in advance. On Fri, Apr 25, 2014 at 12:31 PM, Renjith R wrote: > Hi, > > I am using Apache POI to read > Excel<http://www.aspose.com/categories/java-components/aspose.cells-for-java/default.aspx> > file(.xlsx) > and validate its contents. > We are having a date

Validating the excel date for MM/dd/yyyy format

2014-04-25 Thread Renjith R
1) 04/24/2014 2) 04242014 I have to accept the first one and reject the second. Since excel stores both these values in integer format, I am not able to differentiate them. Please suggest if you have any idea about how to solve this. -- *RENJITH R* 9446011990