{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Header Sheet","SQL Query","Settings"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Header Sheet","index":0,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[21,1,21,3],[22,1,22,3],[1,2,1,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3]]}
[]
[null,null,"Activex Data Objects Database (ADODB) Demonstration"]
[]
[null,"Document Number :  ","ADODB"]
[null,"Owner / Author :  ","Thomas James Rowe"]
[null,"Last Update :  ","2022-01-02"]
[]
[null,"Purpose and Objectives"]
[]
[null,"Activex Data Objects Database (ADODB) interface."]
[]
[null,"Microsoft ActiveX Data Objects (ADO) enable your client applications to access and manipulate data from a variety of sources through an OLE DB provider. Its primary benefits \nare ease of use, high speed, low memory overhead, and a small disk footprint. ADO supports key features for building client/server and Web-based applications."]
[null,"Microsoft ActiveX Data Objects (Multidimensional) (ADO MD) provides easy access to multidimensional data from languages such as Microsoft Visual Basic."]
[]
[null,"Worksheets"]
[]
[null,"SQL Query","SQL Query."]
[null,"Settings","Settings."]
[]
[null,"Other Relevant Information"]
[]
[null,"Microsoft ActiveX Data Objects (ADO)"]
[null,"https://docs.microsoft.com/en-us/sql/ado/microsoft-activex-data-objects-ado?view=sql-server-ver15"]
[]
[null,"Revision Log"]
[]
[null,"Date","Amendments  ","Updated by"]
[null,"2022-01-02","Initial release.","T.J.Rowe"]
[]
[]
[]
[null,"Copyright © 2022 Thomas James Rowe (Excel Coding) All Rights Reserved"]

{"sheet":"SQL Query","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["ID","First Name","Surname","Gender","Street","Town","Zip/Postcode","Email Address"]
[6,"Peter","Jones","Male","Jones Avenue","Jonestown","JES 2","peterjones@gmail.com"]
[7,"Sharon","Jones","Female","Jones Avenue","Jonestown","JES 2","sharonjones@gmail.com"]
[8,"Janet","Jones","Female","Jones Avenue","Jonestown","JES 2","janetjones@gmail.com"]
[9,"Jackie","Jones","Female","Jones Avenue","Jonestown","JES 2","jackiejones@gmail.com"]
[17,"Stephen","Johnson","Male","Jones Close","Jonestown","JES 3","stephenjohnson@gmail.com"]
[18,"Mary","Johnson","Female","Jones Close","Jonestown","JES 3","maryjohnson@gmail.com"]
[19,"Sue","Johnson","Female","Jones Close","Jonestown","JES 3","suejohnson@gmail.com"]
[20,"Fred","Johnson","Male","Jones Close","Jonestown","JES 3","fredjohnson@gmail.com"]

{"sheet":"Settings","index":2,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Setting >","Version Date"]
["Named Range >","VersionDate"]
["Value/s >","1.0 [ 02/01/2022 ]"]