How to insert the URL in Excel

Help Studio
1

Hi,

I want to insert the Copied Link address(URL) into the excel Sheet.
image

I am getting the below error while adding this to the DataTable.

image
image1836×118 31.4 KB

Can anyone please suggest the solution.

Thanks in Advance

2

Hi @raju_alakuntla

I hope you are using Build Data Table activity. If yes change the datatype to Object

The image shows a "Build Data Table" dialog box with two columns, "Column1 (Object)" and "Column2 (Int32)", and a single row containing the value 1 in the second column. (Captioned by AI)

Regards,

3

@raju_alakuntla,

Change the Datatype of your Table Column to String from Int32

Thanks,
Ashok :slight_smile:

4

Hello @raju_alakuntla

If you are reading an Excel-file, the problem could relate to the “interpretation” of the column datatype.
Perhaps try to change the property “Preserve format” on your Read Range activity.

But as the others suggest, it seems that you are trying to write a String to an Int32-type column.

Regards
Soren

5

@raju_alakuntla

As per error the column type is integer…please check build datatable and see if the column type is string or not

Cheers

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.