Dynamics 365 how to import CSV and Excel file using visual studio?

(0) Share

Report

Posted on by Abdo Khoury

14,855

Dear

In AX 2012 we used to use following code to import a CSV file using the TextIO.read() method and then use the conpeek(container, column number) to access the column of the CSV file

4251.Import3.png

apparently this code has been depreciated in Dynamics AX 365 , what can we use instead of those in order to migrate data from CSV files in Visual Studio

appreciate your feedback ,

regards

Dialog dialog = new Dialog();

DialogField dialogFileName;

DialogField dialogField;

FileIOPermission permission;

Filename filename;

TextIO textIO;

str filePath,fileNameOnly;

filetype type;

container record;

Container filterCriteria;

str Delimiter = ",";

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

For CSV, I would use TextStreamIO::constructForRead().

If you must deal with Excel spreadsheets as well (although it's not in the code above), consider OpenXML, which is already included in the platform (AOT reference DocumentFormat.OpenXml).

Was this reply helpful? Yes No