Home: Perl Programming Help: Win32 Programming Help:
writing to an open Excel file



bts974
New User

Sep 10, 2014, 1:35 AM


Views: 17618
writing to an open Excel file

Hi,

I write a script in Perl that create an Excel file and write a data to it.

the problem is that after the script is done working and I open the Excel file and try to re-run the script its give me an error message and just after I close the file its working.

what can I do to solve this problem?

Thanks!


Laurent_R
Veteran / Moderator

Sep 10, 2014, 10:50 AM


Views: 17613
Re: [bts974] writing to an open Excel file

Well, not sure to understand what you are doing. But if you open the file with Excel and try to run the script on the same file, then I would probably not expect it to work, as Excel is likely to lock the file it opens.

Also, when you ask such question, it would be good to give the content of the error message. That might help us to help you.