Summary  
This chapter introduces the use of context managers via the `with` statement to handle resource setup and teardown automatically in code.

General domain of usage  
File handling

Workbook

import unittest
import json


class TestTask(unittest.TestCase):
    @classmethod
    def setUpClass(cls):
        with open("payload.json") as f:
            data = json.load(f)
        cls.sheet = next(iter(data["sheets"].values()))

    def _cell(self, row, col):
        return (
            self.sheet.get("cellData", {})
            .get(str(row), {})
            .get(str(col))
        )

    def test_c1_formula(self):
        cell = self._cell(0, 2)
        self.assertIsNotNone(
            cell, "Cell C1 must contain formula =A1+B1 or value 300"
        )
        self.assertTrue(
            cell.get("f") == "=A1+B1" or cell.get("v") == 300,
            "Cell C1 must contain formula =A1+B1 or value 300",
        )

    def test_b2_value(self):
        cell = self._cell(1, 1)
        self.assertIsNotNone(cell, "Cell B2 must have value 75")
        self.assertEqual(cell.get("v"), 75, "Cell B2 must have value 75")

    def test_c2_formula(self):
        cell = self._cell(1, 2)
        self.assertIsNotNone(
            cell, "Cell C2 must contain formula =A2+B2 or value 125"
        )
        self.assertTrue(
            cell.get("f") == "=A2+B2" or cell.get("v") == 125,
            "Cell C2 must contain formula =A2+B2 or value 125",
        )


if __name__ == "__main__":
    unittest.main()

test_main.py

Unlock the power of Excel for data analysis! In this course, you will acquire the essential skills and knowledge needed to harness Excel's full potential as a data analysis tool. From mastering formulas and functions to visualizing data with charts and graphs, you'll gain the expertise to confidently navigate Excel's features. Whether you're a beginner or looking to enhance your existing Excel skills, this course will equip you with the tools to excel in data analysis. Join us and take your data manipulation and interpretation abilities to the next level.

Begin your Excel journey by learning essential basics: navigating the interface, entering data, and understanding Excel's basics.

Master the art of formulas in Excel, from simple calculations to advanced data manipulation techniques for efficient analysis.

Explore Excel's powerful functions! Learn Logical, Mathematical, and Statistical functions to boost your data analysis skills.

Learn to transform data into insightful visuals. Explore chart creation and formatting to effectively communicate your findings and enhance data-driven decision-making.

Efficiently manage and organize data within Excel. Discover techniques for data sorting, filtering, and handling large datasets with ease.

Dive deep into Excel's advanced capabilities. Explore topics such as pivot tables, macros, and data analysis tools to elevate your Excel proficiency.

with task1

Solution