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?
Discussion posts and replies are publicly visible
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.
Thank You!