首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >如何将div值转换为特定文件名和特定路径下的csv文件

如何将div值转换为特定文件名和特定路径下的csv文件
EN

Stack Overflow用户
提问于 2016-08-29 17:56:48
回答 1查看 202关注 0票数 0

我有一个由table组成的div元素。表值取自json数组,我必须创建一个新的数组行,它现在还显示在表中,使用导出按钮我必须在csv文件中以特定的文件名和特定的路径导出表值。导出:

代码语言:javascript
复制
$("#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:

代码语言:javascript
复制
<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>

使用某个导出按钮,每次在表中存储新记录时都应替换该文件

EN

回答 1

Stack Overflow用户

发布于 2016-08-29 18:04:27

我建议使用angular-file-saver包来保存文件。

更好的方法是直接遍历您的模型sushi,而不是通过生成的HTML.

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/39203402

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档