{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Transport","ZIP","Wykład 1","Programowanie","Makro","Typy danych","Arkusz8","Arkusz1","Arkusz2","Arkusz3"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Transport","index":0,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"Informatyka"]

{"sheet":"ZIP","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"Podstawy informatyki"]
[null,"i algorytmizacji"]

{"sheet":"Wykład 1","index":2,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"WYKŁAD 1"]
[]
[null,"Makropolecenia (Makra) w programie EXCEL."]

{"sheet":"Programowanie","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Makro","index":4,"n_rows":62,"n_cols":5,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Makropolecenie (makro) jest ciągiem instrukcji pozwalających "]
[null,"na automatyczne wykonywanie pewnych czynności w programie EXCEL."]
[]
[]
[null,"Makra w EXCELu można tworzyć dwoma sposobami:"]
[null,"- poprzez nagrywanie"]
[null,null,"Karta Deweloper -> Zarejestruj makro"]
[null,"- poprzez wypisanie instrukcji w języku skryptowym o nazwie VBA"]
[null,"    (z ang. Visual Basic for Aplications)"]
[]
[null,null,"Sub <nazwa makra>"]
[null,null,"<instrukcja 1>"]
[null,null,"<instrukcja 2>"]
[null,null,"<instrukcja 3>"]
[null,null,":"]
[null,null,":"]
[null,null,":"]
[null,null,":",null," "]
[null,null,"<instrukcja n>"]
[null,null,"End Sub"]
[]
[]
[null,"Wstążka Deweloper -> Edytor Visual Basic"]
[]
[null,"Insert -> Module",null,null,"Pierwsze makro"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"UWAGA: makra zapisywane są w pliku EXCELA z rozszerzeniem *.xlsm (w starszych wersjach z rozsezrzeniem *.xls)"]

{"sheet":"Typy danych","index":5,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Dane na których operują makra mogą być zapisane:"]
[null,"1) w komórkach arkusza kalkulacyjnego,"]
[null,"2) w wewnętrznej pamięci VBA jako stałe i zmienne"]
[]
[null,"Ad.1"]
[]
[null,"Range[„A1”]  lub krócej [A1] oznacza komórkę A1 arkusza"]
[null,"Range[„B1:D3”]  lub krócej [A1:D3] oznacza zakres A1:D3 arkusza kalkulacyjnego"]
[null,"ActiveCell oznacza wybraną (aktywną) komórkę arkusza"]
[null,"Selection oznacza wybrany (zaznaczony) zakres arkusza"]
[]
[null,"Ad. 2"]

{"sheet":"Arkusz8","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Arkusz1","index":7,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[1,5,-10,65]
[null,null,null,1.5311288741492746,-6.5311288741492746]

{"sheet":"Arkusz2","index":8,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Drugie makro",-1.6666666666666667,-1.6666666666666667,"w. dodatnia lub zero"]
[null,"abc","abc",null,null,"Ala",null,"Ala"]
[null,null,null,null,null,null,null,null,"Ala ma kota"]
[null,null,null,null,null,null,null,null,null,null,"Ala ma kota"]
[null,null,null,"Ala"]
[]
[null,null,null,null,null,null,"Ala ma kota"]
[null,"Ala ma kota"]
[]
[]
[]
[2]
[3]
[-4]
[5]
[0]

{"sheet":"Arkusz3","index":9,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Ala"]
[]
[null,null,null,null,null,"Ala ma kota",null,null,"Ala"]
[]
[null,null,null,null,"Ala",null,null,null,null,"Ala ma kota"]
[]
[null,null,null,null,null,null,"Ala"]
[null,null,null,"Ala",null,null,null,null,"Ala ma kota"]
[]
[]
[]
[]
[null,null,null,null,null,null,"wykład 6"]
[null,null,null,"wykład 6"]