gather data from xlxs file

Posted on 2012-09-20
Last Modified: 2012-09-20
file is

viewing using microsoft excel there are 3 columns and many rows
but using notepad or php ide text is not readable

want to use php to gather info from
3 columns
Question by:rgb192
    LVL 11

    Accepted Solution

    You can use a lib like phpExcel found here to open and manipulate.

    Alternativly convert to csv which is plain text and something php can consume quite easily
    LVL 36

    Assisted Solution

    by:Loganathan Natarajan
    if you want to view the data , try with Notepad++

    Author Closing Comment


    notepad++ still has unreadable output

    I used your suggestions for a followup question

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Upload PDF On Mobile 1 41
    Bing Maps 1 23
    Total days in a month 12 27
    phpMyAdmin simple sql statement 3 20
    Consider the following scenario: You are working on a website and make something great - something that lets the server work with information submitted by your users. This could be anything, from a simple guestbook to a e-Money solution. But what…
    I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
    Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
    The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

    755 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

    21 Experts available now in Live!

    Get 1:1 Help Now