1 Star 1 Fork 1

葡萄城 / GcExcel

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
克隆/下载
贡献代码
同步代码
取消
提示: 由于 Git 不支持空文件夾,创建文件夹后会生成空的 .keep 文件
Loading...
README
Apache-2.0

GrapeCity Documents for Excel

GrapeCity Documents for Excel (简称:GcExcel)是一款基于 Java 平台的服务端高性能表格组件,可与 纯前端表格控件 SpreadJS 前后端兼容,无需依赖 Office、POI 或第三方应用软件,在前端展示电子表格数据,在服务端批量创建、加载、编辑、打印、导入/导出 Excel 文档,为您开发的应用程序提供在线文档的前后端数据同步、在线填报与服务端批量导出与打印,以及类 Excel 报表模板设计与服务端高性能处理等一整套 类 Excel 全栈解决方案

点击此处,了解基于 .NET 平台的 GcExcel

GcExcel (Java 平台)产品特色

特色 描述
组件架构灵活、高效 GcExcel 在处理 Excel 文档时,消耗的内存和占用时间,远超企业级项目标准。 与 POI 相比,速度更快、性能更高、内存消耗更少。
与 SpreadJS 前后端兼容 GcExcel 天然与 SpreadJS 前后端兼容,可直接导入 SSJSON 格式,无需依赖 Office 和 POI,为应用程序提供 类 Excel 全栈解决方案
基于 Excel 的文档对象模型 允许您导入、导出、计算、查询、生成 Excel 脚本。与 VSTO 一致,您可以使用与 Visual Studo Tools for Office 相同元素创建自定义样式。
主题、接口丰富多样 GcExcel 提供了数量众多,且功能全面的自定义主题、组件接口、可配置属性、数据汇总方式、嵌入式绘图对象和内置计算引擎。
高度兼容 Excel 可无损导入/导出 Excel 文件,包括其中的数据透视表、表格、图表、注释、条件格式、数据验证、公式、形状、图片和迷你图。
加速云应用开发 支持公有云、私有云部署和独立服务器部署,使用 Maven & Nuget,您可直接将应用发布至百度云、阿里云、腾讯云、Azure 和 AWS 中。

无需依赖 Office 和 POI,高效实现类 Excel 的功能

完全取代 POI 组件

  • 比 Apache POI 提供更全面的功能
  • 处理速度是 Apache POI 的 7 倍
  • 内存消耗不到 Apache POI 的七分之一
  • 百万行单元格下,仍旧可以平稳运行

无需依赖 Office 和 POI,高效实现类 Excel 的功能

类 Excel 全栈解决方案

  • 与 SpreadJS 前后端完美兼容
  • 在前端展示和编辑 Excel 的内容
  • 在服务端批量导入和导出 Excel 文件
  • 实现前、后端数据交互、数据传输

无需依赖 Office 和 POI,高效实现类 Excel 的功能

类 Excel 的工作表和视图

  • 支持 450 多种 Excel 公式
  • 支持 50 多种 Excel 图表
  • 支持 Excel 脚本(VSTO)
  • 支持自定义主题样式

无需依赖 Office 和 POI,高效实现类 Excel 的功能

无损导入导出 Excel

  • 无需 Office 组件依赖
  • 支持批量导入导出
  • 支持公式导出
  • 支持将多个工作簿导出到 PDF

无需依赖 Office 和 POI,高效实现类 Excel 的功能

支持 450 多种公式

  • 引用单元格和从属单元格
  • 数组公式
  • 表格公式
  • 自定义公式

无需依赖 Office 和 POI,高效实现类 Excel 的功能

支持数据透视表

  • 创建数据透视表
  • 自定义样式和字段的数字格式
  • 可导出至 PDF

可与纯前端表格控件 SpreadJS 前后端兼容

SpreadJS 是一款基于 HTML5 的纯前端表格控件,兼容 450 种以上的 Excel 公式,具备 “高性能、跨平台、与 Excel 高度兼容”的产品特性,可满足表格文档协同编辑、 数据填报、类 Excel 报表设计等业务场景

GcExcel 天然与 SpreadJS 前后端兼容,可直接导入 SSJSON 格式,在不依赖 Office、POI 和第三方软件的情况下,满足在线文档的前后端数据同步、在线填报与服务端批量导出与打印,以及类 Excel 报表模板设计与服务端高性能处理等功能,为您开发的应用程序提供整套 类 Excel 全栈解决方案。

为什么选择 GcExcel?

优势 描述
速度快、性能高 GcExcel 的平均速度是 Apache POI 的 7 倍,占用的内存仅为 1/7
支持 450 多种 Excel 公式 内置种类丰富的计算函数,支持自定义公式
批量打印 可将 Excel 表单导出为 PDF(确保格式不变),实现批量打印
与 VSTO 一致的条件格式 可使用与 Office 完全相同的文档对象模型
支持 53 种图表类型 提供更加专业的图表,如箱形图、漏斗图、直方图、帕累托图
支持迷你图 GcExcel 支持迷你图和迷你图组,可在单元格中可视化数据
剪切、复制、粘贴图片和形状 支持对图片或形状执行剪切、复制、粘贴等剪贴板操作
支持应用高级过滤器 包括对数字、文本、颜色、图标执行过滤
多种排序支持 可按值、多值、字体颜色和图标排序,支持自定义排序
支持数据切片器 内置切片器样式,可执行剪切、复制和筛选,支持自定义选项
导入和导出 CSV 可明显提高文件的传输速度和读取效率
支持渐变填充 对于使单元格、形状和图表系列“突出”时非常有用

更多与POI数据对比

GrapeCity Documents - V4.0 Update2 新特性

  • 支持动态数组公式
  • 支持新的公式函数
  • 支持来自 Web 的外部工作簿链接
  • 支持 PDF 导出图表
  • 动态设置工作簿的文档属性
  • 展开/折叠数据透视表中的分组项目
  • 与前端表格控件 SpreadJS 集成

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: (a) You must give any other recipients of the Work or Derivative Works a copy of this License; and (b) You must cause any modified files to carry prominent notices stating that You changed the files; and (c) 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 (d) 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 [yyyy] [name of copyright owner] 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.

简介

暂无描述 展开 收起
Apache-2.0
取消

发行版

暂无发行版

贡献者

全部

近期动态

加载更多
不能加载更多了
C#
1
https://gitee.com/GrapeCity/GcExcel.git
git@gitee.com:GrapeCity/GcExcel.git
GrapeCity
GcExcel
GcExcel
master

搜索帮助