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
836
September 13, 2022
How can I merge excel files with different Columns?
Studio
uiautomation
4
488
December 10, 2022
How to read merged cells in Excel
Studio
excel
,
studio
,
question
,
tools
,
excel-automation
1
1274
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
668
December 24, 2020
Get First 8 columns from an excel and merge to another table
Forum
question
7
766
December 22, 2021
Sign Up
Log In
Log In using your UiPath Account to:
• get help with your automation projects
• share feedback, report bugs or just drop
us any question
• become an MVP and get access to
exclusive events
• save your user preferences like themes
and more
• automatically sign in to other services
• get in touch with our Forum staff
Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...