Get data from opened and edited file

[Kristina Ilic]

Hi,

In my spreadsheet user will open file and maybe make some changes. How can I get that data from opened file and  data from opened file after editing (in case that happened)?

Also, why I get 2 horizontal scrolls and vertical is missing? I did the same like in first example here https://ej2.syncfusion.com/angular/documentation/spreadsheet/open-save/#open-and-save

Best regards,

Kristina

[Janakiraman Sakthivel]

Hi Kristina Ilic, 

 

Thank you for contacting Syncfusion support. 

 

Query1: How can I get that data from opened file and  data from opened file after editing? 

  

We have checked your reported requirement and it can be achievable in our spreadsheet by using the getData method as like as below. 

 

Code Example: 

 

btnClick() { 

    var sheet = this.spreadSheetInstance.getActiveSheet(); 

    var activeSheetName = sheet.name; 

    var usedRange = activeSheetName + "!" + getRangeAddress([0, 0, sheet.usedRange.rowIndex, sheet.usedRange.colIndex]); 

        this.spreadSheetInstance.getData(usedRange).then(data => console.log(data));  

  } 

 

 

For your convenience, we have prepared the sample based on our suggestion. Please find the link below. 

 

Sample Link: https://www.syncfusion.com/downloads/support/forum/170507/ze/spreadsheet433840794 

 

Documentation Link: https://ej2.syncfusion.com/angular/documentation/api/spreadsheet/#getdata 

 

Query2: Also, why I get 2 horizontal scrolls and vertical is missing? 

 

On our side, our spreadsheet component rendered properly in our latest version (19.3.0.53). For your convenience, we have prepared the video demonstration of this. Please find the link below. 

 

Video link: https://www.syncfusion.com/downloads/support/forum/170507/ze/spreadsheet-getdata1539447196 

 

Could you please check the above links and get back to us, if you need any further assistance on this. 

 

Regards,  

Janakiraman S.  

[Kristina Ilic]

Hi  Janakiraman, 

thank you for your answer. Now I have data, so Question 1 is closed. But for some reason I still have the same problems with scrollbars. This is how my spreadsheet looks like:   

Best regards,

Kristina 

[Janakiraman Sakthivel]

Hi Kristina Ilic, 

  

We have checked your reported issue with your provided details and we are unable to reproduce it on our side. And we see you are using the class name "position-relative mt-4" for the spreadsheet parent element, so we suspect you made the CSS changes on your end according to the class name. So, we suspect this may be the cause of the reported issue. For your convenience, we have prepared the sample based on your provided details. Please see the link below. 

 

Sample Link: https://www.syncfusion.com/downloads/support/forum/170507/ze/spreadsheet-874647711 

 

So please share us the following details to proceed further. 

 

1. Please share the element level CSS customization codes. 

 

2. Please share the codes, if you have done any customization in sample level. 

 

3. If possible, please share the issue replicable sample with us or please replicate your issue in the above sample and send back to us. 

 

Could you please get back to us with the above requested information, based on that we will check and provide you a better solution quickly. 

 

Regards,  

Janakiraman S.