{"id":224,"date":"2022-06-09T19:54:58","date_gmt":"2022-06-09T19:54:58","guid":{"rendered":"https:\/\/docs.xlreport.com\/docs\/admin-user\/insert-query-data-into-excel\/"},"modified":"2022-06-14T17:59:40","modified_gmt":"2022-06-14T17:59:40","slug":"insert-query-data-into-excel","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/insert-query-data-into-excel\/","title":{"rendered":"Insert Data into Excel"},"content":{"rendered":"<p>Insert Query Data into Excel<\/p>\n<h2>Insert Data<\/h2>\n<p>Select the XLReport Query object from within the Project Explorer and insert its underlying data as:<\/p>\n<ul>\n<li value=\"1\">\n<h3>Static Sheet<\/h3>\n<p>This inserts the raw static data into Excel.<\/li>\n<li value=\"2\">\n<h3>Live \u2013 Real Time Sheet<\/h3>\n<p>This inserts a live real time connected data set into Excel.<\/li>\n<li value=\"3\">\n<h3>Live \u2013 Real Time Pivot Table<\/h3>\n<p>This inserts a live real time connected data set into Excel.<\/p>\n<p>Optionally, you can choose to also insert a live real time connected Pivot Chart.<\/li>\n<\/ul>\n<h2><a name=\"static-sheet\"><\/a>Insert as Static Data<\/h2>\n<ul>\n<li value=\"1\">Select the Query Object in the Project Explorer and double click it.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/59.png\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/60.png\" \/><\/p>\n<ul>\n<li value=\"1\">Select &#8220;Excel Static Data&#8221;.<\/li>\n<li value=\"2\">Select if to place the data in a new Excel sheet or a designated range.<\/li>\n<li value=\"3\">Choose if to add a title &#8211; the XLReport Query Object&#8217;s name &#8211; above the data.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/61.png\" \/><\/p>\n<ul>\n<li value=\"1\">Choose if to add column headers &#8211; the XLReport Query &#8211; column headers &#8211; above the data.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/62.png\" \/><\/p>\n<p>If you select &#8220;New Sheet&#8221; then XLReport will insert a new Excel sheet and assign the name of the Query Object to it (max. 20 characters).<\/p>\n<p>The data from the underlying Query Object will be inserted into Excel.<\/p>\n<h2><a name=\"live-sheet\"><\/a>Insert as Real Time Data<\/h2>\n<ul>\n<li value=\"1\">Select the Query Object in the Project Explorer and double click it.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/59.png\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/63.png\" \/><\/p>\n<ul>\n<li value=\"1\">Select &#8220;Excel Live Data&#8221;.<\/li>\n<li value=\"2\">Select if to place the data in a new Excel sheet or a designated range.<\/li>\n<li value=\"3\">Choose if to add a title &#8211; the XLReport Query Object&#8217;s name &#8211; above the data.<\/li>\n<li value=\"4\">Choose if to add column headers &#8211; the XLReport Query &#8211; column headers &#8211; above the data.<\/li>\n<li value=\"5\">Select if to place the data in a new Excel sheet or a designated range.<\/li>\n<\/ul>\n<p>If you select &#8220;New Sheet&#8221; then XLReport will insert a new Excel sheet and assign the name of the Query Object to it (max. 20 characters).<\/p>\n<p>If you select &#8220;Existing Sheet&#8221; then you must assign either a cell or point the mouse to an Excel cell.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/64.png\" \/><\/p>\n<p>The data from the underlying Query Object will be inserted into Excel.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/65.png\" \/><\/p>\n<p>Important! If you convert &#8211; format &#8211; your data set to an Excel table, then the live data connection will be lost and the data set will be converted as static data.<\/p>\n<h2><a name=\"live-pivot\"><\/a>Insert as Real Time Pivot<\/h2>\n<ul>\n<li value=\"1\">Select the Query Object in the Project Explorer and double click it.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/59.png\" \/><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/66.png\" \/><\/p>\n<ul>\n<li value=\"1\">Select &#8220;Excel Pivot Table&#8221;.<\/li>\n<li value=\"2\">Select if to place the data in a new Excel sheet or a designated range.<\/li>\n<li value=\"3\">Choose if to add a title &#8211; the XLReport Query Object&#8217;s name &#8211; above the data.<\/li>\n<li value=\"4\">Choose if to add column headers &#8211; the XLReport Query &#8211; column headers &#8211; above the data.<\/li>\n<li value=\"5\">Select if to place the data in a new Excel sheet or a designated range.<\/li>\n<li value=\"6\">If you select &#8220;New Sheet&#8221; then XLReport will insert a new Excel sheet and assign the name of the Query Object to it (max. 20 characters).<\/li>\n<li value=\"7\">If you select &#8220;Existing Sheet&#8221; then you must assign either a cell or point the mouse to an Excel cell.<\/li>\n<li value=\"8\">Optionally select &#8220;Include Chart&#8221; to insert also a Pivot Chart.<\/li>\n<\/ul>\n<p>The data from the underlying Query Object will be inserted into Excel.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/67.png\" \/><\/p>\n<ul>\n<li value=\"1\">If you select to also insert a Pivot Chart, XLReport creates a new sheet with it.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/68.png\" \/><\/p>\n<p class=\"note\">Note: The Pivot Chart will be bound to the Pivot Table.<br \/>\nThat means: whenever you change pivot settings to either the table or the chart the table \/ chart will also be updated to the same parameters.<\/p>\n<h2>Parameters<\/h2>\n<p>When a parameter Query data is inserted into Excel it will show a comment above the data which displays the parameter values. Hover over the comment to view its text.<\/p>\n","protected":false},"featured_media":0,"parent":106,"menu_order":6,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/224"}],"collection":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/comments?post=224"}],"version-history":[{"count":7,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/224\/revisions"}],"predecessor-version":[{"id":371,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/224\/revisions\/371"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/106"}],"next":[{"title":"User - User Group Security","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/user-user-group-security\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/226"}],"prev":[{"title":"Query Your Data","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/147"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=224"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}