5
I need to create an application that reads a small sequence of data available each in an Excel column. My question is whether the best way is to deal directly with SQL uploading the file and then dealing with a precedent or work with the data in C# and send it to each column of my SQL table.
Treating the side of C# I believe I can have more security in relation to what I am sending to the bank, I gave a read on this issue: https://stackoverflow.com/questions/657131/how-to-read-data-of-an-excel-file-using-c but I didn’t quite understand.
For the example of Procedure I am using this article as a basis: http://www.aspsnippets.com/Articles/How-to-Import-Excel-Sheet-data-into-SQL-Server-using-ASPNet.aspx
Look, I wouldn’t advise you to use SQL to do this. There are many ways to import Excel files, but this is to your liking. Take a look at Closed XML and Open XML.https://closedxml.codeplex.com/documentation
– f.fujihara
What exactly did you not understand from the other question?
– Leonel Sanches da Silva
I used part of the code of the answer chosen for that question: http://answall.com/questions/14034/erro-ao-ler-xml . It worked perfectly. I used XML because I was not able to read Excel on the server side.
– Rafael Barbosa