ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: EPM Solutions on September 30, 2020, 09:55:30 pm

Title: How can we import data of Excel to grid with existing(or as new) record?
Post by: EPM Solutions on September 30, 2020, 09:55:30 pm

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.

Title: Re: How can we import data of Excel to grid with existing(or as new) record?
Post by: paramvir 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