Get Cell Value

[Umair Ahmed]

Hi,

Can you please provide a sample to get the cell value after user clicks on a particular cell, there seems to be an event called "oncellclick" but looks like its not working in angular.

Thanks 

[Arunkumar Devendiran]

Hi Umair Ahmed, 

 

We have checked your reported query and you can achieve this by using getData method in select event. We have created the sample for your reference in that we have logged the selected cell value in the console. Please refer the below sample link, 

 

Sample link: 

https://stackblitz.com/edit/angular-c38wkf-9t3usr?file=app.component.ts 

 

Regards, 

Arunkumar D 

[Umair Ahmed]

Thanks Arunkumar, that worked but if I try assign the cell some value it doesn't refreshes on the grid, one of the requirements is to open an existing excel file, read data from every row and cell, make changes and display it on the grid.

[Madhan Venkateshan]

Hi Umair, 

 

Good day to you. 

 

We would like to suggest you to use beforeCellRender event to read data for every cell before the creation of cell, you can modify the cell value using updateCell method, but using the updateCell method inside beforeCellRender event have some issues as of now but it is a known issue in our end and we will include the fix for this issue in Volume 4 release which will be available in the mid of December month 2019 and appreciate your patience until then. 

 

Regards, 

Madhan V 

[Umair Ahmed]

Hi,

Any updates on this ? if its fixed, please share a sample of updateCell method inside beforeCellRender. 

Thanks.

[Madhan Venkateshan]

Hi Umair, 

 

Sorry for the inconvenience caused. 

 

We are facing more complexity while fixing the reported issue, so we are not able to include the fix in the Volume 4 release. We will include the fix in the second week patch release of January 2020 and appreciate your patience until then. 

 

Regards, 

Madhan V