This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$RemoteFile = "https://adres_strony/nazwa_pliku_do_pobrania.xml" | |
# Dane do FTP | |
$Username = "login_do_ftp" | |
$Password = "haslo_do_ftp" | |
$UploadFile = "ftp://adres_serwera_ftp/nazwa_pliku_na_serwerze.xml" | |
# Tymczasowe pliki | |
$LocalFile = "file.xml" | |
$ChangedLocalFile = "file_changed.xml" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* To use this script You must also add difflib module. | |
* https://github.com/qiao/difflib.js | |
* Add to project as difflib.gs minified version: | |
* https://raw.githubusercontent.com/qiao/difflib.js/master/dist/difflib-browser.js | |
*/ | |
function onOpen() { | |
SpreadsheetApp.getUi().createAddonMenu() | |
.addItem('Copy to new sheet', 'findSimilar') |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function onEdit(e){ | |
var sheet = e.source.getActiveSheet(); | |
var editedCell = sheet.getActiveCell(); | |
// w tym przykładzie monitorujemy 6 kolumnę | |
if(editedCell.getColumn() == 6){ | |
editedCell.setNote('Last modified: ' + new Date()); | |
} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Dodaje nową pozycję do menu | |
function onOpen() { | |
SpreadsheetApp.getUi().createAddonMenu() | |
.addItem('Copy to new sheet', 'copyUniques') | |
.addToUi(); | |
} | |
// Funkcja pomocnicza porównująca 2 wartości | |
function isUnique(left, right) { | |
return left == right |