Please help - how can I determine if a column exists?

[Ankur]

yes CC it is indeed simple... try this and you would be able to do it by yourself.

1) Get the count of all columns using .GetParameterCount

2) Loop through all the columns till you get the column you need. ok i would give a hint....
Use this (datatable.value ( i,SheetName))=ColName where:

• i is the index for for-loop
  
• SheetName is the name of sheet, where you want to find the required column and
  
• ColName is the name of required column
  

Let us know how it goes