Чтобы выбрать несколько ячеек в строке или столбце с помощью библиотеки win32comв Excel, вы можете использовать разные методы. Вот несколько примеров:

Метод 1: использование объекта Range

import win32com.client as win32
# Create an Excel application object
excel = win32.gencache.EnsureDispatch('Excel.Application')
# Open the workbook
workbook = excel.Workbooks.Open(r'C:\path\to\your\workbook.xlsx')
# Select multiple cells in a row
row_range = excel.Range('A1:C1')
row_range.Select()
# Select multiple cells in a column
column_range = excel.Range('A1:A3')
column_range.Select()
# Close the workbook
workbook.Close()
# Quit Excel
excel.Quit()

Метод 2: использование свойства Cells

import win32com.client as win32
# Create an Excel application object
excel = win32.gencache.EnsureDispatch('Excel.Application')
# Open the workbook
workbook = excel.Workbooks.Open(r'C:\path\to\your\workbook.xlsx')
# Get the active sheet
sheet = workbook.ActiveSheet
# Select multiple cells in a row
row_range = sheet.Range(sheet.Cells(1, 1), sheet.Cells(1, 3))
row_range.Select()
# Select multiple cells in a column
column_range = sheet.Range(sheet.Cells(1, 1), sheet.Cells(3, 1))
column_range.Select()
# Close the workbook
workbook.Close()
# Quit Excel
excel.Quit()

Способ 3: использование свойства Rowsили Columns

import win32com.client as win32
# Create an Excel application object
excel = win32.gencache.EnsureDispatch('Excel.Application')
# Open the workbook
workbook = excel.Workbooks.Open(r'C:\path\to\your\workbook.xlsx')
# Get the active sheet
sheet = workbook.ActiveSheet
# Select multiple cells in a row
row_range = sheet.Rows(1).Range('A1:C1')
row_range.Select()
# Select multiple cells in a column
column_range = sheet.Columns(1).Range('A1:A3')
column_range.Select()
# Close the workbook
workbook.Close()
# Quit Excel
excel.Quit()