php根据序号生成excel列号
function number_to_excel_column($num) {
$result = '';
while ($num > 0) {
$mod = ($num - 1) % 26;
$result = chr(65 + $mod). $result;
$num = intval(($num - 1) / 26);
}
return $result;
} function number_to_excel_column($num) {
$result = '';
while ($num > 0) {
$mod = ($num - 1) % 26;
$result = chr(65 + $mod). $result;
$num = intval(($num - 1) / 26);
}
return $result;
} 在jQuery UI Download Builder中自定义下载
index.html中添加:
data-show-export="false"
data-show-toggle="false"
data-show-columns="false"
data-search="false"
data-common-Search="false"
data-page-list="[10, 25, 50, 100]"