Hello,

You can export your grid data to a read only excel file by creating a workbook and a worksheet and setting the Protected property off of the worksheet to true. I attached a sample demonstrating this. Here is the code snippet that I used:           

      String[] arrStore = new string[] { "one", "two", "three" };

      this.ultraGrid1.DataSource = arrStore;            

      Workbook exportWorkbook = new Workbook();      

      Worksheet exportWorksheet = exportWorkbook.Worksheets.Add("Export");

      //Set workbook or specific worksheet to be read only.            

      exportWorkbook.Protected = true;         
      exportWorksheet.Protected = true;            

      this.ultraGridExcelExporter1.Export(this.ultraGrid1, exportWorksheet);      
      exportWorkbook.Save("C:\\GridData.xls");     

Michael DiFilippo said:

Hello,

You can export your grid data to a read only excel file by creating a workbook and a worksheet and setting the Protected property off of the worksheet to true. I attached a sample demonstrating this. Here is the code snippet that I used:           

 

      String[] arrStore = new string[] { "one", "two", "three" };

      this.ultraGrid1.DataSource = arrStore;            

      Workbook exportWorkbook = new Workbook();      

      Worksheet exportWorksheet = exportWorkbook.Worksheets.Add("Export");

 

      //Set workbook or specific worksheet to be read only.            

      exportWorkbook.Protected = true;         
      exportWorksheet.Protected = true;            

      this.ultraGridExcelExporter1.Export(this.ultraGrid1, exportWorksheet);      
      exportWorkbook.Save("C:\\GridData.xls");     

 

Thank you, it works, but I have another question :-)

Now everybody can remove the protection opening the file with Excel (menu Revision -> remove protection): is it possible to set a password to avoid this?

Hello,

You can use the method : SetFileWriteProtectionPassword of the Workbook

Ex. exportWorkbook.SetFileWriteProtectionPassword("yourPassword");

Hello,

Workbook and Worksheet protection support was added in 15.1. The latest volume release will also maintain this support.

I strongly recommend reading more about this on our online help page:
http://help.infragistics.com/doc/WPF/2016.1/CLR4.0/?page=Whats_New_in_2015_Volume_1.html

Let me know if you have any questions regarding this matter or need assistance installing the latest volume.

hai,

 I have infragistics 14.1 version. i need to set password for workSheet. It's Available in this version? or which version is may i download?

Michael DiFilippo said:

Hello,

You can use the method : SetFileWriteProtectionPassword of the Workbook

Ex. exportWorkbook.SetFileWriteProtectionPassword("yourPassword");

 

I cannot find the method "SetFileWriteProtectionPassword": I'm using Infragistics 10.3: is it a new feature?

Thank you