0 Replies Latest reply: Sep 8, 2016 8:54 AM by rafael scalabrin RSS

    excel warning message

    rafael scalabrin

      Hi everyone.

      How can I check for columns in my excel files and retrive a warming message  if a column doesnt exists on a list?

      For exemple:

       

      table1.xls
      
      name1   name2
      mary    mary
      mary    mary
         
      table2.xls
      
      name2    name3    name4
      peter    peter    peter
      peter    peter    peter
      
      
      table3.xls
      
      name1  name5
      tom    tom    
      tom    tom  
      

       

      I want have on my script some array with [name1, name2, name3] and check in all my xls files and warning me that name4 on table2 and name5 on table3 were not found in the array.