Gridweb-spreadsheet NPM

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/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@23.6.1/acw_client/acwmain.js?t=202209"></script>
<script type="text/javascript" language="javascript"
	src="https://unpkg.com/gridweb-spreadsheet@23.6.1/acw_client/lang_en.js"></script>
<link href="https://unpkg.com/gridweb-spreadsheet@23.6.1/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();
		}
	}