Excel automation

Asked

Viewed 41 times

1

I need some way to automate a recurring work in my company: I automatically want to take tables generated in Excel, extract information from it is write in a new table. Since new tables will always be generated to do these calculations, then periodically my program would need to perform this task. I want to find out how best to learn to do this and to get a quick result. What technologies are available.

  • Do you have knowledge of any programming language?

  • I have in Java and C

  • Here is a question I made at one time regarding the subject: https://answall.com/questions/154017/editar-um-arquivo-xls-j%C3%a1-created

  • If the company is financially available, I strongly suggest Alteryx https://www.altery.com/

  • I’ll take a look, R.Santos Leonardo, I’ll take a look at Alteryx and see if it’s worth it, but right now we’re prioritizing solutions at no financial cost. Thank you guys.

  • Why not use VBA?

  • Evert, I didn’t know the VBA. As my need was to search in a folder files with a given name, to generate others, I thought I could only solve with codes and executables. It is not something that would be restricted to a table.

Show 2 more comments

1 answer

0

I tried using Openpyxl, a python library. But it took me a long time, because I have to learn python and use the library at the same time.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.