DEV Community

ryjfgjl
ryjfgjl

Posted on

Synchronize and refresh Excel data to the database in real time

Earlier, we talked about Importing Excel to Database at a Fixed Time. We only need to make a slight modification to achieve real-time refresh.
Add a new scheduled task, and keep the default setting for timing, which means running in real time

Image description

You can see the task running in the scheduled task interface. When the Excel data is updated, click Save and you can immediately see the updated data in the database.

Image description

Because the refresh frequency is fast and needs to be continuously run, it consumes certain system resources. We can determine whether to execute the import by detecting whether the Excel file has been updated. If the file has not been updated, the execution can be skipped.

Image description

Introduction and Download of ExcelToDatabase

Top comments (0)