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.
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.
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://coderwall.com/p/app3ya/read-excel-file-in-c
3.Use the data from excel file to create a new case.
Hope it helps.
Best Regards,
Leo
Hi Miss Dynamics,
This article will teach you how to read an Excel file in a C# Console Application.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156