.rst .pdf

2. Processing a Single Worksheet

While Excel workbooks can contain multiple worksheets, sometimes you only need data from one of the worksheets. In addition, once you know how to parse one worksheet, it is a simple extension to parse multiple worksheets.

• 2.1. Read and Write an Excel File
  • 2.1.1. Format dates
• 2.2. Filter for Specific Rows
  • 2.2.1. VALUE IN ROW MEETS A CONDITION
  • 2.2.2. VALUE IN ROW IS IN A SET OF INTEREST
  • 2.2.3. VALUE IN ROW MATCHES A SPECIFIC PATTERN

上一页

1.2. Introspecting an Excel Workbook

下一页

2.1. Read and Write an Excel File