ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Getting Data from Adobe pdf file (https://www.excelbanter.com/excel-programming/297699-getting-data-adobe-pdf-file.html)

Ralph[_5_]

Getting Data from Adobe pdf file
 
I have pdf file (about 6000 rows). I copied & pasted into
excel as text and am able to do what I need with 1
exception.

Every sixth row (or so) consists of three checkboxes A B C

one to three may be checked. A B C pastes into excel, if
pasted as text, but the checkmarks do not unless pasted as
a bitmap.

Could you suggest a method to ascertain the checkbox
status in excel.

TIA

Ralph




Steve Garman

Getting Data from Adobe pdf file
 
Unfortunately, in the pdf, they'll just be a picture, so without some
pretty low level bitmap examination (for which I'm not volunteering but
which probably uses the GetDIBits API function) I'd guess you're stuffed.

Ralph wrote:

I have pdf file (about 6000 rows). I copied & pasted into
excel as text and am able to do what I need with 1
exception.

Every sixth row (or so) consists of three checkboxes A B C

one to three may be checked. A B C pastes into excel, if
pasted as text, but the checkmarks do not unless pasted as
a bitmap.

Could you suggest a method to ascertain the checkbox
status in excel.

TIA

Ralph






All times are GMT +1. The time now is 02:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com