Re: How to evaluate a mathematical formula that is stored in another file?

[thanos1983]

Hello skooma,

Welcome to the Monastery. From my point of view your code is copy paste from the package or a tutorial regarding the Spreadsheet::ParseXLSX. From your description you not doing anything that you describe.

So from my point of view in order as to help you is not about to solve it for you but guide you step by step to understand what happens. If I understand correctly you want to read the data from the excel sheet into a hash and then evaluate them with the *.txt file. If so did you try to print your hash to see what data you have inside? Hint Data::Dumper.

Let's assume that the data inside the hash is what you need to store, then you read line by line the text file, how do you compare the hash data with the lines?

Try to approach these minor problems before proceeding and I think you will solve it.

If you are still not able to resolve it, provide us sample of your input of both of the files and the expected output. We can not guess the data for you.

Hope this helps, BR.