LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
external usenet poster
 
Posts: 97
Default seeking the fastest workflow for converting bmp image into Excel orASCII table with numbers

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
workflow Steve HKG Excel Discussion (Misc queries) 5 June 10th 08 03:54 PM
Excel 2003 Workflow/Macros Birmangirl Excel Discussion (Misc queries) 2 October 23rd 07 07:15 PM
EXCEL, VSTO: Fastest way to access multiple cells Alan Excel Discussion (Misc queries) 1 June 1st 05 02:45 PM
What is fastest way to print labels from Excel data? Janis New Users to Excel 1 April 12th 05 10:37 PM
converting copied data to numbers in excel xp knutsenk New Users to Excel 5 April 3rd 05 03:34 AM


All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"