Jump to content
Sign in to follow this  
Mudsaf

JavaScript/jQuery reading excel sheet columns

Recommended Posts

Hello, im trying to make javascript/jquery code that will read excel file so i can paste it to listbox and make some functions.It should be like this DEMO 7, but with excel data and not php

http://kotowicz.net/jquery-option-tree/demo/demo.html

Here is one example also but mine needs more functionality not just writing all data to javascript, because i have 5000 lines in my excel file.

http://www.mol.fi/paikat/

Share this post


Link to post
Share on other sites

If the file is in XML format, you should probably use AJAX. Then navigate the DOM document using DOM methods. Populate your document dynamically. My experience is that 5000 lines can be a little slow on older machines.

Share this post


Link to post
Share on other sites

Is it possible to read .csv or .xlsx file trough javascript/jQuery. My workplace wanted the 5000 lines so i guess the slow on older machines doesn't matter. Also they told that it should be done with javascript/jquery functions to get data. +NO PHP Example...Excel file data

0 | Item101 | Item1 Subcategory02 | Item1 Subcategory001 | Item1 Subcategory subcategory1 | Item210 | Item2 Subcategory

And all Items in first category would go to first listbox and when clicking the item it would show the subcategories in second box.

Share this post


Link to post
Share on other sites
If the file is in XML format, you should probably use AJAX. Then navigate the DOM document using DOM methods. Populate your document dynamically. My experience is that 5000 lines can be a little slow on older machines.
You were right the 5000 lines might be too much, thx for help anyways :D

Share this post


Link to post
Share on other sites

CSV will transmit just like text, and then JavaScript can break break it up very easily. Also, it's less bandwidth crazy than XML. But yeah, 5000 lines . . .

Share this post


Link to post
Share on other sites

Got this done by converting the excel file on json array's and works in no-time.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...