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 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");