How to customize the row number in the exported excel file?

[srinidhirao]

Screenshot

1. Try to download data as excel sheet from any chart.

2. Check the resulting excel sheet. Checkout the left most column.

Description

When you export the data from any of the superset charts, its adding a row number column which starts with 0. Anyway we can customize this to start from 1?

I'm on version 3.0.1.

[dosubot[bot]]

To customize the row number in the exported Excel file to start from 1 instead of 0, you'll need to adjust the DataFrame's index before exporting it. This is because the row numbers in the Excel file are generated from the DataFrame's index, which by default starts at 0. Here's how you can modify the index:

df.index += 1

Adding this line before the DataFrame is exported to Excel will shift all the row numbers up by one, making them start from 1. This change needs to be made in the codebase where the DataFrame is prepared for export. If you're unable to modify the codebase yourself, you might need to request this feature from the software maintainers.

Keep in mind, this adjustment will affect all Excel exports from the software, not just a specific case. If you need this customization for specific exports only, a more tailored solution will be necessary.

Details

Sources

• superset/utils/excel.py
• superset-frontend/src/explore/components/useExploreAdditionalActionsMenu/index.jsx
• superset-frontend/packages/superset-ui-core/src/currency-format/utils.ts
• superset/databases/schemas.py
• superset-frontend/src/dashboard/components/gridComponents/Chart.test.jsx

About Dosu
This response is meant to be useful and save you time. It is not meant to be a precise solution, but rather a starting point for your own research.

Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is irrelevant.

To continue the conversation, mention @dosu.

[srinidhirao]

Is there a way to update DataFrame's index from Apache Superset?

[luciferrrrrrrrrrrrrrrrrrrr]

Is it possible to disable this column from excel as I already have a column for serial number in my table