Skip to main content
Nintex Community Menu Bar

Working with excel files

  • September 7, 2020
  • 10 replies
  • 18 views
  • Translate

There are 100 Excel files, you need to take data from each and enter it into one pivot table, files are added over time, how to do this so that information from new files is dynamically added to the pivot file, the problem arises when checking the number of files. How can you check the number of Excel files in a folder?

Did this topic help you find an answer to your question?

10 replies

  • 118 replies
  • August 29, 2022

Hi,

 

This is very easily done with the Get Files advanced command. This AC will return to you a list of files which you can then iterate over as required. See screenshots here 🙂

 

I hope this helps!

 

Darren

Translate

  • 118 replies
  • August 29, 2022

Translate

  • 118 replies
  • August 29, 2022

Translate

  • 118 replies
  • August 29, 2022

This variable is an array delimited by the ENTER key, you can use the Get Array Data AC to get the file count

Translate

  • 118 replies
  • August 29, 2022

Translate

  • Author
  • 21 replies
  • August 29, 2022

Thank you, you helped a lot!, I am just learning, I will continue to study the advenced command, I did the same, but forgot to put an asterisk and therefore did not work, what materials for developers can still be viewed?, courses at kryon academy have already passed

Translate

  • 118 replies
  • August 29, 2022

If you're looking to get more familiar with the advanced commands we do have a reference guide available attached to this post. It's a long document, beware! 🙂

Translate

  • Author
  • 21 replies
  • August 29, 2022

Thank you teacher, I'll be careful, I've already passed the first 100 pages

Translate

Great feedback, @darren Cheng​! Additionally, please note that if you are using Kryon RPA (and Kryon Console), you can use the "file" trigger type in the console to trigger a wizard, accordingly. This trigger will "fire" once - and only once! - for every new file that hits the target folder(s). This ensures that a wizard is called (only once) for each new file.

Translate

  • Author
  • 21 replies
  • August 29, 2022

Thanks for the advice Theo)?

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings