public void exportCSV(str _filename)
    {
        CommaStreamIo io = CommaStreamIo::constructForWrite();
        str filename = strFmt('%1.csv', _filename);
        
        SalesTable salesTable;

        //write the header
        io.writeExp(['SalesId','DlvMode']);
        
        while select salesTable
            where salesTable.DataAreaId = curExt()
        {
            io.writeExp([SalesTable.salesId, SalesTable.DlvMode]);
        }

        //Get the stream
        System.IO.Stream stream = io.getStream();
        stream.Position = 0 ;

        //StreamReader to read as str
        System.IO.StreamReader reader = new System.IO.StreamReader(stream);
        str csvFileContent = reader.ReadToEnd();

        //save file
        File::SendStringAsFileToUser(csvFileContent, filename);

    }

arrow
arrow
    文章標籤
    dynamic AX D365 Export CSV
    全站熱搜

    lionlionchopper 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