http://www.perlmonks.org?node_id=1054008


in reply to Excel Worksheets and Perl iThread

The original Thought was to gain time at creating a multi tabbed excel file , in which a each tab would be handled by a single thread using an explicit csv file.

Sorry to inform you, but that simply will never work.

You are creating an object in one thread and trying to use (a copy of) that object in another thread. Unless SpreadSheet::WriteExcel and all of its submodules, and all of their dependancies were written to be thread-safe, it would never work.

They aren't, and it won't.

With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.

Replies are listed 'Best First'.
Re^2: Excel Worksheets and Perl iThread
by KarlCiaran (Initiate) on Sep 13, 2013 at 21:03 UTC

    Thanks. I came across a similar message from one of the links I was reading some time ago. "... every time you start a thread all data structures are copied to the new thread. And when I say all, I mean all. This e.g. includes package stashes, global variables, lexicals in scope. Everything!"

[reply]
      Thanks. I came across a similar message

      Sorry, but that "message" is neither similar, nor relevant. Ignorance is bliss, and stupid is as stupid does.

      And if you make no attempt to understand the environment or tools you use ...

      With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
      Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
      "Science is about questioning the status quo. Questioning authority".
      In the absence of evidence, opinion is indistinguishable from prejudice.
[reply]

In Section Seekers of Perl Wisdom