Trying to make an application that reads/writes excel files

**vmustang** · Feb 9, 2013 15:39

I have used the free applications jquery Tablesorter and jquery DataTables and am open to alternative ideas, but I really like the layout of both of these programs. I just need help in finishing this. This has been a HUGE problem for me, so I will be very thankful to anyone who can help me out.

jquery DataTables

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
	<head>
		<meta http-equiv="content-type" content="text/html; charset=utf-8" />
		<link rel="shortcut icon" type="image/ico" href="http://www.datatables.net/favicon.ico" />
		
		<title>DataTables example</title>
		<style type="text/css" title="currentStyle">
			@import "../../media/css/demo_page.css";
			@import "../../media/css/jquery.dataTables.css";
		</style>
		<script type="text/javascript" language="javascript" src="../../media/js/jquery.js"></script>
		<script type="text/javascript" src="res/csvToTable.js"></script>
		<script type="text/javascript" language="javascript" src="../../media/js/jquery.dataTables.js"></script>
		<script type="text/javascript" charset="utf-8">
			$(function() {
	$('#CSVTable').CSVToTable('data/orders.csv', {  
			loadingImage: 'res/theme/loading.gif',  
			startLine: 1, 
			tableClass: "dataTable",
			headers: ['name', 'number', 'product', 'order']
		}).bind("loadComplete",function() { 
			$("#CSVTable .dataTable tr").each(function(i,row) { 
				var column = (i>0)?"<td><input type='checkbox' class='removeRow' /></td>":"<th>&nbsp;</th>";
				$(this).prepend(column);
			});
			$("input:checkbox.removeRow").bind("click", function(){ 
				$(this).closest("tr").remove();
	$('#CSVTable').dataTable( { 
"bProcessing": true, 
"bDeferRender": true
} );			
});
		});
	});  
		</script>
	</head>
	<body id="dt_example">
		<div id="container">
			<div class="full_width big">
				DataTables base example
			</div>
			
			<h1>Live example</h1>
			<div id="demo">
<div id="CSVTable">
	</body>
</html>

jquery Tablesorter

Code:

<!-- The above line is necessary to allow local JavaScript --!>
<!DOCTYPE html>
<html>





<head>
<title>Workable: All</title>
<link rel="stylesheet" href="res/default.css" type="text/css" media="print, projection, screen" />
<link rel="stylesheet" href="res/theme/style.css" type="text/css" media="print, projection, screen" />

<script type="text/javascript" src="res/jquery-1.7.2.js"></script>
<script type="text/javascript" src="res/csvToTable.js"></script>
<script type="text/javascript" src="res/tablesort.min.js"></script>
<script type="text/javascript" src="res/tablesort.ie.js"></script>
<script type="text/javascript">
	$(function() {
		$('#CSVTable').CSVToTable('data/test.csv', {  
	       		loadingImage: 'res/theme/loading.gif',  
			startLine: 1, 
			tableClass: "tablesorter",
			headers: ['Album Title', 'Artist Name', 'Price ($USD)'] 
		})}).bind("loadComplete",function() { $('#CSVTable').find('TABLE').tablesorter({sortList:[[3,0],[9,0]], widgets: ['zebra']}); 
	});
	$("tr input:checkbox").live("click", function(){ $(this).closest("tr").remove() });
</script>
</head>
<body>
<div id="banner">	
	<h1>Book Report</em></h1>
	<h2>Wednesday, August 22, 2012</h2>
	<h3>Love books, Love Life</h3>
	<a href="#"></a>
</div>

<table id="nav" class="nav" border="0" cellpadding="0" cellspacing="1" width="100%">
<thead></thead>
<tbody>
<tr>
	<td>
	<p>
	  <a href="teamview.html">Overview</a> | 
	  <a href="index.html">Main</a> |
	  <a href="all.html">All</a> |
	  <a href="cit.html">Tasks</a> |
	  <a href="ag.html">Other 1</a> |
	  <a href="daar.html">Other 2</a> |
	</td>
	<td>
	<p> DNR Orders  |  Inactive Orders  |  Total Orders </p>
	</td>
	<td align="right">
		</td>
</tr>
</tbody>
</table>

</br>

<a name="gene"></a>
<h1>All</h1>
<div id="CSVTable">

</div>


</body>
</html>

**Pullo** · Feb 15, 2013 01:17

Hi there,

So what exactly are you having trouble with?
If you could tell us a bit more about what you are trying to accomplish, what you have tried and what isn't working, we'll be in a better position to help.

**vmustang** · Mar 29, 2013 08:02

I am looking for a way to save it and for users to checkbox it

**Pullo** · Mar 29, 2013 08:30

Originally Posted by vmustang

I am looking for a way to save it

Are you doing this in the browser?
If so, client-side javascript doesn't have permission to write to the client machine as it would be a security risk.
There are some workarounds out there, but this is going to be problematic.

Originally Posted by vmustang

and for users to checkbox it

I don't understand this.

**vmustang** · Mar 29, 2013 08:46

What I have now is a jquery datatable using Jquery datatables and also using jquery tablesorter. They are not used together. I just have it setup for both. So basically it is a datatable with a checkbox field on the 1st column. I have it working now so it removes it from the datatable but I need some way to report this back. please see the below two links, as I believe this may help resolve my 6 month long issue

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

**Pullo** · Mar 29, 2013 08:50

Both of those require Java, of which I have zero knowledge, so I'll refrain from commenting further in the hope that someone else here has an idea how this might work.
Good luck!

User Tag List

Thread: Trying to make an application that reads/writes excel files

Thread Tools

Display

Trying to make an application that reads/writes excel files

Bookmarks

Bookmarks

Posting Permissions