Menu
I am opening a workbook in openpyxl thus:
wb = load_workbook(r'seven.xlsx', data_only=True)
The name of the spreadsheet won't always be know in advance, so I need to rewrite this hardcoding to allow for a variable, while still maintaining the r?
If my variable name is sheet, then:
wb = load_workbook(sheet, data_only=True)
will omit the r.
And obviously I cannot do:
wb = load_workbook(r'sheet', data_only=True)
How do we achieve the prepending of r to a variable / how do we wrap a vriable within r''?
373
Python raw string is created by prefixing a string literal with 'r' or 'R'. Python raw string treats backslash (\) as a literal character. This is useful when we want to have a string that contains backslash and don't want it to be treated as an escape character.
In Python strings, the backslash "\" is a special character, also called the "escape" character. It is used in representing certain whitespace characters: "\t" is a tab, "\n" is a newline, and "\r" is a carriage return. Conversely, prefixing a special character with "\" turns it into an ordinary character.
To create a raw string in Python, you place an r befor the beginning quotation mark of the string. A raw string completely ignores all escape characters. It prints the string exactly as entered.
A string literal can be created by writing a text(a group of Characters ) surrounded by the single(”), double(“”), or triple quotes. By using triple quotes we can write multi-line strings or display in the desired way.
I did not understand really what you were trying to do, but if you have a string and you want to create a raw text there are two main methods I know of:raw_text = [str_text]
and str_text = "%r"%str_textraw_text = str_text[1:-1].
132
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
