{"id":2012,"date":"2021-03-28T17:29:18","date_gmt":"2021-03-28T11:59:18","guid":{"rendered":"https:\/\/store.ksolves.com\/blog\/?p=2012"},"modified":"2025-11-20T13:23:51","modified_gmt":"2025-11-20T07:53:51","slug":"systematically-generate-a-report-in-xls-xlsx-format-in-odoo","status":"publish","type":"post","link":"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo","title":{"rendered":"Systematically Generate a Report in XLS\/XLSX Format in Odoo"},"content":{"rendered":"

Many corporate organizations require XLS reports on a regular basis. Data manipulation and representation become simple with an XLS file. The XLS\/XLSX reports offer several useful features, including the ability to assist users to view data. This spreadsheet file is used in a variety of ways, some of which may amaze you.<\/p>\n

In this blog, you will learn how to create XLS & XLSX format reports in Odoo.<\/p>\n

Follow the given steps precisely to learn something new today!<\/p>\n

Step 1: <\/b>Odoo doesn\u2019t support XLS, XLSX reports. So you need to install third-party modules for it.<\/p>\n

Like (Base report XLSX\u2192 https:\/\/apps.odoo.com\/apps\/modules\/15.0\/report_xlsx\/<\/span><\/a><\/p>\n

).<\/p>\n

For the Base report XLSX module, you also need to install these python packages.<\/p>\n

a- $ pip3 install xlsxwriter<\/p>\n

b- $ pip3 install xlrd<\/p>\n

\"XLS\/XLSX<\/p>\n

So, In order to generate XLSX reports we need to download a third-party module for it. After that, you get the XLSX option in report type.<\/p>\n

Step 2:<\/strong> Now we need to generate the report.<\/span><\/p>\n

2.a- Now inherit the third-party module in your module and create a report XML.<\/p>\n

\"binding<\/p>\n

 <\/p>\n

<record id<\/b>= report_test_records model<\/b>=\u201dir.actions.report\u201d><\/span><\/p>\n

<field name=\u201dname\u201d<\/b>> Name <\/field<\/b>><\/p>\n

<field name=\u201dmodel\u201d<\/b>> model.name <\/field<\/b>><\/p>\n

<field name=\u201dreport_type\u201d<\/b>> xlsx<\/b> <\/field<\/b><><\/p>\n

<field name=\u201dreport_name\u201d<\/b>> module_name.report_name<\/b> <\/field<\/b>><\/p>\n

<field name=\u201dreport_type\u201d<\/b>> module_name.report_name <\/field<\/b>><\/p>\n

<field name=\u201dbinding_model_id\u201d<\/b>> module_name.report_name <\/field<\/b>><\/p>\n

<field name=\u201dbinding_type\u201d<\/b>> report<\/b> <\/field<\/b>><\/p>\n

<\/record<\/b>><\/p>\n

2.b- Add the report_type<\/b> as XLSX<\/b>.<\/p>\n

2.c- Add the model id in binding_model_id in which you want to show that report.<\/p>\n

2.d- Now create a python class like the structure given below.<\/p>\n

2.e- Set the name of the class which you pass in report_name in the XML.<\/p>\n

Ex. _name = \u2018report.module_name.report_name<\/b>\u2019<\/p>\n

2.f- Now the generate_xlsx_report method will give you the XLSX report.<\/p>\n

By following the given steps you can successfully create XLS and XLSX reports in Odoo.<\/p>\n

If you need Odoo customization or module development service, contact the Ksolves experts.<\/p>\n

Get expert assistance anytime anywhere. Contact us at the given details:<\/p>\n

Website: https:\/\/store.ksolves.com\/<\/a>
\nPhone:+1(646)-203-1075, +91-7498170227
\nEmail: sales@ksolves.com<\/span><\/a><\/p>\n

<\/div>\n

<\/g><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

Many corporate organizations require XLS reports on a regular basis. Data manipulation and representation become simple with an XLS file. […]<\/p>\n

<\/div>\n

<\/g><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":3,"featured_media":2013,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2012","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-odoo"],"acf":[],"yoast_head":"\nCreate XLS and XLSX Reports in Odoo<\/title>\n<meta name=\"description\" content=\"Learn how to create the XLS and XLSX Reports in Odoo with a step-by-step process. Click on the given link to know more.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create XLS and XLSX Reports in Odoo\" \/>\n<meta property=\"og:description\" content=\"Learn how to create the XLS and XLSX Reports in Odoo with a step-by-step process. Click on the given link to know more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo\" \/>\n<meta property=\"og:site_name\" content=\"Ksolves Store Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-28T11:59:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-20T07:53:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/store.ksolves.com\/blog\/wp-content\/uploads\/2022\/03\/XLS_XLSX-Format-Reports.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"880\" \/>\n\t<meta property=\"og:image:height\" content=\"440\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Parul Gautam\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Parul Gautam\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo\",\"url\":\"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo\",\"name\":\"Create XLS and XLSX Reports in Odoo\",\"isPartOf\":{\"@id\":\"https:\/\/store.ksolves.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo#primaryimage\"},\"image\":{\"@id\":\"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo#primaryimage\"},\"thumbnailUrl\":\"https:\/\/store.ksolves.com\/blog\/wp-content\/uploads\/2022\/03\/XLS_XLSX-Format-Reports.jpg\",\"datePublished\":\"2021-03-28T11:59:18+00:00\",\"dateModified\":\"2025-11-20T07:53:51+00:00\",\"author\":{\"@id\":\"https:\/\/store.ksolves.com\/blog\/#\/schema\/person\/24bfd358b29cc978fd6e7f809e28b7d2\"},\"description\":\"Learn how to create the XLS and XLSX Reports in Odoo with a step-by-step process. Click on the given link to know more.\",\"breadcrumb\":{\"@id\":\"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo#primaryimage\",\"url\":\"https:\/\/store.ksolves.com\/blog\/wp-content\/uploads\/2022\/03\/XLS_XLSX-Format-Reports.jpg\",\"contentUrl\":\"https:\/\/store.ksolves.com\/blog\/wp-content\/uploads\/2022\/03\/XLS_XLSX-Format-Reports.jpg\",\"width\":880,\"height\":440,\"caption\":\"XLS XLSX Format Report\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/store.ksolves.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Systematically Generate a Report in XLS\/XLSX Format in Odoo\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/store.ksolves.com\/blog\/#website\",\"url\":\"https:\/\/store.ksolves.com\/blog\/\",\"name\":\"Ksolves Store Blog\",\"description\":\"Where Great Ideas Change Your Business\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/store.ksolves.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/store.ksolves.com\/blog\/#\/schema\/person\/24bfd358b29cc978fd6e7f809e28b7d2\",\"name\":\"Parul Gautam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/store.ksolves.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9eb990d177ece8faa608213c706ff36edd7f09fbb996e90aaa4d36dcb6f41cac?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9eb990d177ece8faa608213c706ff36edd7f09fbb996e90aaa4d36dcb6f41cac?s=96&d=mm&r=g\",\"caption\":\"Parul Gautam\"},\"description\":\"Parul Gautam is a Sr. Technical Writer who believes in bridging the gap between customers and Technologies. She can convert the aura of any Technology into Powerful Words. One time she can Jot Down her words and at the other, she will Tap on the Beats of Great Music. To Taste the Recipe of her Writing, hang on to the great Blogs.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create XLS and XLSX Reports in Odoo","description":"Learn how to create the XLS and XLSX Reports in Odoo with a step-by-step process. Click on the given link to know more.","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:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo","og_locale":"en_US","og_type":"article","og_title":"Create XLS and XLSX Reports in Odoo","og_description":"Learn how to create the XLS and XLSX Reports in Odoo with a step-by-step process. Click on the given link to know more.","og_url":"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo","og_site_name":"Ksolves Store Blog","article_published_time":"2021-03-28T11:59:18+00:00","article_modified_time":"2025-11-20T07:53:51+00:00","og_image":[{"width":880,"height":440,"url":"https:\/\/store.ksolves.com\/blog\/wp-content\/uploads\/2022\/03\/XLS_XLSX-Format-Reports.jpg","type":"image\/jpeg"}],"author":"Parul Gautam","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Parul Gautam","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo","url":"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo","name":"Create XLS and XLSX Reports in Odoo","isPartOf":{"@id":"https:\/\/store.ksolves.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo#primaryimage"},"image":{"@id":"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo#primaryimage"},"thumbnailUrl":"https:\/\/store.ksolves.com\/blog\/wp-content\/uploads\/2022\/03\/XLS_XLSX-Format-Reports.jpg","datePublished":"2021-03-28T11:59:18+00:00","dateModified":"2025-11-20T07:53:51+00:00","author":{"@id":"https:\/\/store.ksolves.com\/blog\/#\/schema\/person\/24bfd358b29cc978fd6e7f809e28b7d2"},"description":"Learn how to create the XLS and XLSX Reports in Odoo with a step-by-step process. Click on the given link to know more.","breadcrumb":{"@id":"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo#primaryimage","url":"https:\/\/store.ksolves.com\/blog\/wp-content\/uploads\/2022\/03\/XLS_XLSX-Format-Reports.jpg","contentUrl":"https:\/\/store.ksolves.com\/blog\/wp-content\/uploads\/2022\/03\/XLS_XLSX-Format-Reports.jpg","width":880,"height":440,"caption":"XLS XLSX Format Report"},{"@type":"BreadcrumbList","@id":"https:\/\/store.ksolves.com\/blog\/odoo\/systematically-generate-a-report-in-xls-xlsx-format-in-odoo#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/store.ksolves.com\/blog"},{"@type":"ListItem","position":2,"name":"Systematically Generate a Report in XLS\/XLSX Format in Odoo"}]},{"@type":"WebSite","@id":"https:\/\/store.ksolves.com\/blog\/#website","url":"https:\/\/store.ksolves.com\/blog\/","name":"Ksolves Store Blog","description":"Where Great Ideas Change Your Business","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/store.ksolves.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/store.ksolves.com\/blog\/#\/schema\/person\/24bfd358b29cc978fd6e7f809e28b7d2","name":"Parul Gautam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/store.ksolves.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9eb990d177ece8faa608213c706ff36edd7f09fbb996e90aaa4d36dcb6f41cac?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9eb990d177ece8faa608213c706ff36edd7f09fbb996e90aaa4d36dcb6f41cac?s=96&d=mm&r=g","caption":"Parul Gautam"},"description":"Parul Gautam is a Sr. Technical Writer who believes in bridging the gap between customers and Technologies. She can convert the aura of any Technology into Powerful Words. One time she can Jot Down her words and at the other, she will Tap on the Beats of Great Music. To Taste the Recipe of her Writing, hang on to the great Blogs."}]}},"_links":{"self":[{"href":"https:\/\/store.ksolves.com\/blog\/wp-json\/wp\/v2\/posts\/2012","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/store.ksolves.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/store.ksolves.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/store.ksolves.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/store.ksolves.com\/blog\/wp-json\/wp\/v2\/comments?post=2012"}],"version-history":[{"count":6,"href":"https:\/\/store.ksolves.com\/blog\/wp-json\/wp\/v2\/posts\/2012\/revisions"}],"predecessor-version":[{"id":2018,"href":"https:\/\/store.ksolves.com\/blog\/wp-json\/wp\/v2\/posts\/2012\/revisions\/2018"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/store.ksolves.com\/blog\/wp-json\/wp\/v2\/media\/2013"}],"wp:attachment":[{"href":"https:\/\/store.ksolves.com\/blog\/wp-json\/wp\/v2\/media?parent=2012"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/store.ksolves.com\/blog\/wp-json\/wp\/v2\/categories?post=2012"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/store.ksolves.com\/blog\/wp-json\/wp\/v2\/tags?post=2012"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}