Is it possible to add chart on flexsheet?

Is it possible to add chart on flexsheet?

Posted by: chayankar209 on 16 May 2018, 3:42 am EST

• 

  chayankar209

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 16 May 2018, 3:42 am EST

  My requirement is to add chart on excel sheet. So I was wondering if it is possible to attach chart on flex sheet ?

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 17 May 2018, 4:04 am EST

  Hi,
  
  Please refer to the following demo sample that implements the same.
  
  http://demos.wijmo.com/5/angular/excelbook/excelbook/excellikeSheet.htm
  
  Select cell range
  
  Click on Insert Chart Button

  ~Manish

• 

  chayankar209

  • Post Options:
  • Link
    Copy

  Posted 29 May 2018, 12:39 am EST

  Hi, can you elaborate about the possible api involved in the above example.
  
  This is my scenario:

  I have a report ranging between the coulmns A to F. I want to display the data in form of chart in the same sheet, after column F.

  The chart should be based on the whole data set which is displayed.

  Thank you !

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 29 May 2018, 9:41 am EST

  Hi,
  
  You need to add wijmo.grid.sheet.chart.ts file in your project.
  
  Then get an instance of chartEngine as:-

  import * as wjcGridSheetChart from '../..path-to-file/wijmo.grid.sheet.chart';
  
  let chartEngine=new wjcGridSheetChart.ChartEngine(flexsheet);
  let chartobj=chartEngine.addChart(wjcChart.ChartType.Column,chartdata);
  

  Please refer to the following example which implements the same:-

  https://stackblitz.com/edit/angular-c3yvz5?file=app/app.component.ts

  ~Manish

• 

  chayankar209

  • Post Options:
  • Link
    Copy

  Posted 30 May 2018, 1:27 am EST

  Okay. It turns out the latest version of wijmo ( 5.20181.462) available in npm does not contain “wijmo.grid.sheet.chart”

  Is this file related to specific version of wijmo ? What am I missing ?

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 30 May 2018, 2:00 am EST

  Hi,
  
  “wijmo.grid.sheet.chart” was never a part of wijmo package. It is a separate file with custom implementation.

  Hence, you need to copy it and use in your application as shows in demo sample.

  ~Manish