ZK - Open Source Ajax Java Framework

I have a database with table which has around 1 million number of rows.

Would ZK Pivot Table will be suitable solution to display data from this table ?

Excel could not handle 1 million rows. I don't think you will find any web display tool which would. If you cannot build the solution in Excel then you are not going to solve the problem in a browser.

Think of Excel Pivot Tables or ZK pivot tables as graphic tools to explore data; not number crunching engines. A database server is a number crunching engine; displaying some of its output in a pivot for the user to explore is likely to be the way forwards.

Older version of MS Excel were restricted to 65536 rows per worksheet.

Excell 2007 brings some good news to this restriction - the number of rows is larger by about 16 times - summing up to 1,048,576 rows.