[Excel Package] Adding more function to check if the cell is locked or not.

[Excel Package] Adding more function to check if the cell is locked or not.

  
Forge Component
(4)
Published on 2 Aug by Carlos Alfaro
4 votes
Published on 2 Aug by Carlos Alfaro

Hi there,

Could we have another function like checking of the given cell is locked or not. 

Use case: we need to check the cell if it's locked or not. If it's locked, we will not write data to that cell. If it's not locked, we will write data to that cell.

For now, I can see it's written although it's locked or not.

Thanks,

Thang Nguyen

Hi Thang,


This is something easy do add with Integration Studio, while it is not supported by the component team:


I've added this to the extension and a demo application (check the attachment).


Cheers,

Renato


Thang Nguyen wrote:

Hi there,

Could we have another function like checking of the given cell is locked or not. 

Use case: we need to check the cell if it's locked or not. If it's locked, we will not write data to that cell. If it's not locked, we will write data to that cell.

For now, I can see it's written although it's locked or not.

Thanks,

Thang Nguyen



Hi Renato,

Thanks for your information. How do you think if we can have it on the next version of Excel_Package. Then we will not need to do manual update for the new version of Excel_Package. This is just an idea.

Thanks,

Thang Nguyen