# Összes munkalapnév liolvasása
import openpyxl
workbook = openpyxl.load_workbook(r'c:\Users\kecskemetil\Documents\kl_sj\sj\python_oktatas\minta_py\csv_xls\cell_format.xlsx')
#print ("Workbook lista:", workbook.get_sheet_names()) ### Regi módszer
print ("XLSX munkalap lista:", workbook.sheetnames)
# Munkafuzet kiválasztása
#people = workbook.get_sheet_by_name('People') ### Regi módszer
people = workbook['People']
print ("XLSX munkalap név : ", people)
XLSX munkalap lista: ['Sheet1', 'People'] XLSX munkalap név : <Worksheet "People">
# Munkalap cella érték kiolvasása
import openpyxl
workbook = openpyxl.load_workbook(r'c:\Users\kecskemetil\Documents\kl_sj\sj\python_oktatas\minta_py\csv_xls\cell_format.xlsx')
#people = workbook.get_sheet_by_name('People') ### Regi módszer
people = workbook['People']
print ("Első cella kiolvasása : ", people['A1'])
print ("További cellák olvasása : ", people.cell(row=3, column=2))
print ("Értékek :", people['B2'].value, people['C2'].value)
Első cella kiolvasása : <Cell 'People'.A1> További cellák olvasása : <Cell 'People'.B3> Értékek : Más22 Más32
import xlsxwriter
#Create a workbook and add a worksheet
workbook = xlsxwriter.Workbook('chart_line.xlsx')
worksheet = workbook.add_worksheet()
#Data to be plotted as a chart in worksheet
data = [10, 40, 50, 20, 10, 50]
#Add the data to the columns A1-A6 in worksheet
worksheet.write_column('A1', data)
#Create a line chart object using data from cells A1-A6
chart = workbook.add_chart({'type': 'line'})
chart.add_series({'values': '=Sheet1!$A$1:$A$6'})
#Insert chart in the worksheet
worksheet.insert_chart('C1', chart)
#Close workbook object
workbook.close()
## Munka könyvtár lekérdezése
import os
print(os.getcwd()) ## Munka könyvtár helyének kiíratása
os.chdir(r'c:\Users\kecskemetil\Documents\kl_sj\sj\python_oktatas\minta_py\csv_xls') ## Munka könyvtár beállítása
print(os.getcwd()) ## Munka könyvtár helyének kiíratása
C:\Users\kecskemetil\Documents\kl_sj\sj\python_oktatas\minta\cookbook-code-master\notebooks\chapter01_basic c:\Users\kecskemetil\Documents\kl_sj\sj\python_oktatas\minta_py\csv_xls
import xlsxwriter
import os
print(os.getcwd()) ## Munka könyvtár helyének kiíratása
#Create a workbook and add a worksheet
workbook = xlsxwriter.Workbook('Minta1.xlsx')
worksheet = workbook.add_worksheet()
#Some data that we want to write to the worksheet
expenses = (
['Rent', 1000],
['Gas', 100],
['Food', 300],
['Gym', 50],
)
#Start from the first cell. Rows and columns are zero indexed
row = 0
col = 0
#Iterate over the data and write it out row by row
for item, cost in (expenses):
worksheet.write(row, col, item)
worksheet.write(row, col + 1, cost)
row += 1
#Create a total cell using a formula
worksheet.write(row, 0, 'Total')
worksheet.write(row, 1, '=SUM(B1:B4)')
workbook.close()
#Add a new sheet to the workbook
import xlsxwriter
workbook = xlsxwriter.Workbook('Minta2.xlsx')
worksheet = workbook.add_worksheet(name='Uj munkalap')
#Close workbook object
workbook.close()
c:\Users\kecskemetil\Documents\kl_sj\sj\python_oktatas\minta_py\csv_xls
## xls csv file olvasása
import pandas as pd
file = r'c:\Users\kecskemetil\Documents\kl\munka\feladatok_kl.xlsx'
xl = pd.ExcelFile(file) ## excel megnyítása
print(xl.sheet_names) ## munkalapok neveinek kiírása
df1 = xl.parse('kesz') ## xls tartalmának dataframe-be töltése
##------------
df = pd.read_csv(r"c:\Users\kecskemetil\Documents\kl\munka\feladatok_kl_ki.csv") ## csv file megnyítása
print('kész')
['folyamatban', 'kesz'] kész
## xls csv file írása Pandas-al
# pip install XlsxWriter
import pandas as pd
writer = pd.ExcelWriter(r'c:\Users\kecskemetil\Documents\kl\munka\feladatok_kl_ki.xlsx', engine='xlsxwriter')
df1.to_excel(writer, 'Sheet1') ## DataFrame munkalapra írása
writer.save() ## változások mentése
##------------
df1.to_csv(r"c:\Users\kecskemetil\Documents\kl\munka\feladatok_kl_ki.csv")
print('kész')
kész
import xlwt
def output(filename, sheet, list1, list2, x, y, z):
book = xlwt.Workbook()
sh = book.add_sheet(sheet)
variables = [x, y, z]
x_desc = 'Display'
y_desc = 'Dominance'
z_desc = 'Test'
desc = [x_desc, y_desc, z_desc]
col1_name = 'Stimulus Time'
col2_name = 'Reaction Time'
for n, v_desc, v in enumerate(zip(desc, variables)):
sh.write(n, 0, v_desc)
sh.write(n, 1, v)
n+=1
sh.write(n, 0, col1_name)
sh.write(n, 1, col2_name)
for m, e1 in enumerate(list1, n+1):
sh.write(m, 0, e1)
for m, e2 in enumerate(list2, n+1):
sh.write(m, 1, e2)
book.save(filename)
print('kész')
kész
import xlsxwriter
# Create an new Excel file and add a worksheet.
workbook = xlsxwriter.Workbook('demo.xlsx')
worksheet = workbook.add_worksheet()
# Widen the first column to make the text clearer.
worksheet.set_column('A:A', 20)
# Add a bold format to use to highlight cells.
bold = workbook.add_format({'bold': True})
# Write some simple text.
worksheet.write('A1', 'Hello')
# Text with formatting.
worksheet.write('A2', 'World', bold)
# Write some numbers, with row/column notation.
worksheet.write(2, 0, 123)
worksheet.write(3, 0, 123.456)
# Insert an image.
worksheet.insert_image('B5', r'c:\Users\kecskemetil\Pictures\letöltés.png')
workbook.close()
print('kész')
kész