Forum Discussion

CardinalNight's avatar
CardinalNight
Brass Contributor
Jun 03, 2024

Using an SPFx extension to hide the Export to Excel button

As the title suggests I want to create an extension that hides it for classic mode and potentially for modern. I will then implement this extension into a PS script that applies it to a site template.

I've made a fairly deep google search and found:
https://www.sharepointdiary.com/2020/08/sharepoint-online-disable-export-to-excel.html

https://laurakokkarinen.com/the-ultimate-guide-to-sharepoint-site-designs-and-site-scripts/#creating-a-site-script

https://github.com/pnp/sp-dev-site-scripts/tree/master/samples

I've tried:

@import '~@microsoft/sp-office-ui-fabric-core/dist/sass/SPFabricCore.scss';

:global {
	a[id*='ExportToSpreadsheet'] {
		display:none;
	}
 
	button[name="Export to Excel"] {
		display: none;
	}
}

but neither work.
I'm importing the the above style like this:

import { Log } from '@microsoft/sp-core-library';
import {
  BaseApplicationCustomizer,
} from '@microsoft/sp-application-base';
import * as strings from 'SiteScriptExtensionApplicationCustomizerStrings';
import './SiteScriptExtension.module.scss';
import { override } from '@microsoft/decorators';
const LOG_SOURCE: string = 'SiteScriptExtensionApplicationCustomizer';

export interface ISiteScriptExtensionApplicationCustomizerProperties {
  // This is an example; replace with your own property
}

export default class SiteScriptExtensionApplicationCustomizer
  extends BaseApplicationCustomizer<ISiteScriptExtensionApplicationCustomizerProperties> {
  @override
  public onInit(): Promise<void> {
    Log.info(LOG_SOURCE, `Initialized ${strings.Title}`);
    return Promise.resolve();
  }
}

 

No RepliesBe the first to reply

Resources