topic You could also use Data-… in Product Forum https://community.blueprism.com/t5/Product-Forum/How-do-I-export-excel-to-collection-without-header/m-p/46837#M2730 You could also use Data- OLEDB Object. You can get worksheets contents with SQL querry then.  Wed, 24 Jan 2018 14:54:00 GMT AndrzejSzady 2018-01-24T14:54:00Z How do I export excel to collection, without header? https://community.blueprism.com/t5/Product-Forum/How-do-I-export-excel-to-collection-without-header/m-p/46834#M2727 I've been trying to export an xlsx file to a collection, but the data in the excel-file does not contain headers. I want to be able to define the header names in the collection, ID-nr and Name. Excel 123;abc 124;abd 125;abe 126;abf 127;abg When using the action "Get worksheet as Collection Offset" and putting "False" in the "Use header" i still get: "Internal : Collection fields are defined but cannot be matched to the incoming collection - The collection definition does not contain the field 123" Any sugestions? Wed, 15 Nov 2017 19:11:00 GMT https://community.blueprism.com/t5/Product-Forum/How-do-I-export-excel-to-collection-without-header/m-p/46834#M2727 IL 2017-11-15T19:11:00Z Check action item would be https://community.blueprism.com/t5/Product-Forum/How-do-I-export-excel-to-collection-without-header/m-p/46835#M2728 Check action item would be with ""Get Worksheet as Collection Offset"" Under that, Give 'startcell' reference from Excel ""A1""(Cross check the cell value from Excel sheet ) &' Useheadr' flag with ""False"" flag For the above error message, ensure whether the collection is defined with any Field or Initial Values.If yes, Please remove those and run it. Hopefully, should work. Wed, 15 Nov 2017 20:14:00 GMT https://community.blueprism.com/t5/Product-Forum/How-do-I-export-excel-to-collection-without-header/m-p/46835#M2728 shiva_shankarre 2017-11-15T20:14:00Z You can't read into a https://community.blueprism.com/t5/Product-Forum/How-do-I-export-excel-to-collection-without-header/m-p/46836#M2729 You can't read into a collection that has defined columns if those columns don't match the file. You'll need to read into a dynamic (undefined) collection first. Wed, 15 Nov 2017 23:02:00 GMT https://community.blueprism.com/t5/Product-Forum/How-do-I-export-excel-to-collection-without-header/m-p/46836#M2729 John__Carter 2017-11-15T23:02:00Z You could also use Data-… https://community.blueprism.com/t5/Product-Forum/How-do-I-export-excel-to-collection-without-header/m-p/46837#M2730 You could also use Data- OLEDB Object. You can get worksheets contents with SQL querry then.  Wed, 24 Jan 2018 14:54:00 GMT https://community.blueprism.com/t5/Product-Forum/How-do-I-export-excel-to-collection-without-header/m-p/46837#M2730 AndrzejSzady 2018-01-24T14:54:00Z