KekLib.ExcelCOM#
ExcelCOM.py - a minimal Python wrapper for Excel ole object
Copyright (c) 2016-2025, Masatsuyo Takahashi, KEK-PF
- CellAddr(cell, absref='$$')#
- CoInitialize()#
- CoUninitialize()#
- ColAddr(col)#
- class ExcelComClient(new_instance=True, excel_id=None, keep_remaining=False, visible=False, display_alerts=False)#
Bases:
object- create_thread(target, args=[], kwargs={}, name='ExcelComClientThread')#
- get_comid()#
- get_pid()#
- get_thread_count()#
- get_thread_mode()#
- get_version()#
- merge_books(input_books, merged_book, progress_cb=None, merged_cb=None, delete_target=None, default_font=None)#
- openWorkbook(path, save=True)#
- openWorksheet(path)#
- quit()#
- selection()#
- RGB(hex_color_str)#
- class Workbook_(excel_client, path, save=True)#
Bases:
object
- class Worksheet(excel_client, path)#
Bases:
object- draw_line(p1, p2)#
- draw_oval(p, a, b, color=None)#
- draw_right_brace(p, width, hight, rotation)#
Function AddShape(Type As MsoAutoShapeType, Left As Single, Top As Single, Width As Single, Height As Single) As Shape
- draw_textbox(text, p, width, hight, visible=True)#
- freeze_panes(range_, scroll_column=None)#
- get_chart(i, debug=False)#
- get_chart_data_point(chart, i, j)#
- get_num_charts()#
- zoom(percentage)#
- cleanup_created_excels()#
- compute_axis_max_value(max_value, num_labels=5)#
- excel_availability(debug=False)#
Note that this test may require rebooting after changing the Excel abailability.
- merge_into_a_book(input_books, merged_book, excel_client=None, progress_cb=None, delete_target=None, default_font=None)#