Hi,
Since the Python for Excel is a simple version, there will be a lot of limitations in the features.
This is a new feature in Excel, there will definitely be shortcomings and it is recommended that if you have any feedback or suggestion about this behavior, you can try to give feedback to Microsoft about your requirement:
Microsoft values your opinion. Your feedback goes directly to our engineers and helps us shape the future of Microsoft products and services for all our users.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.