News and Announcements icon

Dynamics 365 CommunityForums Customer Service forum how to read a excel fi...

Customer Service forum

how to read a excel file from FTP using console.

(0) Share

Report

Report

Posted on by NK Bhairi

244

I need to create cases from FTP (cases are coming in XLSX format). I need to read that file.

Anyone having idea on how to do that.

Categories:

Knowledge Management

All responses Img

All responses (2)

Answers Img

Answers (0)

LeoAlt 16,331 Moderator on at

Like (0)

Report

RE: how to read a excel file from FTP using console.

Good day partner,

I recommend that you could do this in 3 steps.

1.Get excel file from FTP.

http://dotnettricks-abdul.in/?p=1133

https://forums.asp.net/t/2123409.aspx?Read+the+Excel+Files+from+FTP+and+save+in+a+database

2.Get data from excel file.

https://social.msdn.microsoft.com/Forums/vstudio/en-US/e8f604e7-7721-4974-ac5e-91f9423b4569/reading-excel-file-c-console-application?forum=csharpgeneral

https://coderwall.com/p/app3ya/read-excel-file-in-c

3.Use the data from excel file to create a new case.

https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/org-service/sample-create-retrieve-update-delete-late-bound

Hope it helps.

Best Regards,

Leo
Suggested answer

Adrian Begovich 1,025 Super User 2025 Season 1 on at

Like (0)

Report

RE: how to read a excel file from FTP using console.

Hi Miss Dynamics,

This article will teach you how to read an Excel file in a C# Console Application.

Helpful resources

Quick Links

Leaderboard > Customer Service

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans