Hi all

I made a program who open excel for adding files in excel.

I am asking you can for example 15 users uploading that single file ?


Thanks advance

You mean adding sheets to an existing Excel file, right?

Yes it's possible. But I think the Excel file will be "locked" to first user until he/she closes it. AFAIK multiple users writing to the same Excel simultaneously is not possible.

I Think Teme64's Right. Once Program copy 1 opens the file, I think the system locks it. I guess a solution around this, would be to have the program download a local copy, and work with it, then re-upload it.... but you are going to run into mad problems with keep things in order. I guess the way to do that would be, when they are finished working on it, the changes are submitted to some kind of server program, which waits for all copies that are opened to be closed. Then, it would check the timestamps of each uploaded file.... then it would have to basically modify one file, with any differences of the other, and do this for all the uploaded files, until you reach the one with the latest time stamp. Then, rename it to the main filename (after all changes were merged to it). What a mess that would be.

Hi
Thanks for replaying.
Change DB to MySQL :).
Or Never keep Excel opened. LOL

I hope that you understand what I mean.

This question has already been answered. Start a new discussion instead.