{"id":4139,"date":"2014-07-03T15:52:47","date_gmt":"2014-07-03T15:52:47","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=4139"},"modified":"2022-08-06T12:10:07","modified_gmt":"2022-08-06T12:10:07","slug":"record-set-from-database-excel-macro","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/","title":{"rendered":"VBA to Query Database and Spread the Records in Excel"},"content":{"rendered":"<p>In continuation to one of <strong><a href=\"\/excel\/?s=%22connection+string%22\" target=\"_blank\" rel=\"noopener\">my article<\/a><\/strong> which shares the <a href=\"https:\/\/vmlogger.com\/excel\/2011\/11\/oracle-connection-string-in-vba\/\"  targte=\"_blank\"><strong>connection strings<\/strong><\/a> to connect to different data bases. In this article I explained and shared every possible VBA code to make connection with many databases <a href=\"https:\/\/vmlogger.com\/excel\/2011\/11\/sql-connection-string\/\" target=\"_blank\" rel=\"noopener\"><strong>like Oracle, SQL etc.<\/strong><\/a> <strong>but does the Story ends there??<\/strong> NO WAY !! That&#8217;s the starting point. You are going to make connection to Database ONLY when you need to execute any kind of query query. It could be a SELECT, UPDATE, INSERT etc.<\/p>\n<p>\nTherefore in this article I am going to complete my pending story by sharing the Excel Macro to Query a Database and fetch records and populate them in WorkSheet. A BIG thanks to one of my friend <a href=\"http:\/\/anilwrites.blogspot.nl\/\" target=\"_blank\" rel=\"noopener\"><strong>Anil<\/strong> <\/a> and an avid reader of my blog, for reminding me to complete this article.<\/p>\n<blockquote><p>\nThough Queries (SQL Statements) are categorized in many different categories like <strong>DDL<\/strong> (Data Definition Language), <strong>DML<\/strong> (Data Manipulation Language) etc. based their way of functioning.<br \/>\nHere to execute a Query in excel macro, Queries can be categorized in to two categories:<\/p>\n<h3>1. Queries which returns NO records like DELETE, INSERT, UPDATE, ROLLBACK, COMMIT&#8230; etc.<\/h3>\n<h3>2. Queries which are tend to return records like SELECT queries. <\/h3>\n<p>Method of executing both the queries, in excel macro, are different which are explained with example below.\n<\/p><\/blockquote>\n<h3>1. Excel Macro to execute an INSERT, UPDATE, DELETE Statement in DB<\/h3>\n<p>Queries which does not return any record after running, can be executed by <i>&#8220;YourConnectionObject&#8221;<\/i><strong>.Execute<\/strong> <i>&#8220;Your Query&#8221;<\/i>.<br \/>\nThis statement does not return anything. It simply executes your query and performs the respective operation.<\/p>\n<p>Following is the Excel Macro Code which connects to the data base and execute your given query. It could be like INSERT Query, DELETE, UPDATE, COMMIT, ROLLBACK etc.<\/p>\n<pre><code class=\"language-vbnet\">\r\nFunction ExecuteQuery()\r\n\tDim DBcon As ADODB.Connection\r\n\tSet DBcon = New ADODB.Connection\r\n\tDim DBHost As String\r\n\tDim DBPort As String\r\n\tDim DBsid As String\r\n\tDim DBuid As String\r\n\tDim DBpwd As String\r\n\tDim DBQuery As String\r\n\tDim ConString As String\r\n\tOn Error GoTo err\r\n' DB connectivity details. Pass the correct connectivity details here\r\n\tDBHost = \"Host Address\"\r\n\tDBPort = \"Port Number\"\r\n\tDBsid = \"SID to Connect DB\"\r\n\tDBuid = \"User ID\"\r\n\tDBpwd = \"Password\"\r\n'Connection string to connect to Oracle using SID\r\n\tConString = \"Driver={Microsoft ODBC for Oracle}; \" & _\r\n\t\"CONNECTSTRING=(DESCRIPTION=\" & _\r\n\t\"(ADDRESS=(PROTOCOL=TCP)\" & _\r\n\t\"(HOST=\" & DBHost & \")(PORT=\" & DBPort & \"))\" & _\r\n\t\"(CONNECT_DATA=(SID=\" & DBsid & \"))); uid=\" & DBuid & \"; pwd=\" & DBpwd & \";\"\r\n'Open the connection using Connection String\r\n\tDBcon.Open (ConString) 'Connecion to DB is made\r\n\tDBQuery = \"Your Query\" 'like UPDATE, DELETE, INSERT etc.\r\n'below statement will execute the query\r\n\tDBcon.Execute DBQuery\r\n\tMsgBox (\"Query is successfully executed\")\r\n'Close the connection\r\n\tDBcon.Close\r\n\tExit Sub\r\n\terr:\r\n\tMsgBox \"Following Error Occurred: \" & vbNewLine & err.Description\r\n\tDBcon.Close\r\nEnd Function\r\n<\/code><\/pre>\n<h3>2. Excel Macro to execute a SELECT Statement which returns Records<\/h3>\n<p>In this case when you run your query then you expect a set of recordset returned by the query and ofcourse!! you want to capture them and spread them in your workSheet. <\/p>\n<p>\nFollowing statement is used to execute a query to get get the recordset. <i>RecordSetObject<\/i><strong>.Open<\/strong> <i>Your query<\/i>, <i>DB Connection Object<\/i>.<br \/>\nRefer the below excel macro which does following tasks:<\/p>\n<p>1. Makes connection with Oracle Database<\/p>\n<p>2. Executes your Query to get Record Set as a result of the Query<\/p>\n<p>3. Spread all the records in to your Excel Sheet named <strong><i>&#8220;Data&#8221;<\/i><\/strong><\/p>\n<h3>Statement used to spread all the records of a recordSet in Excel Sheet (Without Loop)<\/h3>\n<p><i>Sheets(&#8220;data&#8221;).Range(&#8220;A2&#8221;)<\/i><strong>.CopyFromRecordset<\/strong> <i>RecordSetObject<\/i><\/p>\n<p>&nbsp;<\/p>\n<pre><code class=\"language-vbnet\">\r\nFunction FetchRecordSetQuery()\r\n\t\r\n\tDim DBcon As ADODB.Connection\r\n\tDim DBrs As ADODB.Recordset\r\n\tSet DBcon = New ADODB.Connection\r\n\tSet DBrs = New ADODB.Recordset\r\n\tDim DBHost As String\r\n\tDim DBPort As String\r\n\tDim DBsid As String\r\n\tDim DBuid As String\r\n\tDim DBpwd As String\r\n\tDim DBQuery As String\r\n\tDim ConString As String\r\n        Dim intColIndex as Integer\r\n\tOn Error GoTo err\r\n' DB connectivity details. Pass the correct connectivity details here\r\n\tDBHost = \"Host Address\"\r\n\tDBPort = \"Port Number\"\r\n\tDBsid = \"SID to Connect DB\"\r\n\tDBuid = \"User ID\"\r\n\tDBpwd = \"Password\"\r\n'Connection string to connect to Oracle using SID\r\n\tConString = \"Driver={Microsoft ODBC for Oracle}; \" & _\r\n\t\"CONNECTSTRING=(DESCRIPTION=\" & _\r\n\t\"(ADDRESS=(PROTOCOL=TCP)\" & _\r\n\t\"(HOST=\" & DBHost & \")(PORT=\" & DBPort & \"))\" & _\r\n\t\"(CONNECT_DATA=(SID=\" & DBsid & \"))); uid=\" & DBuid & \"; pwd=\" & DBpwd & \";\"\r\n'Open the connection using Connection String\r\n\tDBcon.Open (ConString) 'Connecion to DB is made\r\n\tDBQuery = \"Your Query\" 'like UPDATE, DELETE, INSERT etc.\r\n'below statement will execute the query and stores the Records in DBrs\r\n\tDBrs.Open DBQuery, DBcon\r\n\tIf Not DBrs.EOF Then 'to check if any record then\r\n' Spread all the records with all the columns\r\n' in your sheet from Cell A2 onward.\r\n\t\tSheets(\"data\").Range(\"A2\").CopyFromRecordset DBrs\r\n'Above statement puts the data only but no column\r\n'name. hence the below for loop will put all the\r\n'column names in your excel sheet.\r\n\t\tFor intColIndex = 0 To DBrs.Fields.Count - 1  ' recordset fields\r\n\t\t\tSheets(\"data\").Cells(1, intColIndex + 1).Value = DBrs.Fields(intColIndex).Name\r\n\t\tNext\r\n\tEnd If\r\n'Close the connection\r\n\tDBcon.Close\r\n\tExit Function\r\n\terr:\r\n\tMsgBox \"Following Error Occurred: \" & vbNewLine & err.Description\r\n\tDBcon.Close\r\nEnd Function\r\n<\/code><\/pre>\n<blockquote>\n<h3>\nAbove codes are examples to show, how to execute a query and spread the records across the Excel Sheet without using a Loop. I have taken an example of connecting Oracle Database using SID connection. If you have to connect to some other database using Service etc then go through my previous articles to get the Connection String for such connections. If you still face any issue regarding connecting to your DB or querying the DB kindly mail me.<\/h3>\n<\/blockquote>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>In continuation to one of my article which shares the connection strings to connect to different data bases. In this article I explained and shared every possible VBA code to make connection with many databases like Oracle, SQL etc. but does the Story ends there?? NO WAY !! That&#8217;s the starting point. You are going [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[5203,1246,1675],"tags":[],"class_list":["post-4139","post","type-post","status-publish","format-standard","hentry","category-database","category-macro","category-excel-macro-for-beginners"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.5 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA to Query Database and Spread the Records in Excel - Let&#039;s excel in Excel<\/title>\n<meta name=\"description\" content=\"VBA to connect to database | VBA to query the database and spread it in Excel sheet | Excel Macro to execute INSERT, UPDATE, DELETE statements\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA to Query Database and Spread the Records in Excel\" \/>\n<meta property=\"og:description\" content=\"VBA to connect to database | VBA to query the database and spread it in Excel sheet | Excel Macro to execute INSERT, UPDATE, DELETE statements\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/\" \/>\n<meta property=\"og:site_name\" content=\"Let&#039;s excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-03T15:52:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-06T12:10:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"VBA to Query Database and Spread the Records in Excel\",\"datePublished\":\"2014-07-03T15:52:47+00:00\",\"dateModified\":\"2022-08-06T12:10:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/\"},\"wordCount\":494,\"commentCount\":11,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"articleSection\":[\"Database\",\"Excel Macro\",\"Excel Macro Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/\",\"name\":\"VBA to Query Database and Spread the Records in Excel - Let&#039;s excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"datePublished\":\"2014-07-03T15:52:47+00:00\",\"dateModified\":\"2022-08-06T12:10:07+00:00\",\"description\":\"VBA to connect to database | VBA to query the database and spread it in Excel sheet | Excel Macro to execute INSERT, UPDATE, DELETE statements\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database\",\"item\":\"https:\/\/vmlogger.com\/excel\/database\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"VBA to Query Database and Spread the Records in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let&#039;s excel in Excel\",\"description\":\"Let&#039;s share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"VBA to Query Database and Spread the Records in Excel - Let&#039;s excel in Excel","description":"VBA to connect to database | VBA to query the database and spread it in Excel sheet | Excel Macro to execute INSERT, UPDATE, DELETE statements","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/","og_locale":"en_US","og_type":"article","og_title":"VBA to Query Database and Spread the Records in Excel","og_description":"VBA to connect to database | VBA to query the database and spread it in Excel sheet | Excel Macro to execute INSERT, UPDATE, DELETE statements","og_url":"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/","og_site_name":"Let&#039;s excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2014-07-03T15:52:47+00:00","article_modified_time":"2022-08-06T12:10:07+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png","type":"image\/png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"VBA to Query Database and Spread the Records in Excel","datePublished":"2014-07-03T15:52:47+00:00","dateModified":"2022-08-06T12:10:07+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/"},"wordCount":494,"commentCount":11,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"articleSection":["Database","Excel Macro","Excel Macro Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/","url":"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/","name":"VBA to Query Database and Spread the Records in Excel - Let&#039;s excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"datePublished":"2014-07-03T15:52:47+00:00","dateModified":"2022-08-06T12:10:07+00:00","description":"VBA to connect to database | VBA to query the database and spread it in Excel sheet | Excel Macro to execute INSERT, UPDATE, DELETE statements","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2014\/07\/record-set-from-database-excel-macro\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Database","item":"https:\/\/vmlogger.com\/excel\/database\/"},{"@type":"ListItem","position":3,"name":"VBA to Query Database and Spread the Records in Excel"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let&#039;s excel in Excel","description":"Let&#039;s share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4139"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=4139"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4139\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=4139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=4139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=4139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}