strapi-plugin-excel-export

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #typescript #go #machine-learning #rust #deep-learning #nodejs #awesome #cli #kubernetes #ios

strapi-plugin-excel-export

(★ 10)

Strapi plugin to export excel

strapi-plugin-excel-export Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

<!-- # Excel Export

This plugin allows users to generate and download excel files directly from their strapi application, streamlining data management and analysis. With intuitive configuration options, users can define the data to be included in the excel file.The plugin is designed to be user-friendly, offering a seamless experience for both developers and end-users. -->

# Getting Started

This plugin allows users to extract data easily from strapi backend into **.xlsx** format

![Multi-Select Video](https://raw.githubusercontent.com/vinubabu323/strapi-plugin-excel-export/develop/screenshots/working.gif)

## How to install

1.  Go into your strapi project.
2.  Install the plugin using the command `npm i strapi-plugin-excel-export-2024` or `yarn add strapi-plugin-excel-export-2024`
3.  The plugin will be added to your strapi project.

## How to use

1.  Create an **excel.js** file in the config folder. This file is used to provide tables and columns that need to be in the excel file

```
module.exports = {
  config: {
    "api::contact-form.contact-form": {
      columns: [
        "first_name",
        "last_name",
        "phone_no",
        "business_email",
        "job_title",
        "company_name",
        "company_website",
        "city",
        "message",
      ],
      relation: {
        solution: {
          column: ["title"],
        },
      },
      locale: "false",
    },
  },
};
```

- The tables **uid** (api::contact-form.contact-form) need to be given following by its columns required
  - The columns has to be exactly like in the **schema**.
- Relational fields need to be specified in the relation. For example consider the relation as solution and the column wanted from that relation is title.

- Even if there is no relation needed please keep the relation field empty.

- `relation: {},`

- **Note :** Currently one level of relation is supported.

- The locale field is for i18 translation plugin. If there is translation for the table you have to make it true.

- **Note :** Currently data will be only availabe in 'en'.

- **You can't extract data from dynamic zone or nested components.**

strapi-plugin-excel-export

strapi-plugin-excel-export Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

strapi-plugin-excel-export

strapi-plugin-excel-export Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README