We are in market to purchase a tool with help us extracting data (more than 100000 rows) from an excel (called excel A) and paste in another excel (called excel B) within short period of time. The excel B is embedded in the project and will be saved as an another excel files as the output of our project. The data extraction from excel A is based on specific condition(s) and paste to the corresponding sheets in excel B. For example:
In sheet 1 (Column A and B) of excel A:
|X1|1|
|X2|2|
|X1|3|
|X3|4|
|X4|5|
|X5|6|
|X1|7|
|X2|8|
|X4|9|
Output in Excel B:
Sheet X1:
|X1|1|
|X1|3|
|X1|7|
Sheet X2:
|X2|2|
|X2|8|
& etc.
We are using vb.net and the operation should be run at background. In other word, we don’t want to open excel A then have the product. Before we make the decision of making a purchase it would be helpful if you can tell us whether your product can do what we are looking for.
Well, we think Aspose.Cells for .NET suits your need well. For your task, you may try using Find or Search feature provided by Aspose.Cells APIs. For example, you may find the string “X1” and know the underlying cell(s) which contains that string. Then you may copy the specified rows (cells) and start filling into other sheet cells accordingly. See the documents on copy rows/columns and copy ranges for your reference:
You may build your own logic and write code by yourselves using Aspose.Cells to accomplish the task.