Hey while I’m retrieving data from excel im getting data but like this [Screenshot (72)] instead like this but i want only [{26},{38},{and so on}] i don’t want anything else thanks advanced

Hi May I know how the data is actually in Excel @Mayur_Pawar

yeah sure @Palaniyappan [Screenshot (67)] in this format :point_up:

how and where should i apply ? @Manish540 [Screenshot (74)]

Hi @Mayur_Pawar What is your logic? Are you trying to fetch “B” column values?

as i showed above excel snap i trying to get data in json format and im getting that but the format in which i want is [Screenshot (72)] like this i want only value 26,38,74 etc like that @aanandsanraj

Hi @Mayur_Pawar Click on Matches of Configure Regular Expression and then give the expression Thanks Ashwin S

The result is getting with datatable column header. Try the below code without header JsonConvert.SerializeObject(dt.AsEnumerable().[Select](Function(x) x("ColumnName").ToString()).ToList())

Apply regex for this output, [image]

what can be regex for this ? @Manish540

Excel operation state

Help

Manish540 (Manish Shettigar) December 30, 2019, 7:29am 4

Apply this regex “(?<=:)\d{0,}” on your expression.

Topic		Replies	Views
Extract numbers only from Excel column Activities datatable , excel , activities , question	7	2868	March 24, 2021
How to extract specific data from a string in excel into a variable Studio studio , question , activities_panel	12	331	May 10, 2024
Preprocess Excel Column Activities datatable , excel , uiautomation , activities , data_scraping , question	4	1338	April 18, 2021
Extract only selected data Help	25	1993	June 11, 2019
How to use regex for excel column Studio studio , bug , object_repository	3	833	April 10, 2023

Excel operation state

Related topics