Author Topic: Creating Dynamic Columns while using the importXl method  (Read 135 times)

pbassey

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 27
    • View Profile
Creating Dynamic Columns while using the importXl method
« on: October 28, 2022, 12:30:14 am »
Does your grid control support the loading of data from and excel file (using the importXL method) as well as calculated columns in-between the columns/rows loaded as a result of the importXL data load?

I want to load all the data from an .xlsx file, but also insert new columns inside the loaded grid that has formulas such as "MID(N3,6,19).

Is this possible ??

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 5830
    • View Profile
Re: Creating Dynamic Columns while using the importXl method
« Reply #1 on: October 28, 2022, 07:07:48 am »
[ Only Pro members may read this post. ]