Python Excel Automation: read_excel and to_excel

[@nick-oi1xf]

I really enjoy your style of teaching. Thank you!😊

[@thefriendlycoder_]

Thank you so much!!

[@jinit8083]

Thank you a thousand times for such easy to follow content and instructions. I’m learning to code and my old brain needs simple instructions. Your video helped me easily import data. Looking forward to seeing more videos/content from your channel. Worth the subscription 😊

[@thefriendlycoder_]

This makes me so happy! thank you 😊

[@marioorozco3442]

Hi Laura! Thanks for sharing

[@thefriendlycoder_]

You are so welcome!

[@cdisla98]

Seriously so helpful! Thank you!

[@thefriendlycoder_]

Thank you!! ❤

[@mariachica6913]

Very interesting, thank you!

[@thefriendlycoder_]

Thank you!

[@work-routine]

Great explanation style, thanks for your work!

[@thefriendlycoder_]

Thanks!!

[@johnericangat1016]

So informative!

[@thefriendlycoder_]

Thank you!!

[@luisagonzalez4102]

I really needed this, thank you!

[@thefriendlycoder_]

Thank you!! ✨

[@miladghalehnoei8300]

thank you🙏🙏🙏

[@thefriendlycoder_]

Thanks for watching!

[@AzNFiR]

Awesome job

[@thefriendlycoder_]

Thank you!!

[@ja1686]

Keep it up👍

[@thefriendlycoder_]

Thank you!!!

[@macrefinerymartinez1430]

How do you read values from a spreadsheet that has formulas using read_excel?

[@thefriendlycoder_]

Hi! When using read_excel, the dataframe will contain the computed values of the formulas, not the actual formulas themselves. You may want to use another library such as openpyxl instead for this

[@macrefinerymartinez1430]

Thanks. I import data from a company report and I will so,eimes run into NaN one the files is read. I will try again. I am glad you are back posting videos. @@thefriendlycoder_

[@macrefinerymartinez1430]

TNote: The company report has cells that are calculated by formulas. That is where I sometimes get the NaN instead of the value.

[@yesyogi]

Hi.. Are you planning to upload more tutorials on this topic here on youtube or on any blog ?

[@thefriendlycoder_]

I plan on posting more videos! ☺️

[@enricomendiola9952]

Hello, I have a question. When exporting datafrom to excel . You did not specify the path on the filename. How did you know that it is under the Onedrive subdirectory?

[@FaizanScribe]

How can I get in touch with you ? I have a question thats too long to post here.

[@marioorozco3442]

Sorry Laura, I forgot to ask if you’re on IG or would this be the best method to ask you for help or follow questions. Many thanks

[@thefriendlycoder_]

I actually don’t have an instagram but if I do in the future I’ll link it

[@marioorozco3442]

@@thefriendlycoder_ hi there again… I’m really trying to learn more coding… do you teach etc or just through UA-cam? You teach so well that is easy to follow.