• Neo

Bot 6: Extract Table Data From Pdf To Excel

Scenario

  • The bot will read pdf files from an input folder and extract all the table data inside it, then save to excel files.

  • The user doesn't want to upload the pdf files to external sites for extraction.

Benefits

  • Reduce time spent on manual data entry.

  • Cost-effective.

How it works



Techniques used

  • Web automation.

  • File, Zip activities.

  • CSharpScripting: write a method to get all file names from a folder.


How to use

  • Set up Excalibur: https://excalibur-py.readthedocs.io/en/master/

  • Download the bot package (.aupkg) here.

  • Open Auteros Studio. if you don't have Auteros Studio installed, you can get it here.

  • Open the Explorer tab, from the root Auteros Node, right-click and then click Import Workflow Package, then point to the ExtractTableFromPdfToExcel.aupkg file.

  • Open the ExtractTable_Main workflow and set value for inFolderPath and outFolderPath variables.

  • Run the workflow.




You can reap the benefits of automation immediately with no risks now by getting Auteros RPA Community Version.

Then you can go to our Bot Store to see or learn how bots are implemented. We are keep adding to it.

18 views

Contact

+84 (90) 541-873

  • LinkedIn
  • Facebook
  • Twitter
  • YouTube

Copyright ©2020 by Auteros. All rights reserved.