To hide rows from the excel using SpreadJS

To hide rows from the excel using SpreadJS

Posted by: shee.krish123 on 28 June 2018, 4:23 pm EST

• 

  shee.krish123

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 June 2018, 4:23 pm EST - Updated 3 October 2022, 2:13 am EST

  Can you please help me to hide data from the sheet and i want to display only chart in the first sheet?
  
  

  

  1562×673 41.3 KB

  

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 1 July 2018, 10:28 pm EST

  Hello,

  You can have the data on another sheet and show chart on one sheet. For example:

  var sheet = spread.getSheet(0);
  
  var chart = sheet.charts.add(‘Chart’, GC.Spread.Sheets.Charts.ChartType.columnClustered, 250, 20, 400, 400, “Sheet1!A1:D4”);

  I hope it helps.

  Thanks,
  
  Deepak Sharma