UiPath Community Forum
How to read columns which are merged in excel
Help
Studio
uiautomation
yashwanth_gowda
(yashwanth gowda)
July 14, 2021, 2:24pm
1
i want to read merged columns from excel, how can i do it
Capture1
1909×938 82.1 KB
below is my code
string.Join(“,”,dtSheet1.AsEnumerable().[Select](Function(s) s.Field(Of String)(“CSSR”)).ToArray())
yashwanth_gowda
(yashwanth gowda)
July 14, 2021, 2:26pm
2
Capture
1897×501 54.3 KB
here is the field name i read “cssr” in this column 3 columns is merged i want to read each
Related topics
Topic
Replies
Views
Activity
How to read an excel which as merged cell as columns
Studio
studio
,
question
,
activities_panel
1
957
September 13, 2022
How can I merge excel files with different Columns?
Studio
uiautomation
4
623
December 10, 2022
How to read merged cells in Excel
Studio
excel
,
studio
,
question
,
tools
,
excel-automation
1
1737
February 18, 2023
I need to get Column names from "column name" column from sheet 1 and write to sheet2 as column names please find attached excel
Help
datatable
,
excel
,
uiautomation
,
studio
,
data_scraping
,
string
,
question
,
data_manipulation
2
758
December 24, 2020
Get First 8 columns from an excel and merge to another table
Forum
question
7
804
December 22, 2021