https://community.blueprism.com/t5/Product-Forum/Unable-to-write-collection-using-MS-Excel-VBO/m-p/80182#M31951 If it doesn't solve, you are free to communicate with me whenever you want from kilincden@gmail.com Mon, 13 Aug 2018 20:03:00 GMT DenizKilinc 2018-08-13T20:03:00Z https://community.blueprism.com/t5/Product-Forum/Unable-to-write-collection-using-MS-Excel-VBO/m-p/80176#M31945 Hi I am trying save collection data into an excel-file format (.xlsx). When I am trying to use write collection object using MS-Excel VBO, I getting an error "Internal: Could not execute code stage because exception thrown by code stage: Exception has been thrown by the target of an invocation" collection can carry around 700 rows / 50 columns of data. Fri, 10 Aug 2018 08:20:00 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-write-collection-using-MS-Excel-VBO/m-p/80176#M31945 Antony_AkkaraJ 2018-08-10T08:20:00Z https://community.blueprism.com/t5/Product-Forum/Unable-to-write-collection-using-MS-Excel-VBO/m-p/80177#M31946 Check if MS Excel VBO has any errors. This usually happens if there are any errors in the object that has the action we need. Fri, 10 Aug 2018 09:42:00 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-write-collection-using-MS-Excel-VBO/m-p/80177#M31946 Niteesh_ReddyBo 2018-08-10T09:42:00Z https://community.blueprism.com/t5/Product-Forum/Unable-to-write-collection-using-MS-Excel-VBO/m-p/80178#M31947 Optionaly, convert the collection to a string where the columns are seperated by tabs and the rows by new lines. Then you can just paste it in excel without problem. Fri, 10 Aug 2018 11:23:00 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-write-collection-using-MS-Excel-VBO/m-p/80178#M31947 BastiaanBezemer 2018-08-10T11:23:00Z https://community.blueprism.com/t5/Product-Forum/Unable-to-write-collection-using-MS-Excel-VBO/m-p/80179#M31948 Hi Antony Additionally, check your inputs are specified correctly.  If your process has the correct workbook and worksheet open within the specified instance, you can leave the parameters blank. Fri, 10 Aug 2018 18:46:00 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-write-collection-using-MS-Excel-VBO/m-p/80179#M31948 TimGrassam 2018-08-10T18:46:00Z https://community.blueprism.com/t5/Product-Forum/Unable-to-write-collection-using-MS-Excel-VBO/m-p/80180#M31949 I should clarify: If your process has the correct workbook and worksheet open within the specified instance, you can leave the Workbook Name and Worksheet Name parameters blank. Fri, 10 Aug 2018 18:48:00 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-write-collection-using-MS-Excel-VBO/m-p/80180#M31949 TimGrassam 2018-08-10T18:48:00Z https://community.blueprism.com/t5/Product-Forum/Unable-to-write-collection-using-MS-Excel-VBO/m-p/80181#M31950 I had the same issue and it took months to resolve it. The reason is your region options. Your Excel options and your computers region options has to be the same. I recommend that selecting both ""Match With Windows Display Language"".  Mon, 13 Aug 2018 20:01:00 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-write-collection-using-MS-Excel-VBO/m-p/80181#M31950 DenizKilinc 2018-08-13T20:01:00Z https://community.blueprism.com/t5/Product-Forum/Unable-to-write-collection-using-MS-Excel-VBO/m-p/80182#M31951 If it doesn't solve, you are free to communicate with me whenever you want from kilincden@gmail.com Mon, 13 Aug 2018 20:03:00 GMT https://community.blueprism.com/t5/Product-Forum/Unable-to-write-collection-using-MS-Excel-VBO/m-p/80182#M31951 DenizKilinc 2018-08-13T20:03:00Z