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.
one more item.
How can you print the values in a column in Excel?
The dataframe will only produce a snipit of the dataframe.
Is there a way to actually have the df data print in a specific column of excel?
Change output mode on Excel value
which gives
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
