# 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 or viewer for spread sheet file quickly .

It also supports import and export to all kinds of spreadsheet format files, which are 100% compatible with MS Excel files.

## 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
```html
<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" />

```

## c#

.net 4
```html
//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>
```
```c#
//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/




## java
```html
<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>
```
```java
//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:
- [Developer's Guide C#](https://docs.aspose.com/cells/net/aspose-cells-gridweb/)
- [API Reference C#](https://docs.aspose.com/cells/net/working-with-gridweb-client-side-script/)
- [Developer's Guide JAVA](https://docs.aspose.com/cells/java/aspose-cells-gridweb/)
- [API Reference JAVA](https://docs.aspose.com/cells/java/working-with-gridweb-client-side-script/)

## Browser Support

Modern browsers(chrome, firefox, Safari,edge).

## LICENSE

MIT


## Server Side Support

[Product Page](https://products.aspose.com/cells) | [Product Documentation](https://docs.aspose.com/cells/net/aspose-cells-gridweb/) | [Blog](https://blog.aspose.com/category/cells/) |[API Reference c#](https://reference.aspose.com/cells/net/aspose.cells.gridweb/) |[API Reference java](https://reference.aspose.com/cells/java/com.aspose.gridweb/) | [Source Code Samples c#](https://github.com/aspose-cells/Aspose.Cells-for-.NET/tree/master/Examples_GridWeb) | [Source Code Samples java](https://github.com/aspose-cells/Aspose.Cells-for-Java/tree/master/Examples.GridWeb) | [Free Support](https://forum.aspose.com/c/cells)  