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();
		}
	}

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

Keywords

FAQs

What is gridweb-spreadsheet?

Is gridweb-spreadsheet well maintained?

Last updated on 10 May 2024

Did you know?

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install