none
Formatting the sheet when i click export to excel in SharePoint online list. RRS feed

  • Question

  • I want to format the excel sheet when i click the export to excel option in SharePoint online list.

    So that who ever the other users clicking the 'Export to excel' option it should show the same format to all.

    Format means adding the heading inside the excel sheet and color changes and merging the few columns

    Tuesday, November 26, 2019 4:11 AM

All replies

  • Hi Rajesh,

    This is by design, if you want to customize the export excel, as a workaround, we can customize a ListView Command Set, and using code to export the list view data to excel file, you can refer to the solution from here:

    SPFx Export Selected Items to Excel - ListView Command Set

    Best Regards,

    Dennis


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    Tuesday, November 26, 2019 7:20 AM
    Moderator
  • Hi,

    Would you please provide us with an update on the status of your issue?

    Best Regards,
    Dennis


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    Monday, December 2, 2019 7:46 AM
    Moderator