File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to retrieve data from excel

 
Karthikeyan Ravindran
Ranch Hand
Posts: 32
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All

Please help me to retreive data from two different table of excel sheet.


This is the code which is giving the unexcepted result. And please see the two different table name and the field name too.

Table Name1: Exit
Field Name: Time & CardNo

Table Name2:Entry
Field NAme:Time & CardNo

But the result which I want to see is that:

CardNo,Exit and Entry field should has to come in a new Table.Please take some time values with same card for entry and exit time.

[ June 20, 2008: Message edited by: Paul Sturrock ]
 
Rakesh Chaudhary
Ranch Hand
Posts: 120
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi specify and describe the whole error,,I recently worked with the excel sheets and trust me it gave me the worst night meirs.....but at the end I was able to solve...it
 
Karthikeyan Ravindran
Ranch Hand
Posts: 32
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

Thanks for your valuable reply and could you please tell me the query to retrieve the data from two different excel sheets with the comparision of one same value.

Please see the below table and tell me the query

CardNo Time these two field for Sheet1.
CardNo Time these two field for Sheet2.

I have to take the time from each table when the card numbers are same in the two sheets.
 
Wei Dai
Ranch Hand
Posts: 86
  • 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
>String insert1 = "insert into [Difference$] (CardNo,Exit,Entry) values(?,?,?)";
> ps = conn.prepareStatement(insert1);
It shouldn't be in the while loop.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic