Earlier, we have talked about the scheduled import of Excel to the database. We only need to make a slight modification to achieve real-time refresh.
Add a scheduled task, keep the default timing settings, which means real-time operation
You can see that the task is running continuously in the scheduled task interface. When the Excel data is updated, click Save, and you can immediately see the updated data in the database
Because the real-time operation refreshes very quickly, it needs to run continuously, which will consume certain system resources. We can decide whether to execute the import by detecting whether the Excel file has been updated. If the file has not been updated, the current execution can be skipped.
Top comments (0)