API 参考¶
xlwings对象模型
- App
AppApp.activate()App.alert()App.apiApp.booksApp.calculate()App.calculationApp.cut_copy_modeApp.display_alertsApp.enable_eventsApp.hwndApp.interactiveApp.kill()App.macro()App.pathApp.pidApp.properties()App.quit()App.range()App.render_template()App.screen_updatingApp.selectionApp.startup_pathApp.status_barApp.versionApp.visible
- Apps
- Book
- Books
- Characters
- Chart
- Charts
- Font
- Name
- Names
- 注意
- PageSetup
- Picture
- Pictures
- Range
RangeRange.add_hyperlink()Range.addressRange.adjust_indent()Range.apiRange.autofill()Range.autofit()Range.clear()Range.clear_contents()Range.clear_formats()Range.colorRange.columnRange.column_widthRange.columnsRange.copy()Range.copy_from()Range.copy_picture()Range.countRange.current_regionRange.delete()Range.end()Range.expand()Range.formulaRange.formula2Range.formula_arrayRange.get_address()Range.group()Range.has_arrayRange.heightRange.hyperlinkRange.insert()Range.last_cellRange.leftRange.merge()Range.merge_areaRange.merge_cellsRange.nameRange.noteRange.number_formatRange.offset()Range.options()Range.paste()Range.raw_valueRange.resize()Range.rowRange.row_heightRange.rowsRange.select()Range.shapeRange.sheetRange.sizeRange.tableRange.to_pdf()Range.to_png()Range.topRange.ungroup()Range.unmerge()Range.valueRange.widthRange.wrap_text
- RangeColumns
- RangeRows
- Reports
- Shape
- Shapes
- Sheet
SheetSheet.activate()Sheet.apiSheet.autofit()Sheet.bookSheet.cellsSheet.chartsSheet.clear()Sheet.clear_contents()Sheet.clear_formats()Sheet.copy()Sheet.delete()Sheet.freeze_panesSheet.indexSheet.nameSheet.namesSheet.page_setupSheet.picturesSheet.range()Sheet.render_template()Sheet.select()Sheet.shapesSheet.tablesSheet.to_html()Sheet.to_pdf()Sheet.used_rangeSheet.visible
- Sheets
- Table
TableTable.apiTable.data_body_rangeTable.display_nameTable.header_row_rangeTable.insert_row_rangeTable.nameTable.parentTable.rangeTable.resize()Table.show_autofilterTable.show_headersTable.show_table_style_column_stripesTable.show_table_style_first_columnTable.show_table_style_last_columnTable.show_table_style_row_stripesTable.show_totalsTable.table_styleTable.totals_row_rangeTable.update()
- Tables