Skip to main content Skip to footer

SpreadJS and Visual Studio

You can use SpreadJS in a Visual Studio project. This provides access to automatic complete and code checking in Visual Studio. Use the following steps to create a project that uses SpreadJS.

  1. Create an ASP.NET project (File, New Project or New Project in Visual Studio). Select ASP.NET Web Application. Specify the Name, Location, and Solution name. SpreadJSWebProject New Project
  2. Select a template such as Empty and select OK. SpreadJSEmpty Empty Template
  3. Select Project, Add New Item. SpreadJSAddNewItem New Item
  4. Select HTML page. Specify a name. Select Add. You can also right-click on the HTML file in the Solution Explorer and change the name (Rename menu option). SpreadJSHtml HTML Page
  5. Save the file (File, Save SpreadJSHtml.html).
  6. Add the file to the project (Project, Add Existing Item). SpreadJSAddExisting Existing Item
  7. Select the file in the project folder (SpreadJSHtml.html) and select Add. You can also use the Add Existing Item option to add the gcspread.sheets.all.8.40.20151.5.min.js and gcspread.sheets.all.8.40.20151.5.css files to the project so that you can use relative paths. SpreadJSlocation Add File

  8. Use code similar to the following to add the widget to the page.

    <!DOCTYPE html>  
    <html lang="en" xmlns="">  
        <meta charset="utf-8" />  
        <script src="" type="text/javascript"></script>  
        <script type="text/javascript" src="gcspread.sheets.all.8.40.20151.5.min.js"></script>  
        <script type="text/javascript" src="gcspread.sheets.all.8.40.20151.5.css"></script>  
        <script type="text/javascript">  
        $(function () {  
            var spread = new GcSpread.Sheets.Spread($("#ss")[0]);  
            var sheet = spread.getActiveSheet();  
            sheet.setValue(0, 0, "This is a test");  
            sheet.getCell(0, 0).backColor("yellow");  
        <div id="ss" style="width:600px;height:450px"></div>  

    SpreadJSCode Sample Code

  9. You can use the View in Browser option to test the page or use the Run option. SpreadJSViewBrowser View in Browser
  10. The completed example is illustrated in the following image. SpreadJSComplete Completed Sample


comments powered by Disqus