CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2013
    Posts
    3

    java/jquery with excel help

    I would like to take data from excel and show it in Internet Explorer or Java or Jave with IE. If in IE the preferred method to use is jquery datatables or jquery tablesorter. In other words, that data from excel would be shown in datatable or spreadsheet view. The data I would like to have saved is what rows are checkboxed and what are not. After the rows are checkboxed they should be removed, but should be on a "completed" page. The problem is with saving the results and also with data storage for reporting purposes as this is clientside.with no web server interaction. However, once the data is stored locally, the charts/reports can be made then. I have been told as to look into Jave Webstart or Apache POI.

    http://jquery.tiddlywiki.org/twFile.html
    code.google.com/p/yoplet/

  2. #2
    Join Date
    May 2002
    Posts
    10,943

    Re: java/jquery with excel help

    What programming experience do you have? You are going to need some heavy JavaScripting (if using IE) or Java (if using JavaWS) in order to get this project done.
    If the post was helpful...Rate it! Remember to use [code] or [php] tags.

  3. #3
    Join Date
    Mar 2013
    Posts
    3

    Re: java/jquery with excel help

    true, the exception woudl be yoplet, a free application that allows users to read/write back to the local file, but I dont know how to mod this into jquery tablesorter

  4. #4
    Join Date
    Jun 2009
    Posts
    113

    Re: java/jquery with excel help

    I'm afraid I know nothing about "yoplet" but if you want to use tablesorter - or virtually any other jQuery table based plug in - you're going to need to convert the Excel data into HTML table based data. Can yoplet do that? If so then create a THEAD row and populate it with TH cells, then everything else into TD cells in a TBODY. That would get you the display of the data. As for writing the data back, you would then need to use jQuery to detect the changed / checkboxes (something like
    Code:
    $('input[type=checkbox]:checked')
    and then convert that back into Excel format. Can't help with the latter part I'm afraid, but maybe one of those other tools you mentioned has that capability.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured