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
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.
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
<head>
<!-- other dependency start -->
<link rel="stylesheet" href="https://unpkg.com/jquery-ui@1.13.2/dist/themes/ui-lightness/jquery-ui.min.css">
<script src="https://unpkg.com/jquery@3.6.0/dist/jquery.min.js"></script>
<script src="https://unpkg.com/jquery-ui@1.13.2/dist/jquery-ui.min.js"></script>
<!-- other dependency end -->
<script type="text/javascript" language="javascript"
src="https://unpkg.com/gridweb-spreadsheet@24.9.0/acw_client/acwmain.js?t=202209"></script>
<script type="text/javascript" language="javascript"
src="https://unpkg.com/gridweb-spreadsheet@24.9.0/acw_client/lang_en.js"></script>
<link href="https://unpkg.com/gridweb-spreadsheet@24.9.0/acw_client/menu.css" rel="stylesheet"
type="text/css" />
.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
<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();
}
}
- 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
- Data validations
- Display chart/shapes/images
- Display Form Controls /ActiveX Controls(incoming)
Online documentation is available here:
Modern browsers(chrome, firefox, Safari,edge).
MIT
Product Page | Product Documentation | Blog |API Reference c# |API Reference java | Source Code Samples c# | Source Code Samples java | Free Support