Disable data edit in cell or column in excel export

Mark Wieffer

Solved

Question

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!

11 May 2017

António Pereira

Champion

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

11 May 2017

1 reply

15 May 2017

Show thread

Hide thread

Mark Wieffer

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

15 May 2017

Andrew Sole

Have read in the Advanced Excel tools documentation that finer-grain protection is available.

08 Nov 2019

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.