我有一个由table组成的div元素。表值取自json数组,我必须创建一个新的数组行,它现在还显示在表中,使用导出按钮我必须在csv文件中以特定的文件名和特定的路径导出表值。导出:
$("#export").click(function(e) {
alert('inside export method');
var a = document.createElement('a');
//getting data from our div that contains the HTML table
var data_type = 'data:application/vnd.ms-excel';
var table_div = document.getElementById('exportdata');
var table_html = table_div.outerHTML.replace(/ /g, '%20');
alert(table_html);
a.href = data_type + ', ' + table_html;
//setting the file name
alert("pname"+pname);
a.download = 'export.xls';
alert('after got a id');
//triggering the function
a.click();
//just in case, prevent default behaviour
e.preventDefault();
}); 这是一个用于xls的代码,但我必须将值存储在csv文件中,并且名称必须具体,每次导出值时都应在与最后一行相同的文件中更新。
html:
<div id="exportdata">
<table class="table table-bordered table-striped tablelink">
<thead>
<tr>
<td>
<a href="#" ng-click="sortType = 'issueno'; sortReverse = !sortReverse">
ISSUE NO
<span ng-show="sortType == 'issueno' && !sortReverse" class="fa fa-caret-down"></span>
<span ng-show="sortType == 'issueno' && sortReverse" class="fa fa-caret-up"></span>
</a>
</td>
<td>
<a href="#" ng-click="sortType = 'dateassigned'; sortReverse = !sortReverse">
DATE ASSIGNED
<span ng-show="sortType == 'dateassigned' && !sortReverse" class="fa fa-caret-down"></span>
<span ng-show="sortType == 'dateassigned' && sortReverse" class="fa fa-caret-up"></span>
</a>
</td>
<td>
<a href="#" ng-click="sortType = 'assignedby'; sortReverse = !sortReverse">
ASSIGNEDBY
<span ng-show="sortType == 'assignedby' && !sortReverse" class="fa fa-caret-down"></span>
<span ng-show="sortType == 'assignedby' && sortReverse" class="fa fa-caret-up"></span>
</a>
</td>
<td>
<a href="#" ng-click="sortType = 'issuetype'; sortReverse = !sortReverse">
ISSUE TYPE
<span ng-show="sortType == 'issuetype' && !sortReverse" class="fa fa-caret-down"></span>
<span ng-show="sortType == 'issuetype' && sortReverse" class="fa fa-caret-up"></span>
</a>
</td>
<td>
<a href="#" ng-click="sortType = 'priority'; sortReverse = !sortReverse">
PRIORITY
<span ng-show="sortType == 'priority' && !sortReverse" class="fa fa-caret-down"></span>
<span ng-show="sortType == 'priority' && sortReverse" class="fa fa-caret-up"></span>
</a>
</td>
<td>
<a href="#" ng-click="sortType = 'targetdate'; sortReverse = !sortReverse">
TARGET DATE
<span ng-show="sortType == 'targetdate' && !sortReverse" class="fa fa-caret-down"></span>
<span ng-show="sortType == 'targetdate' && sortReverse" class="fa fa-caret-up"></span>
</a>
</td>
<td>
<a href="#" ng-click="sortType = 'status'; sortReverse = !sortReverse">
STATUS
<span ng-show="sortType == 'status' && !sortReverse" class="fa fa-caret-down"></span>
<span ng-show="sortType == 'status' && sortReverse" class="fa fa-caret-up"></span>
</a>
</td>
<td>
<a href="#" ng-click="sortType = 'attachment'; sortReverse = !sortReverse">
ATTACHMENT
<span ng-show="sortType == 'attachment' && !sortReverse" class="fa fa-caret-down"></span>
<span ng-show="sortType == 'attachment' && sortReverse" class="fa fa-caret-up"></span>
</a>
</td>
<td style='visibility:hidden'>
<a href="#" ng-click="sortType = 'description'; sortReverse = !sortReverse">
DESCRIPTION
<span ng-show="sortType == 'description' && !sortReverse" class="fa fa-caret-down"></span>
<span ng-show="sortType == 'description' && sortReverse" class="fa fa-caret-up"></span>
</a>
</td>
</tr>
</thead>
<tbody>
<tr ng-repeat="roll in sushi | orderBy:sortType:sortReverse | filter:searchcon">
<td ng-click="display(roll.issueno);"><a href="#">{{ roll.issueno }}</a></td>
<td>{{ roll.dateassigned }}</td>
<td>{{ roll.assignedby }}</td>
<td>{{ roll.issuetype}}</td>
<td>{{ roll.priority}}</td>
<td>{{ roll.targetdate}}</td>
<td>{{ roll.status}}</td>
<td>{{ roll.attachment}}</td>
<td style='visibility:hidden'>{{roll.description}}</td>
</tr>
<tr id="newr">
</tr>
</tbody>使用某个导出按钮,每次在表中存储新记录时都应替换该文件
发布于 2016-08-29 18:04:27
我建议使用angular-file-saver包来保存文件。
更好的方法是直接遍历您的模型sushi,而不是通过生成的HTML.
https://stackoverflow.com/questions/39203402
复制相似问题