Aim python library master (50) xlwings

[Library description]

You can operate Excel with python while Excel is open You can draw a graph, and you can call python from vba.

[Preparation]

I installed xlwings on virtualenv, but I get an error about win32api I used python27 because it came out.

【program】

xlwings.py


# -*- coding: utf-8 -*-

import xlwings as xw
wb = xw.Workbook()
xw.Range('A1').value = 'Foo 1'
xw.Range('A1').value
# u'Foo 1'

xw.Range('A1').value = [['Foo 1', 'Foo 2', 'Foo 3'], [10.0, 20.0, 30.0]]
xw.Range('A1').table.value
# [[u'Foo 1', u'Foo 2', u'Foo 3'], [10.0, 20.0, 30.0]]

xw.Sheet(1).name
# u'Sheet1'

[Reference site]

Home page  document

Recommended Posts

Aim python library master (50) xlwings
Aim python library master (48) autopep8
Aim python library master (36) json2html
Aim python library master (49) psidialogs
Aim python library master (26) easyxml
Aim python library master (29) table_printer
Aim python library master (55) namespaces
Aim python library master (46) browserplus
Aim python library master (30) chronyk
Aim python library master (3) workalendar
Aim python library master (37) slimurl
Aim python library master (44) pynetviz
Aim python library master (8) rolex
Aim python library master (52) marktime
Aim python library master (7) numparser
Aim python library master (21) hy
Aim python library master (18) requests
Aim python library master (13) easydev
Aim python library master (20) pyyaml
Aim python library master (34) concurrent
Aim python library master (40) wordsegmentation
Aim python library master (43) cpmoptimize
Aim python library master (68) pazudorasolver
Aim python library master (11) nlist
Aim python library master (38) beautiful_print
Aim python library master (65) geopy
Aim python library master (2) vincenty
Aim python library master (59) logbook
Aim python library master (51) pyautogui
Aim python library master (10) timeit
Aim python library master (0) Links
Aim python library master (66) youtube-dl
Aim python library master (53) psutil
Aim python library master (22) htmltag
Aim python library master (67) httpie
Aim python library master (45) xlsxwriter
Aim python library master (9) WebHelpers
Aim python library master (56) colorthief
Aim python library master (61) nested-lookup
Aim python library master (17) rangeparser
Aim python library master (47) deckor
Aim python library master (25) orderedset
Aim python library master (62) glances
Aim python library master (12) excel
Aim python library master (24) combi
Aim python library master (63) easygui
Aim python library master (19) riemann
Aim python library master (39) goless
Aim python library master (54) tqdm
Aim python library master (16) byteplay
Aim python library master (23) memory_utils
Aim python library master (27) benchit
Aim python library master (35) pywildcard
Aim python library master (14) pyknon
Aim python library master (15) brute
Aim python library master (31) adipy
Aim python library master (57) browsergui
Aim python library master (1) da-vinci
Aim python library master (33) human friendly
Aim python library master (4) ASCII Py
Aim python library master (28) verbal expressions