Results 1 to 1 of 1

Thread: PQ - Multiple pdf tables

  1. #1
    Sir Moderator sandy666's Avatar
    Join Date
    May 2018
    Posts
    236
    Rep Power
    7

    Cool PQ - Multiple pdf tables

    (question from the web)
    Is there a way of importing multiple pdf tables into excel via power query? I am getting data from folder, have number of pdf files in there and each file has different number of tables. I know I could do it one by one but it will just take too long.
    Combine all pdf files into one (Adobe Acrobat) then Pdf.Tables(pdf as binary, optional options as nullable record) as table

    How it works:
    Returns any tables found in pdf . An optional record parameter, options , may be provided to specify additional properties. The record can contain the following fields:
    • Implementation : The version of the algorithm to use when identifying tables. Valid values are "1.1" or null.
    • StartPage : Specifies the first page in the range of pages to examine. Default: 1.
    • EndPage : Specifies the last page in the range of pages to examine. Default: the last page of the document.
    • MultiPageTables : Controls whether similar tables on consecutive pages will be automatically combined into a single table. Default: true.
    • EnforceBorderLines : Controls whether border lines are always enforced as cell boundaries (when true), or simply used as one hint among many for determining cell boundaries (when false). Default: false.
    Last edited by sandy666; 02-22-2021 at 02:18 AM.
    sandy
    I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt

Similar Threads

  1. VLookup Across Multiple Tables By Condition
    By mahmoud-lee in forum Excel Help
    Replies: 6
    Last Post: 02-13-2014, 05:50 AM
  2. Replies: 8
    Last Post: 06-08-2013, 01:24 PM
  3. Replies: 0
    Last Post: 08-23-2012, 10:32 PM
  4. Replies: 0
    Last Post: 08-23-2012, 08:00 AM
  5. Opening a Pdf file using VBA
    By littleiitin in forum Excel Help
    Replies: 2
    Last Post: 11-30-2011, 03:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •