in reply to Data Structures Help

Thankyou all for your great advise and examples. (Wow). I have been trying to modify the examples to allow me to export the results to Microsoft Excel. I am trying to access each of the hash keys to allow me to place them into its own cell. How can I use one of the above examples to allow me to do the following.

$worksheet->Cells($count,1)->{Value} = "$location";

$worksheet->Cells($count,1)->{Value} = "$width";

$worksheet->Cells($count,2)->{Value} = "$height";

$worksheet->Cells($count,3)->{Value} = "$quantity";

etc


In addition, I am also wanting to specify a type of film used with a given location

I was thinking that I could use tab spacing between the location name and the film type

For example the text file will look like this


office 3 \t safetyfilm

100 120

100 120

135 125

bedroom 1 \t windowtint

125 125

125 125


Then i would also export the film type into Excel

$worksheet->Cells($count,2)->{Value} = "$film";

Or should i place the type of film into the text file another way

Thankyou all again

Thankyou again for all your wisdom

Replies are listed 'Best First'.
Re^2: Data Structures Help
by paulbort (Hermit) on Nov 01, 2004 at 18:19 UTC
    Why not just make the film another entry in the subhash? for example:

    Office 1 Film => 'something', '120 100' => 2 etc.


    Then you have one per location, and you can easily separate it from the dimension counts by name.

    --
    Spring: Forces, Coiled Again!