Forge Component
Published on 2018-08-02 by Carlos Alfaro
5 votes
Published on 2018-08-02 by Carlos Alfaro

When using 'Cell_WriteByName' and passing the following Cell input parameters values:

I get the following exception:

If you look at the action implemention in Integration Studio:

You notice that 'ssCellType' is repeated twice in the list of input parameters for 'MssCell_WriteByNameWithFormat'.

The first occurence of 'ssCellType' should be replaced with 'ssCellName'. Then re-publish the updated code to your environment and update your dependencies in Service Studio.


In Service Studio, set the value of 'CellName' in 'CellType'. The method won't complain as it probably defaults the cell type to 'Text'. This is ok if you cell's Category in Excel is 'Text'. It worked for me.

I recommend the first approach of course.