Archaeological investigations on the site of a new renewable energy generation and storage project in South Yorkshire have been completed.