{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["1808721"],"not_rendered":{"charts":0,"images":0,"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":"1808721","index":0,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["FileName","NewFileName","Arhiv Name"]
["D:\\тест\\1.csv",{"$f":"LEFTB(A2,LEN(A2)-LEN(E2))&$J$2&TEXT(D2,\"000\")&\".txt\"","v":"D:\\тест\\92016111001.txt"},{"$f":"LEFTB(A2,LEN(A2)-LEN(E2))&$J$2&TEXT(D2,\"000\")&$K$2","v":"D:\\тест\\92016111001.txt.zip"},{"$f":"TRIM(LEFT(SUBSTITUTE(E2,\".\",REPT(\" \",99)),99))","v":"1"},{"$f":"TRIM(RIGHT(SUBSTITUTE(A2,\"\\\",REPT(\" \",99)),99))","v":"1.csv"},null,null,null,null,92016111,".txt.zip"]
["D:\\тест\\2.csv",{"$f":"LEFTB(A3,LEN(A3)-LEN(E3))&$J$2&TEXT(D3,\"000\")&\".txt\"","v":"D:\\тест\\92016111002.txt"},{"$f":"LEFTB(A3,LEN(A3)-LEN(E3))&$J$2&TEXT(D3,\"000\")&$K$2","v":"D:\\тест\\92016111002.txt.zip"},{"$f":"TRIM(LEFT(SUBSTITUTE(E3,\".\",REPT(\" \",99)),99))","v":"2"},{"$f":"TRIM(RIGHT(SUBSTITUTE(A3,\"\\\",REPT(\" \",99)),99))","v":"2.csv"}]
["D:\\тест\\3.csv",{"$f":"LEFTB(A4,LEN(A4)-LEN(E4))&$J$2&TEXT(D4,\"000\")&\".txt\"","v":"D:\\тест\\92016111003.txt"},{"$f":"LEFTB(A4,LEN(A4)-LEN(E4))&$J$2&TEXT(D4,\"000\")&$K$2","v":"D:\\тест\\92016111003.txt.zip"},{"$f":"TRIM(LEFT(SUBSTITUTE(E4,\".\",REPT(\" \",99)),99))","v":"3"},{"$f":"TRIM(RIGHT(SUBSTITUTE(A4,\"\\\",REPT(\" \",99)),99))","v":"3.csv"}]
["D:\\тест\\4.csv",{"$f":"LEFTB(A5,LEN(A5)-LEN(E5))&$J$2&TEXT(D5,\"000\")&\".txt\"","v":"D:\\тест\\92016111004.txt"},{"$f":"LEFTB(A5,LEN(A5)-LEN(E5))&$J$2&TEXT(D5,\"000\")&$K$2","v":"D:\\тест\\92016111004.txt.zip"},"4","4.csv"]