Can we add the function of open-save-as xlsx file in this example?

[Malini Selvarasu]

Hi Shompinice,

We have reviewed the reported scenario and understand that you need to open the existing Excel file and save it. This can be achieved using the "Open," "Save," and "Save As" methods in SfSpreadsheet. We have modified the provided sample to demonstrate this functionality. Please review the sample and refer to the user guide documentation below.

UG Link: Getting Started with UWP Spreadsheet control | Syncfusion

Getting Started with UWP Spreadsheet control | Syncfusion

Kindly let us know if you have any concerns regarding our update.

Regards,

Malini Selvarasu

Attachment: Spreadsheet_Demo_199a578.zip

[Shompinice]

There is an existing Ribbon bar here. Can we create our own toolbar to replace it? For example

[Malini Selvarasu]

Hi Shompinice,

We have reviewed the reported scenario and understand that you need to customize the existing Ribbon bar. This can be achieved by overriding the template of the SfSpreadsheetRibbon or by invoking the SfSpreadsheetRibbon Loaded event, where you can add or delete ribbon menu items. Please refer to the user guide documentation below.

UG link: Ribbon Customization in UWP Spreadsheet control | Syncfusion

If you have any additional questions or concerns about our update, please don't hesitate to reach out. We're here to assist you.

Regards,

Malini Selvarasu

[Shompinice]

Can you provide an example of using NavigationView with PaneDisplayMode set to Top to organize different button groups, and then put a Command Bar below with many AppBarButtons inside.

[Malini Selvarasu]

Hi Shompinice,

Based on the information provided, we understand that you need to customize the Ribbon NavigationView and add a CommandBar within the RibbonBar items. This can be achieved by invoking the SfSpreadsheetRibbon Loaded event, where you can customize the RibbonBar. We have prepared a sample that meets this requirement.

Please review the sample and let us know if you have any concerns.

If we have misunderstood your requirement, kindly provide more details so that we can assist you further.

Regards,

Malini Selvarasu

Attachment: SfSpreadSheet_Demo_9bc9cb3.zip

[Shompinice]

That's not what I meant, I meant is it possible to call those commands in the Ribbon using controls from the WinUI2 Gallery instead of the Syncfusion Ribbon？

[Malini Selvarasu]

Hi Shompinice,

Sorry for the inconvenience. We have reviewed your scenario; however, we are a little unclear about your requirements. Could you please clarify if you need to add the Syncfusion ribbon commands to your own ribbon control, or if you need to create a new ribbon commands using only WinUI 2 Gallery controls?

This information will help us with further analysis and enable us to provide you with a solution at the earliest. Thank you for your cooperation and understanding.

 

Regards,

Malini Selvarasu

[Shompinice]

I need to create a new these commands using only WinUI 2 Gallery controls

Google translation may not be accurate, my original text is

我需要使用 WinUI2 控件来调用这些命令。

1. 创建一个顶部导航栏，它用来模拟Ribbon导航
   
2. 创建一个工具栏，它用来模拟ribbon中的工具栏

[Malini Selvarasu]

Hi Shompinice,

Thank you for the update. We would like to clarify that our support services are exclusively focused on Syncfusion controls; we do not provide support for WinUI 2 Gallery controls.

If you have any questions or need assistance with any of our Syncfusion controls, please feel free to reach out. We would be more than happy to help.

Thank you for your understanding and cooperation.

Regards,
Malini Selvarasu

[Shompinice]

In this example, you used basic controls instead of SyncFusion controls to call functions, and the word document rendering area is provided by SyncFusion controls.

https://www.syncfusion.com/forums/189333/is-it-possible-to-create-a-uwp-app-that-can-view-and-edit-docx-documents "We have created a sample application where you can load and save documents in code-behind and use built-in commands to perform basic editing operations such as applying bold, italic, and highlight colors. Please use the application as a reference and apply the commands according to your needs."

https://www.syncfusion.com/downloads/support/forum/189333/ze/SfRichTextBoxAdv_UWP_c874748d

[Malini Selvarasu]

Hi Shompinice,

In the forum you shared, we added support for using the MS button to execute commands for the SfRichTextBoxAdv. Since you requested to use WinUI 2 Gallery control commands in the SfSpreadsheet Ribbon instead of Syncfusion commands, please note that our support is specifically for Syncfusion controls in the SfSpreadsheet Ribbon, and we do not offer support for WinUI 2 Gallery controls.

If you need any assistance with Syncfusion controls, feel free to contact us. We're here to help!

Thank you for your understanding and cooperation.

 

Regards,
Malini Selvarasu

[Shompinice]

I may have expressed it wrongly. What I meant was to provide an example similar to https://www.syncfusion.com/downloads/support/forum/189333/ze/SfRichTextBoxAdv_UWP_c874748d

. The functions can be to modify the text format in excel, open and save as excel files

[Malini Selvarasu]

Hi Shompinice,

Thank you for the clarification. We understand that you need to utilize the Spreadsheet commands within the customized ribbon. We have created a simple sample that allows you to open and save Excel files in the code-behind, as well as use built-in commands for basic editing functions like applying bold, italic, and text alignment. We have attached it for your review. Please take a look and apply the commands according to your needs. Additionally, we have attached the API link that contains the available commands in SfSpreadsheet.

API Link: Namespace Syncfusion.UI.Xaml.Spreadsheet.Commands - UWP API Reference | Syncfusion

If we have misunderstood your requirements, kindly provide us with more details about your needs or the issue you are facing. This additional information will help us better understand the problem and proceed further to provide an appropriate solution.

Thank you for your cooperation.

Regards,

Malini Selvarasu

Attachment: Spreadsheet_Demo_5b871888.zip