automating excel sheet updates from website data
-
I am fairly new to coding..well completely new. I do have a basic understanding of VBA and am currently learning Python. My goal is to write something that can access my company's website and automatically update an excel file we use for production purchase orders. Currently we need to go into each purchase order manually and update it which takes over an hour a day. There has to be a way to automate this process. Is there a language I can learn that will be able to accomplish this for me?
-
I am fairly new to coding..well completely new. I do have a basic understanding of VBA and am currently learning Python. My goal is to write something that can access my company's website and automatically update an excel file we use for production purchase orders. Currently we need to go into each purchase order manually and update it which takes over an hour a day. There has to be a way to automate this process. Is there a language I can learn that will be able to accomplish this for me?
contempomania
-
I am fairly new to coding..well completely new. I do have a basic understanding of VBA and am currently learning Python. My goal is to write something that can access my company's website and automatically update an excel file we use for production purchase orders. Currently we need to go into each purchase order manually and update it which takes over an hour a day. There has to be a way to automate this process. Is there a language I can learn that will be able to accomplish this for me?
Pretty much any language can accomplish this goal. The only real variation is going to be level of difficulty. Though, I'd find an on-topic forum / Q&A and tag the message, if you want answers. It might go largely unnoticed here. I'd start by better defining your requirements. Does the web site expose a web service? Or, will you need to scrape a web page for the data? Will you be updating an actual Excel file? Or, can you use something simpler like CSV? If directly updating an Excel file, I'd probably gravitate towards C#.
-
Pretty much any language can accomplish this goal. The only real variation is going to be level of difficulty. Though, I'd find an on-topic forum / Q&A and tag the message, if you want answers. It might go largely unnoticed here. I'd start by better defining your requirements. Does the web site expose a web service? Or, will you need to scrape a web page for the data? Will you be updating an actual Excel file? Or, can you use something simpler like CSV? If directly updating an Excel file, I'd probably gravitate towards C#.
-
Pretty much any language can accomplish this goal. The only real variation is going to be level of difficulty. Though, I'd find an on-topic forum / Q&A and tag the message, if you want answers. It might go largely unnoticed here. I'd start by better defining your requirements. Does the web site expose a web service? Or, will you need to scrape a web page for the data? Will you be updating an actual Excel file? Or, can you use something simpler like CSV? If directly updating an Excel file, I'd probably gravitate towards C#.
Fine information,
many thanks to the author. It is puzzling to me now, but in general, the usefulness and importance is overwhelming. Very much thanks again and best of luck!