[{"id":"924e5c0c-0717-4fae-9bbc-0b496941985e","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"22646924-f1ae-4a94-ac8e-e3e8ea2931f2","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"827318c4-10fd-462b-aa96-fab2cff174a9","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"8f626f70-8570-4934-a0e5-fc0ca6584738","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"1029bbcc-399c-42e6-b412-a0437395d2d5","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"7e6097ce-e53b-416c-89c8-a3708db50528","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"3d1b1e48-357c-4999-985c-d9422356690a","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"e6cb5248-c20b-4d3e-adaf-b5c547e29548","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"58695f0f-7cb8-4bad-b617-dda90b01f606","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"081f453a-0e9a-4f06-a70b-18085a1f0d81","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"2c1d8bf8-2b69-4b16-bac9-9c46901abb6a","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"a042f416-d318-415c-b294-ed88a5010572","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"7a454c88-860a-4e28-b52c-b18bae07dfe8","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"63b1ec03-c852-40ec-860e-f025c5791091","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"6b7d135b-71b4-4af7-828c-b28bf70b8ec7","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"5937193e-fd56-4296-8e32-ba41dba8e564","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"8ed468db-93ce-4cb3-8e2b-3249d9d464a7","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"4169f34f-3e9b-45c1-91bf-41c02c3ad5a4","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"411aa66d-8df8-4466-896a-d8de68cf7066","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"7fc8dcfc-27ff-4496-96c2-d92dfe1fb4b2","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"02afd225-87f7-4f6d-8be1-0a303c8beade","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"8040235f-6c53-447e-a7f0-4fe5911e066b","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"0610b0d6-03c7-461b-9dd4-f8d1b1787e7c","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"7919ac2f-121b-447c-82ed-15d13b45df0b","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"1d01b943-eac8-480b-8d85-19bd093c8b3d","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"1f4d1309-e22c-413f-848d-2c0ca8450b0e","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"66d78fb1-e833-4bbf-ac7c-6bdfce9a80b0","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"ed5ad6f1-f5a2-47b8-a915-b185e8471ca3","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"6e9decb7-47f3-4871-81b9-65504bc293f1","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"836dcc3b-2afe-4351-bf9f-bd9e2b0c8510","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"80633614-e86b-4b0b-9129-9f7acab69f6d","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"1aaae15a-3496-43eb-a681-b077034832e4","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"70ce0595-eb94-4eb3-84f6-3a89ab8a4409","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"f3e379ff-ca52-44d8-a15e-966f89904220","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"c1228456-1b5c-429d-b231-25c10a2b41cc","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"58e7444a-12e4-4161-81db-0bb54d09eca9","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"f70c6c85-addd-43e7-8e2b-69dfe4a0a2fd","tags":[{"product":null,"links":null,"id":"6c1a6899-1b88-404c-9a73-4a0c6c9090a3","name":"New","color":"Red","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]},{"id":"de70365b-d7c6-4355-a59b-3e77a6a374ae","tags":[{"product":null,"links":null,"id":"2f522515-8c88-4017-855d-905bc4b0ea3c","name":"Upd","color":"Blue","productId":"66a69675-7df9-45b2-867a-4ab2613535fa"}]}]
        
(Showing Draft Content)

Angular CLI

SpreadJS では、Angular CLI 開発環境で、個別のモジュールとプラグインの両方を使用することができます。

モジュールとプラグインをの使用

次の手順を実行します。

  1. Angular CLIをインストールする

    コマンドプロンプトウィンドウを開き、次のコマンドを入力します。

    npm install -g @angular/cli
  2. Angularアプリを作成する

    Angularアプリを作成し、アプリフォルダに移動します。

    ng new my-app
    cd my-app
  3. プロジェクトでSpreadJSモジュールとプラグインをインストールする

    次のコマンドを使用して、SpreadJS のモジュールとプラグインをインストールします。

    npm install @mescius/spread-common @mescius/spread-calc-engine @mescius/spread-sheets-core @mescius/spread-sheets-calc-engine @mescius/spread-sheets-print @mescius/spread-sheets-angular
  4. angle.jsonファイルでSpreadJS のCSSを構成する

    次のように、angular.jsonファイルでSpreadJS のCSSを構成します。

    {  
        "$schema": "./node_modules/@angular/cli/lib/config/schema.json",  
        "version": 1,  
        "newProjectRoot": "projects", 
        "projects": {    
            "my-app": {      "projectType": "application",   
            "schematics": {},      
            "root": "",     
            "sourceRoot": "src",      
            "prefix": "app",      
            "architect": {        
                "build": {          
                    "builder": "@angular-devkit/build-angular:browser",              "options": {           
                        "outputPath": "dist/my-app",            
                        "index": "src/index.html",           
                         "main": "src/main.ts",           
                         "polyfills": [              
                            "zone.js"          
                          ],           
                         "tsConfig": "tsconfig.app.json", 
                         "assets": [              
                            "src/favicon.ico",              
                            "src/assets"            
                        ],           
                         "styles": [     
                             "src/styles.css",    
                             "./node_modules/@mescius/spread-common/styles/gc.spread.sheets.excel2016colorful.css"         
                           ],          
                              "scripts": []         
                         },         
                         "configurations": {           
                             "production": {            
                                  "budgets": [           
                                     {                  
                                        "type": "initial",  
                                        "maximumWarning": "500kb",      
                                        "maximumError": "1mb"     
                                        },  
                                        {                  
                                        "type": "anyComponentStyle",                
                                        "maximumWarning": "2kb",                  
                                        "maximumError": "4kb"              
                                        }              
                                     ],              
                                    "outputHashing": "all"            
                                },            
                                "development": {             
                                "buildOptimizer": false,        
                                "optimization": false,            
                                "vendorChunk": true,              
                                "extractLicenses": false,             
                                "sourceMap": true,              
                                "namedChunks": true            
                                }          
                            },        
                            "defaultConfiguration": "production"        
                          },        
                            "serve": {          
                                "builder": "@angular-devkit/build-angular:dev-server",          
                                "configurations": {           
                                    "production": {              
                                    "browserTarget": "my-app:build:production"            
                              },            
                                "development": {          
                                    "browserTarget": "my-app:build:development"            
                              }         
                            },          
                            "defaultConfiguration": "development"        
                            },        
                            "extract-i18n": {          
                                "builder": "@angular-devkit/build-angular:extract-i18n",                      
                                "options": {                    
                                    "browserTarget": "my-app:build"          
                                 }       
                               },       
                             "test": {          
                                "builder": "@angular-devkit/build-angular:karma",          
                                "options": {            
                                    "polyfills": [              
                                        "zone.js",              
                                            "zone.js/testing"            
                                ],            
                                "tsConfig": "tsconfig.spec.json",            
                                   "assets": [              
                                        "src/favicon.ico",            
                                        "src/assets"            
                                ],           
                                "styles": [            
                                  "src/styles.css"            
                                ],            "scripts": []        
                              }
                          }
                      }
                 }  
          }
    }
  5. Angular アプリケーションで SpreadJS を使用する

    SpreadJS モジュールをインポートするには、app.module.tsファイルを次のように変更します。

    import { NgModule } from '@angular/core';
    import { BrowserModule } from '@angular/platform-browser';
    import { AppComponent } from './app.component';
    import { SpreadSheetsModule } from '@mescius/spread-sheets-angular';
    @NgModule({  
        declarations: [   
             AppComponent  
    ],  
    imports: [    
        BrowserModule,    
        SpreadSheetsModule  
    ],  
    providers: [],  b
    ootstrap: [AppComponent]})
    export class AppModule { }

    SpreadJS コンポーネントを表示するには、app.component.html ファイルを次のように変更します。

    <gc-spread-sheets [hostStyle]="hostStyle" 
    (workbookInitialized)="initSpread($event)">
    </gc-spread-sheets>

    SpreadJS コンポーネントのデータの入出力を実装するには、app.component.tsを次のように変更します。

    import { Component } from '@angular/core';
    import * as GC from "@mescius/spread-common";
    import "@mescius/spread-calc-engine";
    import "@mescius/spread-sheets-core";
    import "@mescius/spread-sheets-calc-engine";
    import "@mescius/spread-sheets-print"; 
    @Component({  
        selector: 'app-root',  
        templateUrl: './app.component.html',  
        styleUrls: ['./app.component.css']
    })
    export class AppComponent { 
        hostStyle = {    
            width: '100%',    
            height: '600px',    
            overflow: 'hidden',    
            float: 'left'  
    };  
            initSpread($event: any) {    
                let spread: GC.Spread.Sheets.Workbook = $event.spread;    
                let sheet = spread.getActiveSheet();    
                sheet.setValue(0, 0, "Hello SpreadJS");    
                spread.print();  
        }
    }

    CompilerOptions のパスを追加するには、tsconfig.json を次のように変更します。

    {  
    "compileOnSave": false,  
    "compilerOptions": {    
        "baseUrl": "./",    
        "outDir": "./dist/out-tsc",    
        "forceConsistentCasingInFileNames": true,    
        "strict": true,    
        "noImplicitOverride": true,    
        "noPropertyAccessFromIndexSignature": true,   
        "noImplicitReturns": true,    
        "noFallthroughCasesInSwitch": true,    
        "sourceMap": true,    
        "declaration": false,    
        "downlevelIteration": true,    
        "experimentalDecorators": true,    
        "moduleResolution": "node",    
        "importHelpers": true,    
        "target": "ES2022",    
        "module": "ES2022",   
        "useDefineForClassFields": false,    
        "lib": [      
            "ES2022",      
            "dom"   
        ],    
        "paths": {     
             "@mescius/spread-sheets": [ "node_modules/@mescius/spread-common" ]   
     }  
    },  
    "angularCompilerOptions": {    
        "enableI18nLegacyMessageIdFormat": false,    
        "strictInjectionParameters": true,    
        "strictInputAccessModifiers": true,    
        "strictTemplates": true  
    }
    }
  6. アプリをビルドして実行する

    次のコマンドで、アプリをビルドして実行します。

    npm start