Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
![]()
Hi all,
I have a lot tedious data input that I need to process. Currently I am doing these whole things manually, which is extremely tiring. Please help me out: The workflow: (1) Browse webpages, the webpages have a lot of numerical tables. (2) I copy the table into clipboard, at this stage, the table is an image in the clipboard. BMP image. And it has numerical and non- numerical cell values. Because the table has headings and decorations, such as shaded headings, shaded numbers. In fact, these tables were taken out from Excel themselves, and it is just now they are displayed on webpages and I have to put them back into Excel. (3) Hopefully, I can throw the clipboard image into an OCR BMP image to ASCII or EXCEL table converter. (4) I copy the converted result into EXCEL and save it. I mean, we don't care about the shaded headings, the decorations, etc. But all the numbers should be there. The fonts are pretty standard, as I said, the table themselves were taken out from Excel themselves. The this workflow repeats again and again. Please point me to a good OCR software which can be integrated into my workflow and make it as fast as possible. I know there are fancy OCR software available, but they use PDF or other files as inputs, which requires me to capture the web tables and save as files before using the OCR converter, which is very time consuming. I am looking for something goes directly from clipboard image and the end result is clipboard ASCII /Excel/Text tables. Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
workflow | Excel Discussion (Misc queries) | |||
Excel 2003 Workflow/Macros | Excel Discussion (Misc queries) | |||
EXCEL, VSTO: Fastest way to access multiple cells | Excel Discussion (Misc queries) | |||
What is fastest way to print labels from Excel data? | New Users to Excel | |||
converting copied data to numbers in excel xp | New Users to Excel |