xlwings オブジェクト別メソッド一覧 pythonからエクセル操作はこれで簡単

メソッドの目的・効果が、【取得】か【設定/実行】かは目安です

コーディングの際は本家レファレンスで確認を怠り無く

オブジェクト モデル
オブジェクトメソッド取得設定
実行
パラメータ
Apps
classxlwings.main.Apps(impl)
add()
count
keys()
App
classxlwings.App(visible=None, spec=None, add_book=True, impl=None)
activate()steal_focus=False
api
books
calculate()
calculation
display_alerts
hwnd
kill()
macro(name)
pid
quit()
range()cell1, cell2=None
screen_updating
selection
startup_path
status_bar
version
visible
Books
active
add()
open()fullname, update_links=None, read_only=None, format=None, password=None, write_res_password=None, ignore_read_only_recommended=None, origin=None, delimiter=None, editable=None, notify=None, converter=None, add_to_mru=None, local=None, corrupt_load=None
Book
activate()steal_focus=False
api
app
classmethodcaller()
close()
fullname
name
names
save(path=None)
selection
set_mock_caller()
sheets
to_pdf()path=None, include=None, exclude=None
Sheets
active
add()name=None, before=None, after=None
Sheet
activate()
api
autofit(axis=None)
book
cells
charts
clear()
clear_contents()
copy()before=None, after=None, name=None
delete()
index
name
names
pictures
range()cell1, cell2=None
render_template()**data
select()
shapes
tables
to_pdf()path=None
used_range
visible
Range
add_hyperlinkaddress, text_to_display=None, screen_tip=None
address
api
autofit()
clear()
clear_contents()
color
column
column_width
columns
copy(destination=None)
count
current_region
delete(shift=None)
end(direction)
expand(mode=’table’)
formula
formula2
formula_array
get_address()row_absolute=True, column_absolute=True, include_sheetname=False, external=False
has_array
height
hyperlink
insert()shift=None, copy_origin=’format_from_left_or_above’
last_cell
left
merge()across=False
merge_area
merge_cells
name
number_format
offset()row_offset=0, column_offset=0
options()convert=None, **options
paste()paste=None, operation=None, skip_blanks=False, transpose=False
raw_value
resize()row_size=None, column_size=None
row
row_height
rows
select()
shape
sheet
size
table
top
unmerge()
value
width
wrap_text
RangeRows
autofit()
count
RangeColumns
autofit()
count
Shapes
api
count
Shape
activate()
api
delete()
height
left
name
parent
scale_height()factor, relative_to_original_size=False, scale=’scale_from_top_left’
scale_width()factor, relative_to_original_size=False, scale=’scale_from_top_left’
text
top
type
width
Charts
add()left=0, top=0, width=355, height=211
api
count
Chart
api
chart_type
delete()
height
left
name
parent
set_source_data()source
top
width
Pictures
add()image, link_to_file=False, save_with_document=True, left=0, top=0, width=None, height=None, name=None, update=False, scale=1
api
count
Picture
api
delete()
height
left
name
parent
top
update()image
width
Names
add(name, refers_to)
api
count
Name
api
delete()
name
refers_to
refers_to_range
Tables
add()source=None, name=None, source_type=None, link_source=None, has_headers=True, destination=None, table_style_name=’TableStyleMedium2′
Table
api
data_body_range
display_name
header_row_range
insert_row_range
name
parent
range
show_autofilter
show_headers
show_table_style_column_stripes
show_table_style_first_column
show_table_style_last_column
show_table_style_row_stripes
show_totals
table_style
totals_row_range
Font
api
bold
color
italic
name
size
Characters
api
font
text
Markdown
MarkdownStyle

コメント

amazon 本日のタイムセール Time Sale
現役シリコンバレーエンジニアが教えるPython 3 入門 + 応用 動画290本28.5時間 \24,000
楽天モバイル、妻がiphone SE2、息子がiphone11で使ってます。一番安くて通信品質イマイチ
コロナ感染施設の人体に無害な消毒と抗菌処理ならESS消毒社(東京都)
タイトルとURLをコピーしました