Unable to write collection using MS-Excel VBO

[Antony_AkkaraJ]

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.

[Niteesh_ReddyBo]

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.

[BastiaanBezemer]

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.

[TimGrassam]

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.

[TimGrassam]

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.

[DenizKilinc]

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"". 

[DenizKilinc]

If it doesn't solve, you are free to communicate with me whenever you want from kilincden@gmail.com