You can create a Histogram sparkline using the HistogramSparkline function in a formula: =HISTOGRAMSPARKLINE(dataRange,continuous?,paintLabel?,scale?,barWidth?,barColor?,labelColor?,edgeColor?).
The function has the following parameters:
dataRange: It's a range or calc array,such as "A1:C6" or "{1,2,2,3,3}". If a cell value isn't a valid number, it will be ignore.
continuous: (optional) If it's true, the histogram is continuous. If it's false, the histogram is discrete.
paintLabel: (optional) Boolean that represents whether to show the data label.
scale: (optional) Number that represents the data binning width when histogram is continuous. (value > 0)
barWidth: (optional) Number that represents the percent of bar width according to the average bar width. (value > 0 && value <= 1)
barColor: (optional) String that represents the bar color.
labelFontStyle: (optional) String that represents the data label font style. It supports custom font style, font weight, font family, font size.
labelColor: (optional) String that represents the data label font color. It support CSS color.
edgeColor: (optional) String that represents the color of bar edge.
import { Component, NgModule, enableProdMode } from '@angular/core';
import { BrowserModule } from '@angular/platform-browser';
import { platformBrowserDynamic } from '@angular/platform-browser-dynamic';
import { SpreadSheetsModule } from '@mescius/spread-sheets-angular';
import GC from '@mescius/spread-sheets';
import './styles.css';
@Component({
selector: 'app-component',
templateUrl: 'src/app.component.html'
})
export class AppComponent {
spread: GC.Spread.Sheets.Workbook;
hostStyle = {
width: '100%',
height: '100%',
overflow: 'hidden',
float: 'left'
};
initSpread(event:any){
var spread=event.spread;
spread.fromJSON(data);
var sheet = spread.getSheet(0);
spread.suspendPaint();
for(var i=0; i<7;i++){
var column = String.fromCharCode(65 + i);
sheet.setFormula(3, i, 'HISTOGRAMSPARKLINE('+column+'4:'+column+
'50,TRUE,TRUE,10,1,"#DDDDDD","normal normal 8pt Calibri", "#000000", "#C0C0C0")');
i++;
}
spread.resumePaint();
}
}
@NgModule({
imports: [BrowserModule, SpreadSheetsModule],
declarations: [AppComponent],
exports: [AppComponent],
bootstrap: [AppComponent]
})
export class AppModule {}
enableProdMode();
// Bootstrap application with hash style navigation and global services.
platformBrowserDynamic().bootstrapModule(AppModule);
<!doctype html>
<html style="height:100%;font-size:14px;">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<link rel="stylesheet" type="text/css" href="$DEMOROOT$/en/angular/node_modules/@mescius/spread-sheets/styles/gc.spread.sheets.excel2013white.css">
<!-- Polyfills -->
<script src="$DEMOROOT$/en/angular/node_modules/core-js/client/shim.min.js"></script>
<script src="$DEMOROOT$/en/angular/node_modules/zone.js/fesm2015/zone.min.js"></script>
<!-- SystemJS -->
<script src="$DEMOROOT$/spread/source/data/histogramSparkline.js"></script>
<script src="$DEMOROOT$/en/angular/node_modules/systemjs/dist/system.js"></script>
<script src="systemjs.config.js"></script>
<script>
// workaround to load 'rxjs/operators' from the rxjs bundle
System.import('rxjs').then(function (m) {
System.import('@angular/compiler');
System.set(SystemJS.resolveSync('rxjs/operators'), System.newModule(m.operators));
System.import('$DEMOROOT$/en/lib/angular/license.ts');
System.import('./src/app.component');
});
</script>
</head>
<body>
<app-component></app-component>
</body>
</html>
<div class="sample-tutorial">
<gc-spread-sheets [hostStyle]="hostStyle" (workbookInitialized)="initSpread($event)" [newTabVisible] = false>
<gc-worksheet>
</gc-worksheet>
<gc-worksheet></gc-worksheet>
</gc-spread-sheets>
</div>
export var data = {
"version": "14.0.0",
"customList": [
],
"sheets": {
"Sheet1": {
"name": "Sheet1",
"isSelected": true,
"rowCount": 42,
"columnCount": 7,
"activeRow": 7,
"activeCol": 3,
"theme": "Office",
"data": {
"dataTable": {
"0": {
"0": {
"value": "Name",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": "Math",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": "English",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": "Foreign Language",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": "History",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": "Physical",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": "Total score",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"1": {
"2": {
"style": {
"hAlign": 3,
"vAlign": 0,
"themeFont": "Body",
"imeMode": 1
}
},
"3": {
"style": {
"hAlign": 3,
"vAlign": 0,
"themeFont": "Body",
"imeMode": 1
}
},
"4": {
"style": {
"hAlign": 3,
"vAlign": 0,
"themeFont": "Body",
"imeMode": 1
}
},
"5": {
"style": {
"hAlign": 3,
"vAlign": 0,
"themeFont": "Body",
"imeMode": 1
}
},
"6": {
"style": {
"hAlign": 3,
"vAlign": 0,
"themeFont": "Body",
"imeMode": 1
}
}
},
"2": {
"0": {
"value": "Benjamin Suaava",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 71,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 64,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 74,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 85,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 100,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 394,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"3": {
"0": {
"value": "Lashunda Cerda",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 76,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 87,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 58,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 84,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 88,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 394,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"4": {
"0": {
"value": "Damion Olaya",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 100,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 78,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 80,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 80,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 74,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 411,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"5": {
"0": {
"value": "Jermaine Cullity",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 55,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 68,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 100,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 60,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 84,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 366,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"6": {
"0": {
"value": "Mitchell Howles",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 100,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 66,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 83,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 90,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 94,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 433,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"7": {
"0": {
"value": "Rhonda Coonrod",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 71,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 76,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 78,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 82,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 72,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 379,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"8": {
"0": {
"value": "Charlette Mathieu",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 84,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 61,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 80,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 93,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 83,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 401,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"9": {
"0": {
"value": "Max Stampley",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 86,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 68,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 76,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 92,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 56,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 378,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"10": {
"0": {
"value": "Karon Ienco",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 78,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 99,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 61,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 68,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 91,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 396,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"11": {
"0": {
"value": "Clarinda Carlo",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 85,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 74,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 58,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 68,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 92,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 377,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"12": {
"0": {
"value": "Hector Grotheer",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 76,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 92,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 70,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 81,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 55,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 374,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"13": {
"0": {
"value": "Bill Stahr",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 71,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 77,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 77,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 85,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 83,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 393,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"14": {
"0": {
"value": "Amal Mano",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 82,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 96,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 100,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 90,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 66,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 434,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"15": {
"0": {
"value": "Shaunda Scullark",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 80,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 89,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 87,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 85,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 83,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 423,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"16": {
"0": {
"value": "Arnita Paladini",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 89,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 63,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 85,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 65,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 100,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 402,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"17": {
"0": {
"value": "Janel Munier",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 80,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 88,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 67,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 100,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 77,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 412,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"18": {
"0": {
"value": "Gabriel Patty",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 86,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 95,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 100,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 75,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 78,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 434,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"19": {
"0": {
"value": "Rick Seabrooke",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 86,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 90,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 61,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 91,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 91,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 420,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"20": {
"0": {
"value": "Clark Willemsen",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 99,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 81,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 60,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 92,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 96,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 428,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"21": {
"0": {
"value": "Asha Karsnak",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 83,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 60,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 91,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 93,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 62,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 388,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"22": {
"0": {
"value": "Tajuana Fraughton",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 76,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 81,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 81,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 87,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 67,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 393,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"23": {
"0": {
"value": "Roxann Fornili",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 63,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 82,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 98,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 82,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 67,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 392,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"24": {
"0": {
"value": "Chastity Paponetti",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 69,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 82,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 56,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 82,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 81,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 369,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"25": {
"0": {
"value": "Gordon Dinucci",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 68,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 75,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 74,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 42,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 51,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 311,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"26": {
"0": {
"value": "Giovanni Behrle",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 84,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 64,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 64,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 73,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 58,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 344,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"27": {
"0": {
"value": "Patrina Scoleri",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 70,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 60,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 91,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 84,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 57,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 363,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"28": {
"0": {
"value": "Francis Borden",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 70,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 76,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 38,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 86,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 99,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 369,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"29": {
"0": {
"value": "Branden Nauman",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 78,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 80,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 61,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 81,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 73,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 373,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"30": {
"0": {
"value": "Moshe Ballagas",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 100,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 75,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 52,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 72,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 76,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 376,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"31": {
"0": {
"value": "Leisa Yoes",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 100,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 46,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 75,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 99,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 64,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 384,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"32": {
"0": {
"value": "Shauna Holbert",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 92,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 80,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 88,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 96,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 77,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 434,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"33": {
"0": {
"value": "Dottie Ackman",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 100,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 54,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 38,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 55,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 89,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 335,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"34": {
"0": {
"value": "Genie Duplessis",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 100,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 88,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 81,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 48,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 83,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 400,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"35": {
"0": {
"value": "Leandro Sarcinella",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 77,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 63,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 70,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 94,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 100,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 404,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"36": {
"0": {
"value": "Sandy Spenner",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 85,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 72,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 71,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 76,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 87,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 390,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"37": {
"0": {
"value": "Rafaela Maag",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 100,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 87,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 80,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 100,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 80,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 447,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"38": {
"0": {
"value": "Rickie Durning",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 64,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 76,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 61,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 81,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 85,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 366,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"39": {
"0": {
"value": "Ethel Stamand",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 95,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 76,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 72,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 86,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 71,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 399,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"40": {
"0": {
"value": "Bradley Aldridge",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 72,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 70,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 60,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 78,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 75,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 355,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
},
"41": {
"0": {
"value": "Stewart Swiat",
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"1": {
"value": 89,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"2": {
"value": 81,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"3": {
"value": 100,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"4": {
"value": 99,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"5": {
"value": 99,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
},
"6": {
"value": 467,
"style": {
"vAlign": 2,
"font": "14.6667px 等线"
}
}
}
},
"defaultDataNode": {
"style": {
"themeFont": "Body"
}
}
},
"rowHeaderData": {
"defaultDataNode": {
"style": {
"themeFont": "Body"
}
}
},
"colHeaderData": {
"defaultDataNode": {
"style": {
"themeFont": "Body"
}
}
},
"rows": [
null,
{
"size": 20
}
],
"columns": [
{
"size": 122
},
{
"size": 36
},
{
"size": 48
},
{
"size": 117
},
{
"size": 48
},
{
"size": 53
},
{
"size": 72
}
],
"leftCellIndex": 0,
"topCellIndex": 0,
"selections": {
"0": {
"row": 7,
"rowCount": 1,
"col": 3,
"colCount": 1
},
"length": 1
},
"rowOutlines": {
"items": [
]
},
"columnOutlines": {
"items": [
]
},
"cellStates": {
},
"outlineColumnOptions": {
},
"autoMergeRangeInfos": [
],
"printInfo": {
"paperSize": {
"width": 850,
"height": 1100,
"kind": 1
}
},
"index": 0
}
}
}
.sample-tutorial {
position: relative;
height: 100%;
overflow: hidden;
}
body {
position: absolute;
top: 0;
bottom: 0;
left: 0;
right: 0;
}
.sample-spreadsheets {
height: 100%;
}
(function (global) {
System.config({
transpiler: 'ts',
typescriptOptions: {
tsconfig: true
},
meta: {
'typescript': {
"exports": "ts"
},
'*.css': { loader: 'css' }
},
paths: {
// paths serve as alias
'npm:': 'node_modules/'
},
// map tells the System loader where to look for things
map: {
'core-js': 'npm:core-js/client/shim.min.js',
'zone': 'npm:zone.js/fesm2015/zone.min.js',
'rxjs': 'npm:rxjs/dist/bundles/rxjs.umd.min.js',
'@angular/core': 'npm:@angular/core/fesm2022',
'@angular/common': 'npm:@angular/common/fesm2022/common.mjs',
'@angular/compiler': 'npm:@angular/compiler/fesm2022/compiler.mjs',
'@angular/platform-browser': 'npm:@angular/platform-browser/fesm2022/platform-browser.mjs',
'@angular/platform-browser-dynamic': 'npm:@angular/platform-browser-dynamic/fesm2022/platform-browser-dynamic.mjs',
'@angular/common/http': 'npm:@angular/common/fesm2022/http.mjs',
'@angular/router': 'npm:@angular/router/fesm2022/router.mjs',
'@angular/forms': 'npm:@angular/forms/fesm2022/forms.mjs',
'jszip': 'npm:jszip/dist/jszip.min.js',
'typescript': 'npm:typescript/lib/typescript.js',
'ts': './plugin.js',
'tslib':'npm:tslib/tslib.js',
'css': 'npm:systemjs-plugin-css/css.js',
'plugin-babel': 'npm:systemjs-plugin-babel/plugin-babel.js',
'systemjs-babel-build':'npm:systemjs-plugin-babel/systemjs-babel-browser.js',
'@mescius/spread-sheets': 'npm:@mescius/spread-sheets/index.js',
'@mescius/spread-sheets-angular': 'npm:@mescius/spread-sheets-angular/fesm2020/mescius-spread-sheets-angular.mjs',
'@grapecity/jsob-test-dependency-package/react-components': 'npm:@grapecity/jsob-test-dependency-package/react-components/index.js'
},
// packages tells the System loader how to load when no filename and/or no extension
packages: {
src: {
defaultExtension: 'ts'
},
rxjs: {
defaultExtension: 'js'
},
"node_modules": {
defaultExtension: 'js'
},
"node_modules/@angular": {
defaultExtension: 'mjs'
},
"@mescius/spread-sheets-angular": {
defaultExtension: 'mjs'
},
'@angular/core': {
defaultExtension: 'mjs',
main: 'core.mjs'
}
}
});
})(this);
