Excel Showing Different Columns and Giving Like Column1 colum2 Column3

[vineelag (vineetha)]

Hi Every One,

I Have A Excel With Headers

But While Running Getting Columns Like This

Kindly Let Me Know why we are getting like this

Thank you

[sasi_poosarla (sasi p)]

@vineelag
Once check in writeline activity as item.ColumnName

and also check the property of ReadRangeWorkbook : Add Header Enable or not

[sanjay3 (Sanjay)]

Hi @vineelag

Check the Properties of read range workbook… check if add headers is ticked or not

Use the “Output Data Table” activity to convert your DataTable to a string and then use a “Write Line” activity to print it to the output panel. This will help you verify the DataTable structure.