html过滤检索类似excel,利用jQuery实现仿Excel表格排序筛选代码

特效描述：利用jQuery实现 仿Excel表格 排序筛选代码，利用jQuery实现仿Excel表格排序筛选代码

代码结构

1. 引入CSS

2. 引入JS

3. HTML代码

Table 1

AnimalClassCollective NounA Number

BearMammalSleuth1AntInsectArmy2SalamanderAmphibianCongress3OwlBirdParliament4FrogAmphibianArmy5SharkFishGam6KookaburraBirdCackle7CrowBirdMurder8ElephantMammalHerd9BarracudeFishGrist10

Table 2

AnimalClassCollective NounA Number

BearMammalSleuth1AntInsectArmy2SalamanderAmphibianCongress3OwlBirdParliament4FrogAmphibianArmy5SharkFishGam6KookaburraBirdCackle7CrowBirdMurder8ElephantMammalHerd9BarracudeFishGrist10

Table 3

姓名字段只提供搜索，不带过滤和排序

编号姓名成绩

1张三682李四753王五864赵六765韩七95

$(function () {

$('#table').excelTableFilter({

'captions':{ a_to_z: '升序排列', z_to_a: '降序排列', search: '搜索', select_all: '全部选择' }

});

$('#table2').excelTableFilter({

'captions':{ a_to_z: '升序排列', z_to_a: '降序排列', search: '搜索', select_all: '全部选择' }

});

$('#table3').excelTableFilter({

'captions':{ a_to_z: '升序排列', z_to_a: '降序排列', search: '搜索', select_all: '全部选择' }

});

});