How to Copy Whole Column in Excel

[MD_Farhan1 (MD Farhan)]

Hi,

I want to copy whole column from excel store in some variable or data table without using excel application scope.
Thank you

Regards,
Mohamed Farhan

[Parvathy (PS Parvathy)]

Hi @MD_Farhan1

=> Read Range Workbook
Output → dtExcelData

=> Use this in Assign activity:
columnData = dtExcelData.AsEnumerable().Select(Function(row) row(0)).ToList()

*columnData is of DataType System.Collections.Generic.List(System.String)

Change the index number according to your column 0 represents first column. Change according to that.

Hope it helps!!

[Krishna_Raj]

@MD_Farhan1

Activities - Read Range Workbook

check the workbook activitys its not required any scope

[MD_Farhan1 (MD Farhan)]

@Parvathy

System.Collections.Generic.List(System.String)

Hi,
System.Collections.Generic.List(System.String)

above Datatype not showing.

[Parvathy (PS Parvathy)]

Hi @MD_Farhan1

Click on Browse for Types and type this it will show the datatype.

Regards

[MD_Farhan1 (MD Farhan)]

I Got Error.

Regards,

[Parvathy (PS Parvathy)]

Hi @MD_Farhan1

Try giving it as List(Object).

Regards

[MD_Farhan1 (MD Farhan)]

@MD_Farhan1

System.Collections.Generic.List

not replace the value only data type. i want all column value .

Thank You

Regards,

[Parvathy (PS Parvathy)]

Hi @MD_Farhan1

In Replace with wite this way:
String.Join(vbcrlf, columnData)

Regards