Forum Discussion
Issues with basic excel python
Hello, I am trying to get values from the C column in the worksheet A2025. I am not even sure the xl("A2025") is getting anything. when i just do df_2025 = xl("A2025", headers=False) I get back...
The correct syntax to get data from column C of that worksheet is:
df_2025 = xl("'A2025'!C.:.C", headers=False)Note the .:. (instead of the usual : ) it tells Excel that you only want the area which contains data.
Thanks, if I may ask a followup.
Once you get a dataframe with your final data,
How can I write it out in an excel column. In the below I get the snipit of data.
How could I print the values in the G column. one value per row.
thanks