第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

為了賬號安全，請及時綁定郵箱和手機(jī)立即綁定
已解決430363個問題，去搜搜看，總會有你想問的

如何從jsgrid數(shù)據(jù)制作一個csv文件

如何從jsgrid數(shù)據(jù)制作一個csv文件

萬千封印 2021-12-02 15:36:55
我有一個 jsgrid 表，其中包含來自 mysql 的數(shù)據(jù)。我想從我過濾的數(shù)據(jù)中制作一個 csv（或其他東西）。我怎么能做到這一點。我發(fā)現(xiàn)這樣的事情：var csv = $("#grid").jsGrid("exportData", {    type: "csv", //Only CSV supported    subset: "all" | "visible", //Visible will only output the currently displayed page    delimiter: "|", //If using csv, the character to seperate fields    includeHeaders: true, //Include header row in output    encapsulate: true, //Surround each field with qoutation marks; needed for some systems    newline: "\r\n", //Newline character to use    //Takes each item and returns true if it should be included in output.    //Executed only on the records within the given subset above.    filter: function(item){return true},    //Transformations are a way to modify the display value of the output.    //Provide a key of the field name, and a function that takes the current value.    transformations: {        "Married": function(value){            if (value === true)                return "Yes"            if (value !== false)                return "No"        }    }});如何從這個變量制作文件？
查看完整描述

1 回答

?
莫回?zé)o

TA貢獻(xiàn)1865條經(jīng)驗 獲得超7個贊

您可以將數(shù)據(jù)保存在數(shù)組中，然后使用此函數(shù)。


function JSONToCSVConvertor(JSONData, Label, ShowLabel) {

    //If JSONData is not an object then JSON.parse will parse the JSON string in an Object

    var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData;

    var CSV = '';

    //Set Report title in first row or line

    CSV += Label + '\r\n\n';

    //This condition will generate the Label/Header

    if (ShowLabel) {

        var row = "";

        //This loop will extract the label from 1st index of on array

        for (var index in arrData[0]) {

            //Now convert each value to string and comma-seprated

            row += index + ',';


        }

        row = row.slice(0, -1);

        //append Label row with line break

        CSV += row + '\r\n';

    }

    //1st loop is to extract each row

    for (var i = 0; i < arrData.length; i++) {

        var row = "";

        //2nd loop will extract each column and convert it in string comma-seprated

        for (var index in arrData[i]) {


            row += '"' + arrData[i][index] + '",';


        }

        row.slice(0, row.length - 1);

        //add a line break after each row

        CSV += row + '\r\n';

    }

    if (CSV == '') {

        alert("Invalid data");

        return;

    }

    //Generate a file name

    var fileName = "FileTitle";


    //Initialize file format you want csv or xls

    var uri = 'data:text/csv;charset=utf-8,' + escape(CSV);

    //alert(uri);

    // Now the little tricky part.

    // you can use either>> window.open(uri);

    // but this will not work in some browsers

    // or you will not get the correct file extension

    //this trick will generate a temp <a /> tag

    var link = document.createElement("a");

    link.href = URL.createObjectURL(new Blob([CSV], { type: "application/octet-stream" })); //added to fix network error problem in chrome

    //set the visibility hidden so it will not effect on your web-layout

    link.style = "visibility:hidden";

    link.download = fileName + ".csv";

    //this part will append the anchor tag and remove it after automatic click

    document.body.appendChild(link);

    link.click();

    // document.body.removeChild(link);

}


查看完整回答
反對 回復(fù) 2021-12-02
  • 1 回答
  • 0 關(guān)注
  • 199 瀏覽
慕課專欄
更多

添加回答

舉報

0/150
提交
取消
微信客服

購課補(bǔ)貼
聯(lián)系客服咨詢優(yōu)惠詳情

 幫助反饋 APP下載

慕課網(wǎng)APP
您的移動學(xué)習(xí)伙伴

 公眾號

掃描二維碼
關(guān)注慕課網(wǎng)微信公眾號