Skip to content

Js is used to operate Excel tables and realize automatic summation(JS操作Excel表格实现自动求和)

Notifications You must be signed in to change notification settings

usecodelee/js-Excel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

js-Excel

Js is used to operate Excel tables and realize automatic summation.

使用js对在网页中打开Excel表格,并进行自动求和操作。

使用的插件:js-xlsx

blog地址:www.caomage.com

兼容性如图:

操作演示:

  1. 初始页面:

  1. 打开Excel表格(可以点击选择文件,也可以直接将文件拖动到输入框)

  1. 可以看见行数列数等信息

  1. 输入需要求和的列名,得出求和结果

  1. 如果表格中含有非数字

  1. 如果有非数字会提示

  1. 然后也能计算出来去除非数字后的正确结果

  1. 原始的Excel表格

About

Js is used to operate Excel tables and realize automatic summation(JS操作Excel表格实现自动求和)

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published