| Lotus Seven Club Forums  
profile | register | search | faq/smilies | password Styles: Default | Big Type | In the Office? |
[ Lotus Seven Register ]
We Support 
|
Lotus Seven Club Forums
ChitChat
 Scanning documents into Excel
|
 Post Reply |
| Author | Topic |
|---|---|
| Ivaan Windbag Location: Sevening in Salop | Posted - 8 November 2009 16:04   
I've tried a couple of downloaded programmes that are supposed to do this, but they loose the format. I need to scan a Bill of Quants into Excel.Anyone Know how?? Cheers, Clive |
| anthonym Yawn..... Location: Zermatt, Switzerland 6/02 7/03 Tel:GB01565818082 | Posted - 8 November 2009 19:09
ok I'll bite: what exactly are you doing? a scan suggests an image, which isn't editable and so can't lose its format - unless you mean scan and o.c.r. into text, in which case keeping the formatting would be a pleasant surprise, in my experience some time back. Anthony |
| EFA Anyone know where I can get some sunshine? Location: | Posted - 9 November 2009 23:32
You cannot do this without intelligent zonal scanning as offered by Kofax Ascent and the like which is designed for batch scanning of specifcally formatted documents. With Kofax you still have to write a release script to push teh data to Excel. What you could TRY, is scanning it using Adobe Capture. Then the OCR text might have a white space between the records which you could use a s acolum delimiter. I would not hold out much hope though. |
| andy_h Anyone got a sock? Location: Winchester, Hampshire | Posted - 10 November 2009 9:26
I think I can do this (we've just had some new software installed called Paperport from Xreox). Email the doc to me at harringtonandy at yahoo dot co dot uk and I'll try it. When do you need it as I'm not back in my office until late today or tomorrow? White road legal 2.0 HPC VX race car - stolen with trailer 27/03/09... found 11/06/09  ... now under repair |
| Ivaan Windbag Location: Sevening in Salop | Posted - 10 November 2009 14:24
Hi all, Thanks for the replies. I want to scan in a paper document ( 30 plus pages ), with rows and columns into excel for further processing/editing. I've tried OCR software but the format was lost. I'm using a Dell 924 printer/scanner. I have done this in the past fairly sucessfully, using an old "Time" machine and scanner, with ???? software. I've got my missus to re-type this one, but I get a lot of these, and not all the clients will send the file in electronic format. Andy, thanks very much for the offer, but since I do get quiet a few documents, I need the facility / knowledge of how to do this myself. I'll get my teenage son to sort it out......if I can get him out of bed!! Cheers, Clive |
| Post Reply |
|
Lotus Seven Club Forums
ChitChat
Scanning documents into Excel
|
Please note: Any opinions expressed in the posts above are those of the author, not of the Lotus Seven Club |
Click Here To Close thread (Topic Starter, Administrators & Moderators Only).
Show All Forums | Post Reply