gridweb-spreadsheet
v24.5.0
Published
this is the client js for GridWeb,which is an easy-to-use .net and java webcontrol for display and edit spreadsheet file
Downloads
77
Maintainers
asposecellsReadme
gridweb-spreadsheet
A smart and simple to use WYSIWYG Excel-like library for wep application for both .net and java that allows you to view and edit spreadsheet file with ease and quick
Document
It is easy and simple to use.
It helps you to build online web editor for spread sheet file quickly .
It also support import and export all kinds of spread sheet format files which is 100% compatible with MS excel file.
Demo
java demo: https://github.com/aspose-cells/Aspose.Cells-for-Java/tree/master/Examples.GridWeb .net demo: https://github.com/aspose-cells/Aspose.Cells-for-.NET/tree/master/Examples_GridWeb
CDN
<head>
<!-- other dependency start -->
<link rel="stylesheet" href="https://unpkg.com/[email protected]/dist/themes/ui-lightness/jquery-ui.min.css">
<script src="https://unpkg.com/[email protected]/dist/jquery.min.js"></script>
<script src="https://unpkg.com/[email protected]/dist/jquery-ui.min.js"></script>
<!-- other dependency end -->
<script type="text/javascript" language="javascript"
src="https://unpkg.com/[email protected]/acw_client/acwmain.js?t=202209"></script>
<script type="text/javascript" language="javascript"
src="https://unpkg.com/[email protected]/acw_client/lang_en.js"></script>
<link href="https://unpkg.com/[email protected]/acw_client/menu.css" rel="stylesheet"
type="text/css" />
c#
.net 4
//aspx page
<%@ Register assembly="Aspose.Cells.GridWeb" namespace="Aspose.Cells.GridWeb" tagprefix="cc1" %>
...
<body>
<form id="form1" runat="server">
<cc1:GridWeb ID="GridWeb1" runat="server" Height="582px" Width="1063px">
</cc1:GridWeb>
</form>
</body>//aspx.cs
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack && !GridWeb1.IsPostBack)
{String filePath=@"c:/test.xlsx";
GridWeb1.ImportExcelFile(filePath);
}
}.net 6 and .net core please refer to https://github.com/aspose-cells/Aspose.Cells-for-.NET/blob/master/Examples_GridWeb/GridWeb.Net6/devtips.txt
java
<script >
function renderData(data)
{ //the default stype part for gridweb component is Stylemycomponent
$("#Stylemycomponent").remove();
//need to render gridweb ,this will trigger reinit of gridweb component
//the default name for gridweb component is mycomponent
gridwebinstance.remove("mycomponent") ;
$("#gridweb").html(data);
}
function doClick( ) {
$.post([[${servletname}]], {
flag : 'loadfile',
gridwebuniqueid : $("#mycomponent").attr("webuniqueid")
}, function(data) {
renderData(data);
}, "html");
}
$(document).ready(function(){
doClick('loadfile');
});
</script>
<div id="gridweb"></div>//for server side:
public class FeatureServlet extends TestGridWebBaseServlet {
private static final long serialVersionUID = 1L;
@Override
public void loadfile(GridWebBean gridweb,HttpServletRequest request, HttpServletResponse response) {
try {
super.reloadfile(gridweb,request,"test.xls");
} catch (Exception e) {
e.printStackTrace();
}
}Features
Localization/Multiple language UI
Paint format
Clear format
Format
Font/Font size/ bold/italic/Underline/Strike
Text color/Align/wrapping
Fill color
Borders
Merge cells
Freeze cell
Copy, Cut, Paste
Autofill
Insert/Delete row, column
Filter row, column
Sort
Search
Formula
Resize row-height, col-width
Switch/add/delete sheets
Condition Format
Comment
Print
Data validations
Display chart/shapes/images
Display Form Controls /ActiveX Controls(incoming)
Documentation
Online documentation is available here:
Browser Support
Modern browsers(chrome, firefox, Safari,edge).
LICENSE
MIT
Server Side Support
Product Page | Product Documentation | Blog |API Reference c# |API Reference java | Source Code Samples c# | Source Code Samples java | Free Support