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
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
Thanks Steve for the reply,
I solved import excel issue using HTML Bridge.
Is there any work around for 2nd issue i.e export to excel: open in excel instead of saving it. ?
Unfortunately unless your running out of browser with full trust, no there is no workaround for this.
If you can run out of browser with full trust you can use COM interop to launch excel with the file.
Devin