Member Avatar for abhi287

Hi all

I want to acess the rows from the excel database with first row the maximum value, then next row with less than maximum and then thired row with less than and so on.. from the same column.

menas values will be displayed as --
first max,then less than first,then less than second and the like..

how should i access in such manner..

plz reply..

  • 4 Contributors
  • 4 Replies
  • 83 Views
  • 18 Hours Discussion Span
  • Latest Post Latest Post by masijade
Member Avatar for masijade 
order by fieldname sort desc

This is an SQL question, not a Java question. In the future find an SQL forum.

Member Avatar for jwenting

no, find an Excel forum. It's an Excel question, not a Java question.

didn't we have this exact same conversation on the Sun forums earlier?

Member Avatar for new_2_java

I want to acess the rows from the excel

If your question is how to access your excel file from your java program, then:

Microsoft offers a driver, by which you can use JDBC to access it. Simply create a data source and you can simply use it like you are using a database. Do a google search on it, i am sure you will find tons of examples and codes.

Member Avatar for masijade

no, find an Excel forum. It's an Excel question, not a Java question.

didn't we have this exact same conversation on the Sun forums earlier?

Yep.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.