Convert Text to Column (Text Wizard)

Convert Text to Column (Text Wizard)

Posted by: jerome on 28 May 2020, 9:40 am EST

• 

  jerome

  • Post Options:
  • Link
    Copy

  Posted 28 May 2020, 9:40 am EST - Updated 3 October 2022, 10:20 am EST

  Hi, can we do here in SpreadJS to convert or separate a column with delimited texts (comma separated) to have its own individual columns?
  
  

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 1 June 2020, 1:40 am EST

  Hi Jerome,

  You may use the setCsv() method for this functionality, please refer to the following code snippet:

  var data = "data1,data2,data3\ndata4,data5,data6\ndata7,data8,data9";
  spread.getActiveSheet().setCsv(0, 0, data, "\n", ",");
  

  API reference:
  
  • setCsv method: https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Worksheet~setCsv.html

  Regards