50 Star 136 Fork 45

葡萄城 / SpreadDesigner

Create your Gitee Account
Explore and code with more than 12 million developers,Free private repositories !:)
Sign up
Clone or Download
contribute
Sync branch
Cancel
Notice: Creating folder will generate an empty file .keep, because not support in Git
Loading...
README
Apache-2.0

SpreadJS

官网https://www.grapecity.com.cn/developer/spreadjs

下载https://www.grapecity.com.cn/developer/spreadjs/download

社区https://gcdn.grapecity.com.cn/showforum-232-1.html

资源中心https://www.grapecity.com.cn/developer/spreadjs/help#resources

葡萄城公众号


可嵌入您系统的在线Excel

**纯前端表格控件,功能布局与 Excel 高度类似 **

SpreadJS 是一款基于 HTML5 的纯前端表格控件,兼容 450 种以上的 Excel 公式,具备“高性能、跨平台、与 Excel 高度兼容”的产品特性,备受华为、明源云、远光软件等知名企业青睐,被中国软件行业协会认定为“中国优秀软件产品”。SpreadJS 在界面和功能上与 Excel 高度类似,但又不局限于 Excel,而是为企业信息化建设提供 表格文档协同编辑数据填报 类Excel报表设计 的功能支持,极大降低了企业研发成本和项目交付风险。

在线表格编辑器是 SpreadJS 的核心功能之一,可直接在 Angular React Vue 等前端框架中调用,内置开放的 API 和类 Excel 的 UI 设计元素(如工具面板),可实现高效的模板设计、在线编辑和数据绑定,为最终用户带来高度类似 Excel 的使用体验。

开发人员为什么需要 SpreadJS?

  • 纯前端组件、跨平台应用嵌入 使用 SpreadJS 的功能,无需预装任何插件或第三方应用软件,可以原生的方式嵌入各类应用,与各类后端技术框架相结合,支持跨平台开发

  • 在线导入、导出Excel(xlsx) 无需任何后台代码和第三方组件!SpreadJS 可直接在浏览器中完成 Excel、CSV、JSON 等文件的导入导出、PDF 导出、打印及预览操作

  • 业界领先的 Excel 兼容度 SpreadJS 支持 53 项单元格格式、18 种条件格式、32 种图表,可于 Web系统中轻松嵌入类Excel模块,实现如 Excel 般的数据分析和交互

  • 极高的处理性能和响应速度 SpreadJS 使用稀疏数组作为存储结构,用 HTML5 Canvas 绘制交互界面,提供了更为流畅的使用体验和出色的性能,并最大化节省存储空间

  • 强大的公式计算引擎 SpreadJS 兼容 450 多种 Excel 公式函数,可轻松扩展,满足自定义公式、跨表格引用等多场景计算需求,实现数据聚合,让有效数据不断完善

  • 一流的框架支持及二次扩展 SpreadJS 基于原生 JavaScript,全面兼容 Angular、 React、 Vue 等前端开发框架,提供大量 API 接口,可满足企业各类定制化需求

SpreadJS 三大应用场景

表格文档协同编辑

可实现多人实时协作的在线文档

SpreadJS 提供类Excel的操作界面和开放的 API,通过系统集成,可实现 Excel 导入导出、公式计算、数据绑定、服务端数据交互等功能;通过二次扩展,可将 SpreadJS 作为在线文档系统的核心模块,满足多人协作、实时编辑、数据同步、多级上报、历史查询等业务需求。

输入图片说明

(基于 SpreadJS 搭建在线表格文档协同编辑系统)

数据填报

实现类Excel的数据填报与展示

SpreadJS 提供类Excel的数据展示与数据获取的功能,可实现各类表单设计、在线填报数据、打印报送、实时预览和数据校验;通过二次开发,可将 SpreadJS 作为数据填报模块嵌入到系统中,满足批量导入导出 Excel、大数据量填报、填报暂存、多 sheet 填报、多级上报等业务需求。

输入图片说明

(SpreadJS 提供类Excel的数据填报界面)

类Excel报表设计

大幅降低从本地到线上的数据迁移工作量

SpreadJS 高度兼容 Excel,可在线导入导出 Excel 文档,并提供类Excel的使用体验,通过二次开发,可将 SpreadJS 作为企业报表 SaaS 平台的核心模块,快速重用业务系统原始 Excel 报表模板,满足数据报表生成、数据分析、模板版本管理、数据大屏展示、设计交互式仪表板等业务需求。

输入图片说明

(SpreadJS 类Excel报表的设计与展示)

SpreadJS 六大主要功能

类 Excel 表格编辑器

SpreadJS 的表格编辑器提供了高度类似 Excel 的功能和 API,可在线/离线设计报表模板、编辑、计算、分析数据并与数据库绑定,满足填报系统开发需求。

输入图片说明

高性能数据处理

SpreadJS 提供了高效的计算引擎,并针对数据处理性能进行了优化,可满足企业各类数据计算、可视化、数据透视分析等需求,却不会过多地占用系统资源。

