question

HarikaVinnakota-3845 avatar image
0 Votes"
HarikaVinnakota-3845 asked IanXue-MSFT answered

Extract text contents from pdf and add to excel using powershell script

convert text file contents to excel sheet using power shell script

windows-10-network
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

IanXue-MSFT avatar image
0 Votes"
IanXue-MSFT answered

Hi,

You can use itextsharp to read pdf files in PowerShell.
http://allthesystems.com/2020/10/read-text-from-a-pdf-with-powershell/

To add contents to an excel spreadsheet you can try the ImportExcel module.
https://www.powershellgallery.com/packages/ImportExcel/
https://adamtheautomator.com/powershell-excel/

Best Regards,
Ian Xue
============================================
If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.