Last post May 28, 2021 08:14 PM by bruce (sqlwork.com)
May 28, 2021 07:40 PM|eraldi23|LINK
Hello ASP.NET developers, I am new to .NET and trying to learn as much as I can.
I have a project that I am trying to accomplish but I am having some issues with it.
Basically, my scenario is as follows: Create an ASP.NET application to accept/upload a CSV or XLSX file and convert it to a formatted NACHA file.
I was wondering to ask if there are any ideas or recommendations you might suggest on how to approach this problem. I would like to create an ASP.net core application to accomplish this project, and the company that I work for does not want to use third-party
software to make the conversion.
I would appreciate any help.
Thanks in advance
May 28, 2021 08:14 PM|bruce (sqlwork.com)|LINK
take in multiple steps:
1) define your own data structure for the data
2) google .net read csv file, and find lots of examples. write the code to read the csv file into your data structure
3) use open xml sdk to read an excel file into your data structure (https://docs.microsoft.com/en-us/office/open-xml/open-xml-sdk)
4) google for the a spec of the type of NACHA file you want to produce. and write code to write your data structure to the file format
put these together with a web application.