Read/Write CSV file

If unquoted text values are required then CommaTextStreamIo should be replaced with TextStreamIo, which has the same methods.

Read CSV file

        #File
        #OCCRetryCount
        #define.delimiterField(',')
        System.IO.MemoryStream  memoryStream = connector.getCurrentMemoryStream();
        CommaTextStreamIo       commaTextStreamIo = CommaTextStreamIo::constructForRead(memoryStream);
        if (commaTextStreamIo)
        {
            if (commaTextStreamIo.status())
            {
                throw error("@CLIDocuments:FileUpload_Failed");
            }

            commaTextStreamIo.inFieldDelimiter(#delimiterField);
            commaTextStreamIo.inRecordDelimiter(#delimiterCRLF);
                
            container       record;

            while (!commaTextStreamIo.status())
            {
                record = commaTextStreamIo.read();
            }
        }

Write CSV file

        CommaTextStreamIo       commaTextStreamIo = CommaTextStreamIo::constructForWrite();

        commaTextStreamIo.writeExp(['row 1 col 1', 'row 1 col 2']);
        commaTextStreamIo.writeExp(['row 2 col 1', 'row 2 col 2']);

        File::SendFileToUser(commaTextStreamIo.getStream(), 'file name.csv');
Result:


Support The Author

 If you found value in what I share, I've set up a Buy Me a Coffee page as a way to show your support.

Buy Me a Coffee

Post a Comment

   renew the code

All Comments

No comments. Be the first one to comment on this post.

Search

About

DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics 365 FO.

Authors are allowed to set their own "buy me a coffee" link.
Join us.

Blog Tags