in reply to Re^4: data formatting in excel
in thread data formatting in excel

That's not a data structure - that's a file layout. A data structure would be an "array" or a "hash of hashes" or an "array of Foo::Bar objects".

Let me explain another way - your program is probably going to look something like:

  1. Open file
  2. Read file into some Perl variables
  3. Close file
  4. Do something with those Perl variables
  5. End

Those "Perl variables" are your data structure. Depending on what you want to do with the data in the file, your data structure is going to be different. For instance

And, that's just the three examples I could come up with 30 minutes after waking up. Depending on the use, the data structure is completely different while the file layout remains unchanged.

My criteria for good software:
  1. Does it work?
  2. Can someone else come in, make a change, and be reasonably certain no bugs were introduced?