VintaSoft Imaging .NET SDK 12.4: Documentation for Web developer
In This Topic
    Add web spreadsheet document editor to a React and ASP.NET Core application
    In This Topic
    This tutorial shows how to create a blank React and ASP.NET Core application in Visual Studio .NET 2022 and the spreadsheet document editor (with ability to open, edit and save spreadsheet (XLSX) document) to React and ASP.NET Core application.


    Here are steps, which must be done:
    1. Create a blank React and ASP.NET Core application.

      • Open Visual Studio .NET 2022 and create a new application of "React and ASP.NET Core" type:

      • Configure the application to use .NET 8.0:
    2. Server side: Add references to the Vintasoft assemblies to "ReactApp1.Server" project.

      Copy Vintasoft.Shared.dll, Vintasoft.Imaging.dll, Vintasoft.Imaging.Office.OpenXml, Vintasoft.Shared.Web.dll, Vintasoft.Imaging.Web.Services.dll, Vintasoft.Imaging.Office.Web.Services.dll, Vintasoft.Imaging.AspNetCore.ApiControllers.dll and Vintasoft.Imaging.Office.AspNetCore.ApiControllers.dll assemblies from "<SdkInstallPath>\VintaSoft Imaging .NET v12.4\Bin\DotNet8\AnyCPU\" directory to the "Bin" directory of "ReactApp1.Server" project and add references to assemblies in "ReactApp1.Server" project.



    3. Server side: Specify drawing engine, which should be used by VintaSoft Imaging .NET SDK for drawing of 2D graphics.

      If "ReactApp1.Server" project must be used in Windows or Linux, SkiaSharp drawing engine should be used.
      If "ReactApp1.Server" project must be used in Windows only, System.Drawing or SkiaSharp drawing engine should be used.

      Here are steps, which should be made for using SkiaSharp engine:
      • Add reference to the Vintasoft.Imaging.Drawing.SkiaSharp.dll assembly.
      • Add reference to the SkiaSharp nuget-package version 2.88.6.
      • Open "Program.cs" file in "ReactApp1.Server" project, add code line "Vintasoft.Imaging.Drawing.SkiaSharp.SkiaSharpDrawingFactory.SetAsDefault();" at the beginning of file - added code specifies that VintaSoft Imaging .NET SDK should use SkiaSharp library for drawing of 2D graphics.

      Here are steps, which should be made for using System.Drawing engine:
      • Add reference to the Vintasoft.Imaging.Gdi.dll assembly.
      • Open "Program.cs" file in "ReactApp1.Server" project, add code line "Vintasoft.Imaging.Drawing.Gdi.GdiGraphicsFactory.SetAsDefault();" at the beginning of file - added code specifies that VintaSoft Imaging .NET SDK should use System.Drawing library for drawing of 2D graphics.

    4. Server side: Create web services, which allow to upload/download file and edit XLSX document.

      • Create web service that allows to upload/download file

        • Press the right mouse button on the "Controllers" folder and select the "Add => Controller..." menu from context menu
        • Select Empty API controller template, set the controller name to the "MyVintasoftFileApiController" and press the "Add" button
        • Specify that MyVintasoftFileApiController class is derived from Vintasoft.Imaging.AspNetCore.ApiControllers.VintasoftFileApiController class

          Here are source codes of MyVintasoftFileApiController class:
          namespace ReactApp1.Server.Controllers
          {
              public class MyVintasoftFileApiController : Vintasoft.Imaging.AspNetCore.ApiControllers.VintasoftFileApiController
              {
          
                  public MyVintasoftFileApiController(IWebHostEnvironment hostingEnvironment)
                      : base(hostingEnvironment)
                  {
                  }
          
              }
          }
          
          
      • Create web service that allows to edit XLSX document

        • Press the right mouse button on the "Controllers" folder and select the "Add => Controller..." menu from context menu
        • Select Empty API controller template, set the controller name to the "MyVintasoftOfficeApiController" and press the "Add" button
        • Specify that MyVintasoftOfficeApiController class is derived from Vintasoft.Imaging.Office.AspNetCore.ApiControllers.VintasoftOfficeApiController class

          Here are source codes of MyVintasoftOfficeApiController class:
          namespace ReactApp1.Server.Controllers
          {
              public class MyVintasoftOfficeApiController : Vintasoft.Imaging.Office.AspNetCore.ApiControllers.VintasoftOfficeApiController
              {
                  public MyVintasoftOfficeApiController(IWebHostEnvironment hostingEnvironment)
                      : base(hostingEnvironment)
                  {
                  }
              }
          }
          
          
    5. Server side: Create CORS-policy that allows to access web services from client side.

      • Open the "Program.cs" file in "ReactApp1.Server" project and add code that:
        • Creates CORS-policy that allows to access web services from "localhost"
        • Enables CORS usage in "ReactApp1.Server" project

        Here are source codes of "Program.cs" file after update:
        Vintasoft.Imaging.Drawing.SkiaSharp.SkiaSharpDrawingFactory.SetAsDefault();
        
        var builder = WebApplication.CreateBuilder(args);
        
        // Add services to the container.
        
        builder.Services.AddControllers();
        
        builder.Services.AddCors(options =>
        {
            options.AddPolicy(name: "CorsPolicy1", policy =>
            {
                policy.SetIsOriginAllowed(origin => new Uri(origin).Host == "localhost").AllowAnyHeader().AllowAnyMethod();
            });
        });
        
        var app = builder.Build();
        
        app.UseDefaultFiles();
        app.UseStaticFiles();
        
        // Configure the HTTP request pipeline.
        
        app.UseHttpsRedirection();
        
        app.UseAuthorization();
        
        app.UseCors("CorsPolicy1");
        
        app.MapControllers();
        
        app.MapFallbackToFile("/index.html");
        
        app.Run();
        
        
    6. Server side: Update launch URL in 'launchSettings.json' file.

      • Open file "Properties\launchSettings.json" in "ReactApp1.Server" and clear launch URL:
    7. Server side: Copy XLSX documents to a server side.

      • Create folder "UploadedImageFiles\SessionID" in "ReactApp1.Server" project and copy test XLSX document "<SdkInstallPath>\VintaSoft\Imaging .NET v12.4\Examples\ASP.NET Core\CSharp\AspNetCoreSpreadsheetEditorDemo\wwwroot\UploadedImageFiles\SalesReport.xlsx" to the "UploadedImageFiles\SessionID" folder. This document will be displayed in spreadsheet document editor.

      • Create folder "Resources" in "ReactApp1.Server" project and copy XLSX document "<SdkInstallPath>\VintaSoft\Imaging .NET v12.4\Examples\ASP.NET Core\CSharp\AspNetCoreSpreadsheetEditorDemo\wwwroot\Resources\ChartSource.xlsx" to the "Resources" folder. This document will be used as a source for "standard" charts when chart is adding to spreadsheet document using "Add chart" dialog.
    8. Compile the project for restoring dependencies using 'npm'.

    9. Delete files, which are not necessary in this tutorial.

      • Delete files "WeatherForecast.cs" and "Controllers\WeatherForecastController.cs" in "ReactApp1.Server" project - the WeatherForecast Web API controller is not necessary in this tutorial.

      • Delete files "src\App.css" and "src\App.jsx" - the WeatherForecast Web API controller is not necessary in this tutorial.
    10. Client side: Add JavaScript files to the "reactapp1.client" project..

      • Copy Vintasoft.Shared.js, Vintasoft.Imaging.js and Vintasoft.Imaging.Office.js files from "<InstallPath>\VintaSoft Imaging .NET v12.4\Bin\JavaScript\" folder into "public\" folder.

      • Specify, which "standard" UI dialogs (rename worksheet dialog, find text dialog, etc) should be used by web spreadsheet document editor
        • If web spreadsheet document editor should use ready-to-use "standard" Bootstrap dialogs:
          • Add "bootstrap" Node-module to the "package.json" file. Rebuild the project for refreshing Node-modules.
            Here are source codes of "package.json" file after update:
            {
              "name": "reactapp1.client",
              "private": true,
              "version": "0.0.0",
              "type": "module",
              "scripts": {
                "dev": "vite",
                "build": "vite build",
                "lint": "eslint . --ext js,jsx --report-unused-disable-directives --max-warnings 0",
                "preview": "vite preview"
              },
              "dependencies": {
                "react": "^18.2.0",
                "react-dom": "^18.2.0",
                "bootstrap": "5.3.3"
              },
              "devDependencies": {
                "@types/react": "^18.2.66",
                "@types/react-dom": "^18.2.22",
                "@vitejs/plugin-react": "^4.2.1",
                "eslint": "^8.57.0",
                "eslint-plugin-react": "^7.34.1",
                "eslint-plugin-react-hooks": "^4.6.0",
                "eslint-plugin-react-refresh": "^0.4.6",
                "vite": "^5.2.0"
              }
            }
            
            
          • Copy Vintasoft.Imaging.Dialogs.Bootstrap.js and Vintasoft.Imaging.Office.Dialogs.Bootstrap.js files from "<InstallPath>\VintaSoft Imaging .NET v12.4\Bin\JavaScript\" folder into "public\" folder.

        • If web spreadsheet document editor should use ready-to-use "standard" jQuery UI dialogs:
          • Add "jquery-ui-dist" Node-module to the "package.json" file. Rebuild the project for refreshing Node-modules.
          • Copy Vintasoft.Imaging.Dialogs.jQueryUI.js, Vintasoft.Imaging.Dialogs.jQueryUI.d.ts, Vintasoft.Imaging.Office.Dialogs.jQueryUI.js and Vintasoft.Imaging.Office.Dialogs.jQueryUI.d.ts files from "<InstallPath>\VintaSoft Imaging .NET v12.4\Bin\JavaScript\" folder into "src\app\assets\" folder.

        • If web spreadsheet document editor should use custom "standard" dialogs,please read how to create custom "standard" dialogs here.

      • Copy files Vintasoft.Imaging.css and Vintasoft.Imaging.Office.css from "<SdkInstallPath>\VintaSoft\Imaging .NET v12.4\Bin\JavaScript\" folder to the "public\" folder.

      • Add links to Bootstrap .css-file and Vintasoft .css-files to the "index.html" file, add references to Vintasoft JavaScript files to the header of "index.html" file:


        Here are source codes of "index.html" file:
        <!doctype html>
        <html lang="en">
        <head>
            <meta charset="UTF-8" />
            <link rel="icon" type="image/svg+xml" href="/vite.svg" />
            <meta name="viewport" content="width=device-width, initial-scale=1.0" />
            <title>Vite + React</title>
        
            <link rel="stylesheet" type="text/css" href="node_modules/bootstrap/dist/css/bootstrap.css" />
            <link rel="stylesheet" type="text/css" href="public/Vintasoft.Imaging.css">
            <link rel="stylesheet" type="text/css" href="public/Vintasoft.Imaging.Office.css">
            <link rel="stylesheet" type="text/css" href="src/SpreadsheetDocumentEditorDemo.css">
        
            <script src="public/Vintasoft.Shared.js" type="text/javascript"></script>
            <script src="public/Vintasoft.Imaging.js" type="text/javascript"></script>
            <script src="public/Vintasoft.Imaging.Office.js" type="text/javascript"></script>
            <script src="public/Vintasoft.Imaging.Dialogs.Bootstrap.js" type="text/javascript"></script>
            <script src="public/Vintasoft.Imaging.Office.Dialogs.Bootstrap.js" type="text/javascript"></script>
        </head>
          <body>
            <div id="root"></div>
            <script type="module" src="/src/main.jsx"></script>
          </body>
        </html>
        
        

      • Add CSS-style "spreadsheetDocumentEditorContainer", which defines height of web spreadsheet document editor container, to the "src\SpreadsheetDocumentEditorDemo.css" file:


        Here are source codes of "SpreadsheetDocumentEditorDemo.css" file:
        h1 {
            text-align: center;
        }
        
        .spreadsheetDocumentEditorContainer {
            height: 800px;
        }
        
        
    11. Client side: Create React-component that allows to edit a spreadsheet (XLSX) document.

      • Create "SpreadsheetEditorDemo.jsx" file that will contain source codes of React-component (SpreadsheetEditorDemo class):
        • Select "Add => New Item..." context menu for folder "src\" => "Add new item" dialog will appear
        • Select "JSX File" type for new item
        • Set "SpreadsheetEditorDemo.jsx" as element name
        • Click the "Add" button => dialog will be closed and file "SpreadsheetEditorDemo.jsx" will be added into folder "src\"

        Add SpreadsheetEditorDemo class declaration with 'render' function (renders demo header and div element that will display spreadsheet document editor) to the "SpreadsheetEditorDemo.jsx" file:


        Add 'componentDidMount' function (contains JavaScript code that initializes and creates spreadsheet document editor) to the SpreadsheetEditorDemo class:


        Here is JavaScript code of "SpreadsheetEditorDemo.jsx" file:
        import { Component } from 'react';
        
        export class SpreadsheetDocumentEditorDemo extends Component {
            static displayName = SpreadsheetDocumentEditorDemo.name;
            static _isInitialized = false;
        
            render() {
                return (
                    <div>
                        <h1>VintaSoft Spreadsheet Document Editor (React + ASP.NET Core)</h1>
        
                        <div id="spreadsheetDocumentEditorContainer" className="spreadsheetDocumentEditorContainer"></div>
                    </div>
                );
            }
        
            componentDidMount() {
                if (this._isInitialized)
                    return;
                this._isInitialized = true;
        
                var Vintasoft = window.Vintasoft;
        
                // set the session identifier
                Vintasoft.Shared.WebImagingEnviromentJS.set_SessionId("SessionId");
        
                // specify web services, which should be used in this demo
                Vintasoft.Shared.WebServiceJS.defaultFileService = new Vintasoft.Shared.WebServiceControllerJS("https://localhost:7167/vintasoft/api/MyVintasoftFileApi");
                Vintasoft.Shared.WebServiceJS.defaultOfficeService = new Vintasoft.Shared.WebServiceControllerJS("https://localhost:7167/vintasoft/api/MyVintasoftOfficeApi");
        
                // create the spreadsheet document editor control settings
                var spreadsheetDocumentEditorControlSettings = new Vintasoft.Imaging.Office.UI.WebSpreadsheetDocumentEditorControlSettingsJS("spreadsheetDocumentEditorContainer", "");
        
                // create the spreadsheet document editor control
                var spreadsheetDocumentEditorControl = new Vintasoft.Imaging.Office.UI.WebSpreadsheetDocumentEditorControlJS(spreadsheetDocumentEditorControlSettings);
        
                // subscribe to the "warningOccured" event of spreadsheet document editor control
                Vintasoft.Shared.subscribeToEvent(spreadsheetDocumentEditorControl, "warningOccured", this.__spreadsheetDocumentEditorControl_warningOccured);
        
                var fileId = "SalesReport.xlsx";
                // copy the file from global folder to the session folder
                spreadsheetDocumentEditorControl.openDocument(fileId);
            }
        
            __spreadsheetDocumentEditorControl_warningOccured(event, eventArgs) {
                // show the error message
                alert(eventArgs.message);
            }
        
        }
        

      • Add created React-component to the React-application code - "src\main.jsx" file.


        Here are source codes of "main.jsx" file after update:
        import React from 'react'
        import ReactDOM from 'react-dom/client'
        import { SpreadsheetDocumentEditorDemo } from './SpreadsheetDocumentEditorDemo.jsx'
        import './index.css'
        
        ReactDOM.createRoot(document.getElementById('root')).render(
            <React.StrictMode>
                <SpreadsheetDocumentEditorDemo />
            </React.StrictMode>,
        )
        
        
    12. Run React and ASP.NET Core application and see the result.