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
kv79
-1
Posting Whiz in Training
Recommended Answers
Jump to PostYou 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.
All 3 Replies
Teme64
215
Veteran Poster
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.
Comatose
290
Taboo Programmer
Team Colleague
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.
kv79
-1
Posting Whiz in Training
Hi
Thanks for replaying.
Change DB to MySQL :).
Or Never keep Excel opened. LOL
I hope that you understand what I mean.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.