Parsed teh merged Cell Area

Posted on 2011-10-17
Last Modified: 2012-05-12

 I have a requirement like(In Perl only )
I need to read certain value from a excel report (report is attached)
for example if I will pass my script COL LEVEL as   Internal  Attribution - Fnc:Short Benefit:Pending Realized

and ROW LEVEL as  Summery
Then the perl script should open the excel sheet ,Traverse the COL LEVEL and ROW LEVEL and take out the Value .
In my Case the Value would be -1665.9596.

Can anybody please please help to parse the value like in this way ?

Question by:SWAYAM4U
    LVL 19

    Expert Comment

    you are asking for help in getting perl to open an excel spreadsheet and search for a specific location and then read the value of the cell?
     - unless Perl has a set of file management options I am not aware of this is not possible without an external library to handle the open/extract part (you could handle it as a call to excel but that would involved excel being installed on the box where the perl is executing).

    I suppose you could try reading/interpreting the binary stream or make sure the supplied file is in XML format but even then I wouldn't trust the results.

    LVL 28

    Accepted Solution

    LVL 9

    Expert Comment

    by:Suhas .
    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now