Add columns to an exiting table

Add columns to an exiting table

Posted by: jeff on 10 November 2019, 11:47 am EST

• 

  jeff

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 10 November 2019, 11:47 am EST

  Guys I have an existing table in a sheet. Now I have new Column I need to add to my table. Can I do this? Or do I need to delete and recreate the table?

  
  const table = sheet.tables.findByName(workbookTableSourceId);
  table.AddNew AwesomeColumn('An Awesome Column Name');
  
  

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 10 November 2019, 7:54 pm EST

  Hi Jeff,
  
  Spread v13 has more features for Tables which allows adding the columns to the existing table.
  
  Please refer to the following documentation and blog:
  
  https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Tables.Table~insertColumns.html

  https://www.grapecity.com/blogs/spreadjs-v13-table-enhancements

  Hope it helps!

  Regards,
  
  Manish Gupta