Hello friends, I need help with unstructured XLSX file (or at least I call it that). Please note Column J, it is exported to have multiple rows. When I use normal Read Range activity inside Excel Application Scope it only reads the first Row of that Column (so I only get the value “a” not the res…

Main.xaml (15.2 KB) JCol should get supported by variable length - Just play with this and let me know the result

Help needed with non structural XLSX file

J0ska August 19, 2019, 2:02pm 2

A similar issue was resolved here:

Cheers

1 Like

Topic		Replies	Views
How to Read Data From Excel columns Having Delimiters Help studio	16	2385	June 29, 2019
Excel Data Manipulation - NEED HELP AIUTOOO Studio excel , activities , studio , question	3	795	October 27, 2022
Trying to read a single excel sheet as two different data tables Help datatable , uiautomation , activities	15	3167	October 29, 2018
Ungroup rows in Excel Help	1	1605	January 22, 2019
How to split data in one column to another column Automation Starter	2	689	August 22, 2022