Writing data to open Excel file

Android1 · January 20, 2019, 1:38am

Good evening!
Can you please tell me, can I, with the the library Aspose, write some data to an already open excel file?

I tried to do it - as indicated in the example), but an error occurs, that is, the Excel cannot be written and saved in an open file.

Is it possible ?

ahsaniqbalsidiqui · January 20, 2019, 7:55am

@Android1,

Thanks for your query.

Aspose.Cells behaves differently than Interop and does not allow to write/save in an opened Excel file. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Android1 · January 20, 2019, 8:42am

Hello,
Thank you!

amjad.sahi · January 20, 2019, 1:43pm

@Android1,

I think you may easily cope with it using any of the following options

Close the opened file (which is opened in Ms Excel manually).
Save the Excel file with different name in code using Aspose.Cells APIs.

Hope, this helps.

Android1 · January 20, 2019, 2:02pm

Unfortunately, this is not very convenient. This file is used by another person.
Unfortunately will have to use Qt library.

ahsaniqbalsidiqui · January 20, 2019, 2:48pm

@Android1,

Thank you for the feedback and we are sorry for the inconvenience caused to you in this regard.

painetim · January 22, 2019, 7:07am

The following part which will be getting the part that convenient to use the qt library that enable the writing data to open excel file which can’t load xpcom inconvenience that caused to the regard.

ahsaniqbalsidiqui · January 22, 2019, 8:06am

@painetim,

Could you please elaborate if you encounter any issue with Aspose.Cells API. We will be glad to look into it and help you further.