EasyNo. 2194
Cells in a Range on an Excel Sheet — LeetCode 2194 Python Solution
- Pattern
- Hash Map
- Topics
- String
- Reading time
- 2 min
- Source
- leetcode.com
The problem
A cell (r, c) of an excel sheet is represented as a string "<col><row>" where: <col> denotes the column number c of the cell. It is represented by alphabetical letters.
Example
- Input
- s = "K1:L2"
- Output
- ["K1","K2","L1","L2"]
- Explanation
- The above diagram shows the cells which should be present in the list.
Python solution
class Solution:
def cellsInRange(self, s: str) -> List[str]:
return [
chr(i) + str(j)
for i in range(ord(s[0]), ord(s[-2]) + 1)
for j in range(int(s[1]), int(s[-1]) + 1)
]Complexity
- Time
- O(m × n)
- Space · auxiliary
- O(m × n)where m and n are the range of rows and columns, respectively
Pattern: Hash Map
Trade memory for time: remember what you have seen so the second pass never happens. LeetCode 2194. Cells in a Range on an Excel Sheet is filed here because the reference solution below belongs to the algorithm family this hub collects, even though its LeetCode tags point elsewhere.
The hash map guide has the Python template for the pattern and the 709 LeetCode problems that use it.
Related problems
| No. | Problem | Difficulty |
|---|---|---|
| 2185 | Counting Words With a Given Prefix | Easy |
| 0006 | Zigzag Conversion | Medium |
| 0008 | String to Integer (atoi) | Medium |
| 0038 | Count and Say | Medium |
| 0058 | Length of Last Word | Easy |
| 0065 | Valid Number | Hard |
Frequently asked questions
- How hard is LeetCode 2194. Cells in a Range on an Excel Sheet?
LeetCode 2194. Cells in a Range on an Excel Sheet is rated Easy on LeetCode.
- What is the time complexity of LeetCode 2194. Cells in a Range on an Excel Sheet?
The Python solution on this page runs in O(m × n).
- What is the space complexity of LeetCode 2194. Cells in a Range on an Excel Sheet?
The Python solution on this page uses O(m × n), where m and n are the range of rows and columns, respectively auxiliary space.
- What topics does LeetCode 2194. Cells in a Range on an Excel Sheet cover?
LeetCode 2194. Cells in a Range on an Excel Sheet is tagged String on LeetCode.