Using Aspose.Cells for Java, I want to implement a web page in Aspose.Cells.GridWeb format based on Java, Oracle Database, and Spring Framework.
I want to display the Data and the Formula and the Result Values on the web page by searching the data of the Database.
Please check that Aspose.Cells for Java can search the data of the database to the Header Bar part and Grid part of Aspose.Cells.GridWeb.
Thanks for your query.
Well, Aspose.Cells for Java is a spreadsheet management component (it supports to read, write, render or print MS Excel file formats (e.g XLS, XLSX, XLSM, CSV, Tab delimited, ODS, etc.)) rather than relational database management system. It is a non GUI API which provides almost all the features which MS Excel (2003-2013/2016) provides. Regarding Aspose.Cells.GridWeb (Java), it is an independent JSP/servlets based grid (GUI) control in which you may, create/design, import/display into grid matrix and export to MS Excel file formats.
In short, using Aspose.Cells for Java or Aspose.Cells.GridWeb (Java), you cannot perform find/search in the database (oracle), you got to import the data into some container (Array, Array list, Result set, JSON, etc.) using your own JDK and other APIs then you can import from these sources. In this respect, see the documents on how to import data from data source for your reference:
Moreover, see the document on how to find/search data in the sheet for your reference:
Also, see the Aspose.Cells.GridWeb (Java) Docs for your reference:
To get detailed working examples (Aspose.Cells for Java and Aspose.Cells.GridWeb (Java)) on different features/APIs, you may download it here:
Hope, this helps a bit.