# IgnoreRows `ignoreRows: [0, 2]` – `number|number[]`

Name | Position | Age | Salary
--- | --- | --- | ---
Thor Walton | Regional Director | 45 | $98,540
Travis Clarke | Software Engineer | 30 | $275,000
Suki Burks | Office Manager | 22 | $67,670
|  |  | $441,210

export the table to `.xls` and look at the contents of the yellow rows. Compared to the export from the defaults table above, you will notice that `ignoreRows: [0, 2]` removes the `tbody` rows at index zero(0) and two(2).

NOTE: reference `headers` and `footers` if you want to remove `thead` or `tfoot` rows.

NOTE: reference `.tableexport-ignore`, `.tableexport-empty` if you want to customize the removal of `table` rows, columns, or cells.

# IgnoreCols `ignoreCols: 1` – `number|number[]`

Name | Position | Age | Salary
--- | --- | --- | ---
Thor Walton | Regional Director | 45 | $98,540
Travis Clarke | Software Engineer | 30 | $275,000
Suki Burks | Office Manager | 22 | $67,670
|  |  | $441,210

export the table to `.xls` and look at the contents of the yellow column. Compared to the export from the defaults table above, you will notice that `ignoreCols: 1` removes the `tbody` column at index one(1).

NOTE: reference `.tableexport-ignore`, `.tableexport-empty` if you want to customize the removal of `table` rows, columns, or cells.

# Need control at the individual cell level?

- `.tableexport-ignore`: add this class to a `tr`, `td`, or `th` to: exclude/remove cells from the exported file(s).

  Caution: this will shift the remaining cells.

- `.tableexport-empty`: add this class to a `tr`, `td`, or `th` to: replace cells with an empty string in the exported file(s).

Name | Position | Age | Salary
--- | --- | --- | ---
Thor Walton | Regional Director | 45 | $98,540
Travis Clarke | Software Engineer | 31 | $275,000
Suki Burks | Office Manager | 22 | $67,670
|  |  | $441,210

The `ignore CSS class selector` can be configured with the `ignoreCSS` prototype property.
The `empty CSS class selector` can be configured with the `emptyCSS` prototype property.