2 ms·
very cool, here's a pattern i've used in the past for integrating with google sheets using rclone[0] and PowerShell[1]: rclone config # setup a new config
by Natfan 3y ago
very cool, here's a pattern i've used in the past for integrating with google sheets using rclone[0] and PowerShell[1]:
rclone config # setup a new config with the "drive" configuration
rclone copy file.xlsx . # copy the file to local storage
$Data = Import-Excel file.xlsx # using the ImportExcel[2] module, we can read this file as if it were a csv
$MyData = $Data | Where-Object { $_.ColumnName -eq "MyColumn" -and $_.MyOtherColumn -match "\d+" }
[0]: https://rclone.org https://rclone.org
[1]: https://learn.microsoft.com/powershell https://learn.microsoft.com/powershell
[2]: https://github.com/dfinke/ImportExcel https://github.com/dfinke/ImportExcel