How to extract table data/items from an image file and write in excel? (without DU) [image]

Hope this helps: [image] A table detection, cell recognition and text extraction algorithm to convert... How to turn screenshots of a table to editable data using OpenCV and pytesseract Reading time: 9 min read

Thank you for the help, but I don’t know python so it won’t be of much help. I am trying to do it on UiPath.

@Palaniyappan , @Lahiru.Fernando , @loginerror please help me with any suggestion on how to achieve this.

I appreciate your help @SenzoD , but this is not one time thing, so i have to do it the way in which I can explain or can help with project more.

If the table structure is always the same, I would recommend to use an OCR engine to get the text and then with Regex, manipulate the text, such that to split it in rows and then in columns.

The problem is I am not getting proper text from OCR, I used tesseract OCR

You can try different OCR engines, and play with the Scale property, to obtain better results. There are also available cloud trial versions for others, like Microsoft, Abbyy if the free ones do not deliver the expected results.

Hi @SenzoD , Thanks for the script. Just wanted to confirm, is this a generic one or for a sepcific table type ? please advise, thanks in advance. :grinning:

Table data extraction from image file

Help

SenzoD (Senzo Dlomo) September 23, 2020, 5:31am 5

that’s a copy and paste. UiPath has an execute python code activity.

Or you can use the bot to open CMD and run the Python code. might take you a bit of googling and figuring stuff but it’s worth it.

@indrajit.shah

While waiting for help, browse through the below and see if it helps:

Topic		Replies	Views
How do I extract a data table with an image into text? StudioX studiox , question	2	181	April 5, 2024
How to extract table data from an image in data table format Learning Hub	8	4703	November 27, 2024
EXTRACTING TABLE FROM SCANNED IMAGE Help datatable , excel , studio	2	1239	November 17, 2020
Extraction of text from an image using OCR Help	4	4351	February 5, 2018
Extract the data from image Help excel , ocr , activities , question	12	4608	November 20, 2019

Table data extraction from image file

Related topics