•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to count the number of pages of each PDF on a list?
Hello,
I'm frequently using power query for listing all the files in a folder.
Now when I list PDF files, it looks something like this:
File01.pdf
File02.pdf
File03.pdf
etc...
What I need to produce is something like
File01.pdf
| Name | Number of pages |
|---|---|
| File01.pdf | 32 |
| File02.pdf | 201 |
| File03.pdf | 12 |
etc...
Basically, I need to read the number of pages from each PDF file fully automatically and have it update as I add and remove files from the folder. I don't need to read any other data from the PDF's.
Is there a way to do this without VBA? I need to be able to share my workbooks with third parties who might fully justifiably disable any VBA in the workbook.
Thank you for your answers in advance.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#power query
#PDF files
#count pages
#automatically