Kopia danych na serwer i aktualizacja w Excelu (EasyPrinter)
Streszczenie: Automatyczna aktualizacja pliku Excel z kopii danych wysyłanych przez HMI na serwer: w EasyPrinter włączenie konwersji kopii do CSV, import CSV do Excela i ustawienie automatycznego odświeżania.
EN: How to keep an Excel file updated from HMI data backups sent to a server via EasyPrinter (CSV conversion and auto refresh).
Dotyczy: EasyPrinter, EasyBuilder Pro (obiekt Backup)
Źródło: Weintek FAQ (materiały producenta), oryginalny tytuł: „How to Backup Data to Server and Update in Excel?”
To update data backup in remote backup server to an Excel file, please follow the steps below.
For details of Backup object settings in EasyPrinter and EasyBuilder, see Chapter 26 EasyPrinter and Chapter 13.24 Backup.
Step 1. In EasyPrinter, under Convert Batch File select [Enable] check box. This enables converting file backup into Excel file.
This enables converting file backup into Excel file.
Step 2. When backup file to server, a .csv file is generated.
Step 3. Create a new Excel file.
Step 4. Open the created Excel file, import the content in the .csv file by clicking [Data] \ [Get External Data] \ [From Text].
Step 5. During import, select [Comma] to be the delimiters
Step 6. When finished, the content in the .csv file can be viewed in Excel. Click [Data] and set [Properties].
Step 7. Set the time interval to refresh the Excel file, and select [Refresh data when opening the file].
Step 8. In this way, when backup file to server, the generated .csv file is automatically imported to Excel, therefore users can always view the updated data when opening the Excel fil
Słowa kluczowe
kopia danych, backup, serwer kopii, EasyPrinter, Convert Batch File, CSV, Excel, odświeżanie danych, Get External Data, obiekt Backup, How to Backup Data to Server and Update in Excel?



![Ilustracja: Kopia danych na serwer i aktualizacja w Excelu (EasyPrinter) – Open the created Excel file, import the content in the .csv file by clicking [Data] \ [Get External Data] \ [From Text].](https://n8n.multiprojekt.pl/bookstack/uploads/images/gallery/2026-07/scaled-1680-/oniimage.png)
![Ilustracja: Kopia danych na serwer i aktualizacja w Excelu (EasyPrinter) – During import, select [Comma] to be the delimiters](https://n8n.multiprojekt.pl/bookstack/uploads/images/gallery/2026-07/scaled-1680-/4mpimage.png)
![Ilustracja: Kopia danych na serwer i aktualizacja w Excelu (EasyPrinter) – Click [Data] and set [Properties].](https://n8n.multiprojekt.pl/bookstack/uploads/images/gallery/2026-07/scaled-1680-/3mcimage.png)
![Ilustracja: Kopia danych na serwer i aktualizacja w Excelu (EasyPrinter) – Set the time interval to refresh the Excel file, and select [Refresh data when opening the file].](https://n8n.multiprojekt.pl/bookstack/uploads/images/gallery/2026-07/scaled-1680-/Q1Eimage.png)

No comments to display
No comments to display