Friday, November 14, 2025

Code to read CSV file from local folder in D365F&O X++

public static void main(Args _args)

{

   AsciiStreamIo                       file;

   Array                               fileLines;

   FileUploadTemporaryStorageResult    fileUpload;

   #File

   System.IO.FileStream    fileStream;

   System.IO.Stream        fileContentStream;

   System.IO.Stream        stream;

   System.String           filePath = @"C:\Temp\Vendor.csv"; //specify the file path

   fileStream = new System.IO.FileStream(filePath, System.IO.FileMode::Open, System.IO.FileAccess::Read);

   stream = fileStream;

 

   file = AsciiStreamIo::constructForRead(stream);

   if (file)

   {

       if (file.status())

       {

           throw error("@SYS52680");

       }

       file.inFieldDelimiter('|');

       file.inRecordDelimiter('\r\n');

   }

   container record;

   while (!file.status())

   {

       record = file.read();

       if (conLen(record))

       {

           info(strFmt("%1 - %2",conPeek(record,1),conPeek(record,2)));

       }

   }

}

Output :










No comments:

Post a Comment