'how can i extract the data from excell sheet to mysql in node.js?

im working on export the import export data from excell sheet to sequlize mysql. im facing the issue during extract the data from one column of excell sheet.

im getting this datai have to get this image data

let str = [
  'CABBAGE - Approx 800g - 1.3Kg * 1  ₹44.55\r\n' +
    "LADY'SFINGER/BHENDI - 1Kg * 1  ₹61.20\r\n" +
    'BRINJAL LONG/ BAIGAN - 500g * 1  ₹23.24\r\n' +
    'LEMON - 6 pieces * 1  ₹24.00\r\n' +
    'KIRA / CUCUMBER GREEN - 1Kg * 1  ₹35.00\r\n' +
    'CARROT - 500g * 1  ₹41.65\r\n' +
    'Amrutanjan Strong Pain Balm Double Power  - 50ml * 1  ₹118.75\r\n' +
    'Pediasure 7',
  ' Specialized Nutrition Drink Powder for Growing Children- Chocolate Flavour  - 200g * 1  ₹223.10'
]
let str1 = JSON.parse(str)
console.log( str1)

how can i upload thes all details into mysql defrent defrent column ??

mysql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions