Excel Spreadsheet and cint

Help Studio
1

Hi Folks,

Just discovered a weird thing, not sure if this has come up before.

I was trying to use cint(row(“Box”)) in an expression builder in an Assign activity and was getting an error.

It turns out since I changed the font in the Excel spreadsheet it was throwing an error. When I deleted the file and recreated it using the default font, it worked.

For info. only folks. I wonder if the control characters surrounding the new font somehow threw it off.

2

Hi,
Can you try
CInt(row.item(“Box”).tostring)
(or)
CInt(row.item(“Box”))

I Hope it works…
Mark as solution if it works

3

@douglascmcewan

You can try as

Cint(row("Box").ToString)

Hope this helps you

Thanks