https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-as-Collection-Offset-error-not-reading-headers/m-p/73429#M26034 Check if A1 is blank, then set its value to anything you like, then run your Excel VBO/Get Worksheet as Collection Offset action. It does stupid stuff like: Dim cell as Object = ws.Range(Start_Cell) Dim r as Object = ws.UsedRange.Offset(cell.row-1,cell.column-1) r.Select() r.Copy() If your Start_Cell is A5, UsedRange is something like A5:Z100, after offset, actual range you are readding is A9:Z104 Tue, 18 Dec 2018 14:04:00 GMT AndreyKudinov 2018-12-18T14:04:00Z https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-as-Collection-Offset-error-not-reading-headers/m-p/73428#M26033 hi there! Does anyone else get this weird error: We are reading a table from Excel a collection - using Excel VBO/Get Worksheet as Collection Offset. The table is located in A5. Now. we experience weird error, where - if we had ANY data (header) above line 5 it will work fine, otherwise it will read the table, taking everything from 1st row (A6-N6) as headers. Which is then useless as we are using dynamic table (no columns are prescribed when the collection is initialised).. Did anyone experience the same problem with this object/functionality? How did you fix it? One of proposed fixes (rather crude) is to populate A1 with any value (current date for example) at the top of the VBO code, but i was hoping someone would have corrected the faulty VB code by now.. Regards Fri, 14 Dec 2018 17:59:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-as-Collection-Offset-error-not-reading-headers/m-p/73428#M26033 Dawid.Pekala 2018-12-14T17:59:00Z https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-as-Collection-Offset-error-not-reading-headers/m-p/73429#M26034 Check if A1 is blank, then set its value to anything you like, then run your Excel VBO/Get Worksheet as Collection Offset action. It does stupid stuff like: Dim cell as Object = ws.Range(Start_Cell) Dim r as Object = ws.UsedRange.Offset(cell.row-1,cell.column-1) r.Select() r.Copy() If your Start_Cell is A5, UsedRange is something like A5:Z100, after offset, actual range you are readding is A9:Z104 Tue, 18 Dec 2018 14:04:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-as-Collection-Offset-error-not-reading-headers/m-p/73429#M26034 AndreyKudinov 2018-12-18T14:04:00Z https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-as-Collection-Offset-error-not-reading-headers/m-p/73430#M26035 Thanks aikudino. Exactly what we were thinking.. Having come from a field where coding excel macros were daily bread I find the VBOs to be rather... basic..  Regards Wed, 19 Dec 2018 04:11:00 GMT https://community.blueprism.com/t5/Product-Forum/Get-Worksheet-as-Collection-Offset-error-not-reading-headers/m-p/73430#M26035 Dawid.Pekala 2018-12-19T04:11:00Z