Disable data edit in cell or column in excel export

Disable data edit in cell or column in excel export

  

Hi Guys,


When creating an Excel export, is it possible to disable/prevent certain cells or columns from the data in it to be edited?


Thanks!

Solution

Hi Mark,

I think that's not possible using the default export node.

Did you check Forge? I've found these two components: Advance Excel and OfficeUtils.

Regards,

António Pereira

Solution

António Pereira wrote:

Hi Mark,

I think that's not possible using the default export node.

Did you check Forge? I've found these two components: Advance Excel and OfficeUtils.

Regards,

António Pereira

Thanks Antonio,


I've checked the forge (both Advanced Excel and ExcelReport)


Been getting a lot of work done using the ExcelReport. Unfortunately not the part my post was about. 


When I apply worksheet security and block out certain cells in the Excel Template the output has all fields disabled. 

Cannot seem to get this working this far. 


Thanks for the advice nevertheless!


Kr,


Mark