Skip to content

Added support for auto filters #306

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 3 commits into from
Apr 26, 2017
Merged

Added support for auto filters #306

merged 3 commits into from
Apr 26, 2017

Conversation

mariushab
Copy link
Contributor

This pull request addresses the feature requests #197 and #112.

mariushab and others added 3 commits April 21, 2017 11:08
Because of a commit while this pull request has not be merged, some spaces had to be removed in order to resolve the conflicts.
@guyonroche guyonroche merged commit 722f736 into exceljs:master Apr 26, 2017
@AhmadMurtaza1
Copy link

What I want is to retrieve only filtered rows from csv but It will shows or results all rows in console.log

    var file = './uploads/attachFile-1508833322746.csv';
    var workbook = new Excel.Workbook();
    workbook.csv.readFile(file).then(function(worksheet) {
        worksheet.autoFilter = {
            from: {
                row: 3,
                column: 1
            },
            to: {
                row: 5,
                column: 12
            }
        }
        worksheet.eachRow({ includeEmpty: true }, function(row, rowNumber) {
            console.log(JSON.stringify(row.values));
        });
    })

Looking forward to hear from you.
Thanks in Advance 👍

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

3 participants