Customizing the Ribbon XML

Microsoft Office replaced menus and toolbars with a Ribbon at the top of the application window since office 2007. The Ribbon is customizable. Aspose.Cells allows you to

• Keep Ribbon XML without parsing it,
• Read and write Ribbon XML without parsing it,
• Get and set Ribbon XML data.

If you want to change the Ribbon XML, you have to parse it with an XML parser or other Ribbon XML tool.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

Workbook wb = new Workbook(dataDir+ "aspose-sample.xlsx");
FileInfo fi = new FileInfo(dataDir+ "CustomUI.xml");
StreamReader sr = fi.OpenText();
wb.RibbonXml = sr.ReadToEnd();
sr.Close();