How to filter rows based on cell values from several excel files?

Aspose.Cells Product Family
1

Hi Aspose team,
is this possible with Aspose cells? Basically I need to do this:

1. Open several excel files, load them into memory or something.
2. Filter rows based on “id”, “date” and “status” columns to get the total amount of each “id” on each file
3. Save the “totals” summary of each “id” on a new excel file.

The excel files format is something like this:

A B C D E
1 Report AB
2 Date 04/07/2008 - 01/12/2008
3
4 id desc amount date status
5 EX Description 3000 2/7/2008 P
6 EX Description 11813.5 12/8/2008 P
7 EX Description 3500 26/08/2008 P
8 EX Description 3500 1/10/2008 P
9 DL Description 5000 20/11/2008 P
10 EX Description 10000 20/11/2008 P
11 EX Description 160000 3/12/2008 P
12 DL Description 396 25/07/2008 P
13 DL Description 40 21/08/2008 P
14 DL Description 300 27/11/2008 P
15 DL Description 218 1/12/2008 P

Thanks in advance for any ideas you can share about this


2

Hi,

Well, I think you may try MS Excel’s data filtering feature, see the document:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/data-filtering-and-validation.html

Thank you.