Author Topic: How can we import data of Excel to grid with existing(or as new) record?  (Read 1383 times)

EPM Solutions

  • Pro Ultimate
  • Full Member
  • *
  • Posts: 182
    • View Profile
Hi Team,

Can you please provide an example that how can we import data of Excel to grid without changing its column title (because normal import column is changing A, B, C like Excel)?

I want to import/add the data of below excel under the data of grid (do not replace the old data ) shown in below images.
« Last Edit: September 30, 2020, 10:52:18 pm by EPM Solutions »

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: How can we import data of Excel to grid with existing(or as new) record?
« Reply #1 on: September 30, 2020, 11:00:00 pm »
Please pass keepCM: true to importWb method to keep original colModel of grid

https://paramquery.com/pro/api#method-importWb