jagomart
digital resources
picture1_Python Pdf 185839 | Work With Excel


 148x       Filetype PDF       File size 0.07 MB       Source: labdeck.com


File: Python Pdf 185839 | Work With Excel
www labdeck com python work with spreadsheets level basic in this example we illustrate how python can be used within matdeck to work with spreadsheets which includes microsoft excel files ...

icon picture PDF Filetype PDF | Posted on 01 Feb 2023 | 2 years ago
Partial capture of text on file.
                            www.labdeck.com
   Python - Work with Spreadsheets
       Level: Basic
   In this example, we illustrate how Python can be used within MatDeck to work with spreadsheets, which
   includes Microsoft Excel files (various versions and formats), Open Office / Libre Office Calc, and CSV. In
   order to work with spreadsheets, it is necessary to install openpyxl library. The easiest way to install is to
   use following command in command prompt: pip install openpyxl
   Create an Excel file from scratch 
   The task is to create Excel file with given file name, and to write date and time at cell A2. 
    Input : File name as string
    Output : File 
        f ile_name: = "first.xlsx"
   Code
    1  #py
    2  import openpyxl
    3  import datetime
    4
    5  wb = openpyxl.Workbook()
    6  ws = wb.active
    7  ws['A1'] = "Date and Time"
    8  ws['A2'] = datetime.datetime.now()
    9  wb.save(file_name)
    10 ###
   Add expressions to Excel
   The task is to write data into given cells, and to add expression which determines value of the third cell. 
       Variable1: = 13
       Variable2: = 25
       f ile_namee: = "expression.xlsx"
    11 #py
    12 import openpyxl
    13 wb = openpyxl.Workbook()
    14 ws = wb.active
    15 ws['A1'] = Variable2
    16 ws['A2'] = Variable1
    17 ws['A3'] = "=A1+A2"
    18 wb.save(file_namee)
    19 ###
   Number series and chart
   The following Python code defines number series which are written in Excel file. After that, Excel chart is
   defined as two line chart. 
    20 #py
    21 import openpyxl
    22 wb = openpyxl.Workbook()
    23 ws = wb.active
    24 ws.title = "Chart"
    25
    26 a = ["First", 20, 28, 30, 37, 18, 47]
    27 b = ["Second", 35, 30, 40, 40, 38, 35]
    28
    29 # write series as columns
    30 for i in range(len(a)):
    31     ws.cell(row=i+1, column=1).value = a[i]
    32     ws.cell(row=i+1, column=2).value = b[i]
    33 lc = openpyxl.chart.LineChart() 
    34 lc.title = "Two Lines Chart"
    35  
    36 data = openpyxl.chart.Reference(ws,
    37 min_col=1,
    38 min_row=1,
    39 max_col=2,
    40 max_row=len(a))
    41 lc.add_data(data, titles_from_data=True)
    42
    43 ws.add_chart(lc, "D1")
    44 wb.save("chart.xlsx")
    45 ###
   Read Excel File
   Next code chunk illustrates how Excel file can be read using Python code directly form MatDeck
    46 #py
    47 import openpyxl
    48 wb = openpyxl.load_workbook(filename = 'chart.xlsx')
    49 for ws in wb.worksheets:
    50     print(ws.title)
    51 ws = wb.worksheets[0]
    52 print(ws['A1'].value)
    53 ###
The words contained in this file might help you see if this file matches what you are looking for:

...Www labdeck com python work with spreadsheets level basic in this example we illustrate how can be used within matdeck to which includes microsoft excel files various versions and formats open office libre calc csv order it is necessary install openpyxl library the easiest way use following command prompt pip create an file from scratch task given name write date time at cell a input as string output f ile first xlsx code py import datetime wb workbook ws active now save add expressions data into cells expression determines value of third variable namee number series chart defines are written after that defined two line title b columns for i range len row column lc linechart lines reference min col max titles true d read next chunk illustrates using directly form load filename worksheets print...

no reviews yet
Please Login to review.