I may not be asking something new but I have searched couple of other questions related to this. But didn't really get an idea. so I have a very simple excel file with about 5 worksheets. Each worksheet has about 10 columns and about 50 rows. Number of rows will never go beyond 200-300. So Data is not a lot. Till now we add update all the data in excel. But now we need some desktop based application which can give us a nice UI to see this data. We also want to move this data from excel to some embedded db like h2. But I am not sure about the technology I should be using to build this desktop based application. I was thinking about building it in Java Swing. But I am not sure if that will be a good idea. We want to keep it simple. Is there any good framework in Java or some other technology which is platform independent. Where I can easily represent my database on UI in a good way. Also if it is possible to have something where user should not be asked to install anything. Like java is mostly present on most of the computers today. I will be thankful for your advice.
When I googled Apache Pivot I was led to its Wikipedia article. Which doesn't say much except
Apache Pivot is an open-source platform for building rich web applications in Java or any JVM-compatible language.
As far as I can see you aren't proposing to write a web application.
Anyway, if it were up to me I would just get on with writing the application in Swing. You don't seem to have any requirements which prevent that, and Swing has been the standard for Java GUIs for over a decade now and isn't going to be discontinued.
One other thought: You didn't say whether you just needed to get this application done, or whether you were planning to use it as a sort of research project so that you could learn about new Java technologies. So, if you just want to get it done then I would stick with what I said, just get it done with Swing. On the other hand if it's intended for research and development, and you've got a couple of months or so, then you could consider looking at JavaFX. I haven't heard much about JavaFX since it was released a few years ago, and I notice that the Java FX forum here on the Ranch is pretty slow, so it seems to me that it hasn't met with much popularity.