[Excel_package] [Excel_package] - Address is not invalid or out of range

[Excel_package] [Excel_package] - Address is not invalid or out of range

  
Forge Component
(2)
Published on 2 Nov by Vera Tiago
2 votes
Published on 2 Nov by Vera Tiago
Hi,

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.

OR

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.

Thanks,
Shirad