[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
(3)
Published on 14 Nov (4 weeks ago) by Carlos Alfaro
3 votes
Published on 14 Nov (4 weeks ago) by Carlos Alfaro
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