普通网友 2016-08-10 12:46
浏览 32

如何使用PHP将HTML内容保存并加载到文件中

I have a modal which contain table and have a save setup button and load setup button, When I click on save button the table content should be saved in a file in any folder in any format and by clicking on load button it should able to load that file in the HTML format.

So how can I do this?

below is the code for Modal

<div class="modal fade" id="envVarModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
        <h4 class="modal-title" id="myModalLabel" style="text-align:center">Environment Variable Settings</h4>
      </div>
      <div class="modal-body" id="envVarModalBodyID">
        <label>Env Variable:</label>
        <select  id="envVarID" name="Select2" onchange="addEnvVar()">
            <option value="nothingSelected">Select Env Variable</option>
            <option value="Count">Count</option>
            <option value="Schedule">Schedule</option>

        </select>
        <table><tr><td>A</td><td>B</td></tr><tr><td>One</td><td>Two</td></tr><tr><td>Three</td><td>Four</td></tr></table>"
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-default" data-dismiss="modal">Save Setup</button>
        <button type="button" class="btn btn-primary">Load Setup</button>
      </div>
    </div>
  </div>
</div>
  • 写回答

1条回答 默认 最新

  • douwuying4709 2016-08-10 12:54
    关注

    Use this javascript to save the table in .xls format.I have added on click event to your button

    btn btn-default class where you have to make the table contain in <div id="table1">your table structure</div>

    <script>
    
        var tableToExcel = (function() {
          var uri = 'data:application/vnd.ms-excel;base64,'
            , template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--><meta http-equiv="content-type" content="text/plain; charset=UTF-8"/></head><body><table>{table}</table></body></html>'
            , base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }
            , format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }
          return function(table, name) {
            if (!table.nodeType) table = document.getElementById(table)
            var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}
            window.location.href = uri + base64(format(template, ctx))
          }
        })()
        </script>
    
    
    
        <button type="button" class="btn btn-default" data-dismiss="modal" onclick="tableToExcel('table1', 'W3C Example Table')" value="Export to Excel">
    
    评论

报告相同问题?

悬赏问题

  • ¥100 set_link_state
  • ¥15 虚幻5 UE美术毛发渲染
  • ¥15 CVRP 图论 物流运输优化
  • ¥15 Tableau online 嵌入ppt失败
  • ¥100 支付宝网页转账系统不识别账号
  • ¥15 基于单片机的靶位控制系统
  • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
  • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
  • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
  • ¥15 手机接入宽带网线,如何释放宽带全部速度