Skip to main content
Y
yatins2606
Participating Frequently
May 12, 2023
Solved

Verification of excel sheet columns order

  • May 12, 2023
  • 2 replies
  • 0 views

I want to verify an excel file after uploading, whether the order of columns in excel file matches with CDT. for example, I have fields like PhysicsMarks,ChemistryMarks as second and third column respectively in excel file and want to ensure that this order of column matches with my cdt like if my cdt have 2nd and 3rd column as PhysicsMarks and ChemistryMarks. How can i achieve this function?

    Best answer by mathieud0001

    I think you could probably achieve this with a combination of excelreadcellsbyname() found in the Excel Tools plugin combined with doing a a!keys() on your CDT.

    2 replies

    mathieud0001
    mathieud0001Answer
    Brainy
    May 12, 2023

    I think you could probably achieve this with a combination of excelreadcellsbyname() found in the Excel Tools plugin combined with doing a a!keys() on your CDT.

      Y
      yatins2606Author
      Participating Frequently
      May 13, 2023

      Thank You!

      Terms & ConditionsAccessibility statement