How can we change the number format in excel using python.
I’d suggest looking into the bumblebee package which has codes for getting ranges that should be a good reference using the microsoft interop tools library.
If you’re newer to Python or not familiar with using this library it maybe be quite challenging. You’ll get better results if you attempt it and share your code for specific troubleshooting.
1 Like
Thank you.
I find out the solution
worksheet.Range(“C6”).NumberFormat = “# ?/??”