Pulling data from an Excel sheet

  • Hi all,

    I have an Excel sheet with 3k lines. It’s basically annual income at $100 increments and the amount of tax you have to pay at that income separated by tax types, like federal tax, state tax, social security, etc.

    I want an input field in the front-end where a user enters their income and WordPress pulls a corresponding line from the Excel sheet and displays their tax rate.

    Is there such a plugin? Please do let me know.

    Thank you.

    • This topic was modified 4 years, 6 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Developing with WordPress topic
Viewing 3 replies - 1 through 3 (of 3 total)

  • I doubt there is a plugin specifically for reading a matching value from an Excel spreadsheet.
    You have a few options.
    * compute the value when the user enters the number
    * show the data in an interactive chart
    * load the data in an easy to access format and look up the matching value
    * store the data in a file with fixed format, so the seek offset can be computer for fast lookup

    Since taxes change every year, you have to consider whether you want your page to change also, to keep up.
    The Excel format is not very easy to access, and it can contain macros, so it’s not very secure. Each line of your file is computed, so it could be computed in a plugin or a script on the page. A chart might give your user a better idea of the big picture. If you want to show taxes for different years, you could have different files.

    Thread Starter Bittabola

    (@bittabola)

    Thank you! Can you elaborate on ‘compute the value when the user enters the number’? Is there a plugin available?

    There are several plugins that perform calculations that you enter yourself:

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Pulling data from an Excel sheet’ is closed to new replies.