I have been tasked with doing fairly intensive data validation of large spreadsheets uploaded on internet. Do you know of clients who have successfully used Aspos Cells Java to do this?
This message was posted using Aspose.Live 2 Forum
Hi,
Well, our several java users have implemented data validation via Aspose.Cells for Java API. We appreciate if you could try the API for your need. For reference, please see the document: http://www.aspose.com/documentation/java-components/aspose.cells-for-java/data-filtering-and-validation.html
If you still find any problem or issue, kindly let us know about it and we will help you soon.
Thank you.
Hi,
We received your private message.
For your queries in it:
>I tested Aspose last May for different purposes so do not believe I can cownload another trial.
Well,
you may download as many trial versions as you need, I think you should
try our latest version v4.8.1. There should be no restriction what so
ever.
I am provided with a spreadsheet upload and a 'map' telling me what column contain certain data that is constitutes the 'required' data for a valid submission. I want to use Aspose to scan the column titles to 'find' the data field locations, and then parse the contents of each column to make certain that the submission is acceptible.
Yes, you may browse cells in rows and columns to check data and update it for your need too. See some documentation topics:
http://www.aspose.com/documentation/java-components/aspose.cells-for-java/adding-data-to-cells.html
http://www.aspose.com/documentation/java-components/aspose.cells-for-java/find-or-search-data.html
Can I use Aspose Cells to convert/export XMLor text or CSV from any spreadsheet?
Well, you may export the worksheet data to csv and html if it fits your need, see the document:
http://www.aspose.com/documentation/java-components/aspose.cells-for-java/saving-files.html
Thank you.