On 12/13/22 03:13, Matt Lawrence wrote:
Here's the task: I need to take an Excel spreadsheet from Sharepoint, slice & dice it, and write the output into a database
Tools I have: Windows 10 laptop with WSL2 installed and I have admin rights, so I can install whatever.
If I can't read from Sharepoint, then I can manually save a copy locally. Automation would be nice
I am not familiar with Sharepoint, but if you can access it as a web application, you can use Ferrum, which automates Chromium: https://github.com/rubycdp/ferrum Other than that, there are a couple of Sharepoint gems for Ruby (most do it via a REST API as I see): https://rubygems.org/search?query=sharepoint - the first one on that list seems to be the most maintained
If I can't read the Excel spreadsheet, then I can manually open it and write a csv You can use Roo to parse any common spreadsheet format: https://github.com/roo-rb/roo I can use what ever database I want that I can install, sqlite, mysql, mariadb, postgresql or even MongoDB, so not a problem To interface with an SQL database, I recommend Sequel: https://sequel.jeremyevans.net/ I've done lots of slicing & dicing text files in a multitude of languages, I just plan to use Ruby because it's my favorite
It's the first couple of steps that I would like to automate. Any suggestions?
-- Matt