输入图片说明

导入/导出 Excel

SpreadJS 支持在线导入/导出 Excel(xlsx)、导出 PDF 文档,用户可在浏览器中加载并修改各种 Excel 文档,并将修改后的数据保存到数据库中。

输入图片说明

内置 450 多种计算公式

SpreadJS 的计算引擎支持 450 多种 Excel 公式函数,包括自定义函数、数组函数、动态数组、异步函数、XMATCH、LET 、XLOOKUP 函数等。

输入图片说明

数据绑定

使用 SpreadJS 可以直接通过模板创建与数据的绑定关系,即可绑定 JavaScript 对象和对象数组,也可将整个工作表、表格或单元格绑定到数据源。

输入图片说明

丰富的数据可视化手段

SpreadJS 内置 32 种图表、18 种迷你图和 182 种形状,丰富的数据可视化手段可以为系统添加更多细节展现,并且可以在 Excel 中无损导入和导出。

输入图片说明

用不到 100 行代码,在前端实现各类电子表格的功能

在线表格编辑器

  • 开放的 API 和类 Excel 的 UI 设计元素
  • 提供模板设计、在线编辑等功能
  • 在线导入导出 Excel 文档
  • 支持触摸控制的功能区和菜单面板
  • 纯中文操作界面,支持 Excel 的主题风格

输入图片说明

数据透视表

  • 内置透视面板
  • 支持透视表字段、值字段设置
  • 支持导入导出
  • API 支持,可二次封装

输入图片说明

兼容 450 种以上的 Excel 公式

  • 高效、可扩展的计算引擎
  • 支持自定义公式
  • 支持跨表格引用
  • 支持异步函数

输入图片说明

单元格级别的数据绑定

  • 双向绑定机制
  • 可自定义单元格类型
  • 像网格一样使用

输入图片说明

丰富多样的数据可视化呈现

  • 32 种图表类型
  • 可从 Excel 中导入或导出
  • 行列头支持公式及迷你图
  • 可按 Excel 风格分组
  • 支持图表轴交叉属性
  • 支持图表模板填充

输入图片说明

多种数据验证及自定义验证方式

  • 智能数据验证
  • 支持用户自定义验证方式

输入图片说明

前端框架支持

输入图片说明

