Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
kamesh
510
XamGrid: Import/Export issues
posted

Hi,

We are using XamGrid 10.3, We've few issues with import and export excel.

1. When I import excel sheet to Xamgrid, it is working fine, but I had to close the excel file when it is already open in "Excel", but users don't want to close it, is there any way to read the file when it is opened in excel?

sample code I used: Workbook.load(stream)

2. When I export to excel, I'm showing save dialog and saving it to a location, which is forcing the user to save the file to export to excel, is there any way to directly show the output in excel when they export instead of saving the file?

sample code I used: Workbook.save(stream)

regards,

kthatik1

Parents
No Data
Reply
  • 40030
    Offline posted

    Hi, 

    Sorry, for the delayed response, i wanted to verify with developer of the excel library before i answered.

    So, basically these are limitations of what we can do with Excel. We simply open the file with read permissions, however, excel locks the file, which is why the users must close it first. 

    As for the other option, again, excel won't let us try to pass the stream directly to it, so we have to save the file. 

    -SteveZ

Children