Pdf excel

Help Solution Accelerators
, ,
3

Hi @mively

try below steps,

  1. Assign → pdfFiles = Directory.GetFiles("C:\YourFolderPath", "*.pdf")

    • Value: Directory.GetFiles("C:\YourFolderPath", "*.pdf")

  2. Build Data Table (Create structure for extracted data)

    • Columns: Example ("FileName", "ExtractedText")
    • Output: dataTable

  3. For Each (Iterate through PDFs)

    • For Each item in: pdfFiles
    • Type Argument: String

    Inside For Each:

    • Read PDF Text

      • FileName: item
      • Output: pdfText

    • Add Data Row

      • DataTable: dataTable
      • ArrayRow: { Path.GetFileName(item), pdfText }

  4. Write Range (Excel Application Scope)

    • WorkbookPath: "C:\Output.xlsx"
    • DataTable: dataTable
    • SheetName: "Sheet1"
    • Starting Cell: "A1"
    • AddHeaders: True

If you found helpful mark as a solution.
Happy Automation @mively