Apache License Version 2.0, January 2004 http://www.apache.org/licenses/ TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION 1. Definitions. "License" shall mean the terms and conditions for use, reproduction, and distribution as defined by Sections 1 through 9 of this document. "Licensor" shall mean the copyright owner or entity authorized by the copyright owner that is granting the License. "Legal Entity" shall mean the union of the acting entity and all other entities that control, are controlled by, or are under common control with that entity. For the purposes of this definition, "control" means (i) the power, direct or indirect, to cause the direction or management of such entity, whether by contract or otherwise, or (ii) ownership of fifty percent (50%) or more of the outstanding shares, or (iii) beneficial ownership of such entity. "You" (or "Your") shall mean an individual or Legal Entity exercising permissions granted by this License. "Source" form shall mean the preferred form for making modifications, including but not limited to software source code, documentation source, and configuration files. "Object" form shall mean any form resulting from mechanical transformation or translation of a Source form, including but not limited to compiled object code, generated documentation, and conversions to other media types. "Work" shall mean the work of authorship, whether in Source or Object form, made available under the License, as indicated by a copyright notice that is included in or attached to the work (an example is provided in the Appendix below). "Derivative Works" shall mean any work, whether in Source or Object form, that is based on (or derived from) the Work and for which the editorial revisions, annotations, elaborations, or other modifications represent, as a whole, an original work of authorship. For the purposes of this License, Derivative Works shall not include works that remain separable from, or merely link (or bind by name) to the interfaces of, the Work and Derivative Works thereof. "Contribution" shall mean any work of authorship, including the original version of the Work and any modifications or additions to that Work or Derivative Works thereof, that is intentionally submitted to Licensor for inclusion in the Work by the copyright owner or by an individual or Legal Entity authorized to submit on behalf of the copyright owner. For the purposes of this definition, "submitted" means any form of electronic, verbal, or written communication sent to the Licensor or its representatives, including but not limited to communication on electronic mailing lists, source code control systems, and issue tracking systems that are managed by, or on behalf of, the Licensor for the purpose of discussing and improving the Work, but excluding communication that is conspicuously marked or otherwise designated in writing by the copyright owner as "Not a Contribution." "Contributor" shall mean Licensor and any individual or Legal Entity on behalf of whom a Contribution has been received by Licensor and subsequently incorporated within the Work. 2. Grant of Copyright License. Subject to the terms and conditions of this License, each Contributor hereby grants to You a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable copyright license to reproduce, prepare Derivative Works of, publicly display, publicly perform, sublicense, and distribute the Work and such Derivative Works in Source or Object form. 3. Grant of Patent License. Subject to the terms and conditions of this License, each Contributor hereby grants to You a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable (except as stated in this section) patent license to make, have made, use, offer to sell, sell, import, and otherwise transfer the Work, where such license applies only to those patent claims licensable by such Contributor that are necessarily infringed by their Contribution(s) alone or by combination of their Contribution(s) with the Work to which such Contribution(s) was submitted. If You institute patent litigation against any entity (including a cross-claim or counterclaim in a lawsuit) alleging that the Work or a Contribution incorporated within the Work constitutes direct or contributory patent infringement, then any patent licenses granted to You under this License for that Work shall terminate as of the date such litigation is filed. 4. Redistribution. You may reproduce and distribute copies of the Work or Derivative Works thereof in any medium, with or without modifications, and in Source or Object form, provided that You meet the following conditions: You must give any other recipients of the Work or Derivative Works a copy of this License; and You must cause any modified files to carry prominent notices stating that You changed the files; and You must retain, in the Source form of any Derivative Works that You distribute, all copyright, patent, trademark, and attribution notices from the Source form of the Work, excluding those notices that do not pertain to any part of the Derivative Works; and If the Work includes a "NOTICE" text file as part of its distribution, then any Derivative Works that You distribute must include a readable copy of the attribution notices contained within such NOTICE file, excluding those notices that do not pertain to any part of the Derivative Works, in at least one of the following places: within a NOTICE text file distributed as part of the Derivative Works; within the Source form or documentation, if provided along with the Derivative Works; or, within a display generated by the Derivative Works, if and wherever such third-party notices normally appear. The contents of the NOTICE file are for informational purposes only and do not modify the License. You may add Your own attribution notices within Derivative Works that You distribute, alongside or as an addendum to the NOTICE text from the Work, provided that such additional attribution notices cannot be construed as modifying the License. You may add Your own copyright statement to Your modifications and may provide additional or different license terms and conditions for use, reproduction, or distribution of Your modifications, or for any such Derivative Works as a whole, provided Your use, reproduction, and distribution of the Work otherwise complies with the conditions stated in this License. 5. Submission of Contributions. Unless You explicitly state otherwise, any Contribution intentionally submitted for inclusion in the Work by You to the Licensor shall be under the terms and conditions of this License, without any additional terms or conditions. Notwithstanding the above, nothing herein shall supersede or modify the terms of any separate license agreement you may have executed with Licensor regarding such Contributions. 6. Trademarks. This License does not grant permission to use the trade names, trademarks, service marks, or product names of the Licensor, except as required for reasonable and customary use in describing the origin of the Work and reproducing the content of the NOTICE file. 7. Disclaimer of Warranty. Unless required by applicable law or agreed to in writing, Licensor provides the Work (and each Contributor provides its Contributions) on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied, including, without limitation, any warranties or conditions of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A PARTICULAR PURPOSE. You are solely responsible for determining the appropriateness of using or redistributing the Work and assume any risks associated with Your exercise of permissions under this License. 8. Limitation of Liability. In no event and under no legal theory, whether in tort (including negligence), contract, or otherwise, unless required by applicable law (such as deliberate and grossly negligent acts) or agreed to in writing, shall any Contributor be liable to You for damages, including any direct, indirect, special, incidental, or consequential damages of any character arising as a result of this License or out of the use or inability to use the Work (including but not limited to damages for loss of goodwill, work stoppage, computer failure or malfunction, or any and all other commercial damages or losses), even if such Contributor has been advised of the possibility of such damages. 9. Accepting Warranty or Additional Liability. While redistributing the Work or Derivative Works thereof, You may choose to offer, and charge a fee for, acceptance of support, warranty, indemnity, or other liability obligations and/or rights consistent with this License. However, in accepting such obligations, You may act only on Your own behalf and on Your sole responsibility, not on behalf of any other Contributor, and only if You agree to indemnify, defend, and hold each Contributor harmless for any liability incurred by, or claims asserted against, such Contributor by reason of your accepting any such warranty or additional liability. END OF TERMS AND CONDITIONS APPENDIX: How to apply the Apache License to your work To apply the Apache License to your work, attach the following boilerplate notice, with the fields enclosed by brackets "{}" replaced with your own identifying information. (Don't include the brackets!) The text should be enclosed in the appropriate comment syntax for the file format. We also recommend that a file or class name and description of purpose be included on the same "printed page" as the copyright notice for easier identification within third-party archives. Copyright 2014 葡萄城控件 Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

About

您可以直接将类Excel的强大功能嵌入到应用系统中,无需任何编码便可在Spread设计器中实现数据分组、公式计算、条件格式、图表效果等复杂功能的表格应用开发。您更可以将其免费部署到最终用户端,帮助用户编辑和定制Spread模板,分析处理数据。 expand collapse
C# and 4 more languages
Apache-2.0
Cancel

Releases

No release

Contributors

All

Activities

Load More
can not load any more
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
C#
1
https://gitee.com/GrapeCity/SpreadDesigner.git
git@gitee.com:GrapeCity/SpreadDesigner.git
GrapeCity
SpreadDesigner
SpreadDesigner
master

Search

344bd9b3 5694891 D2dac590 5694891