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

(0) Share

Report

Posted on by Abdo Khoury

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

All responses (1)

Answers (0)

Suggested answer

Martin Dráb on at

Like (0)

Report

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

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).

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates