I'm working on a project to migrate excel data into new excel files that are compatible with another system. As part of this work, I have to do a lot of data manipulation between excel sheets (concatenation, text matching, text manipulation, etc).
I have been writing VBA scripts but I find the language a bit difficult to work with when errors start popping up. I'd prefer to use C# in Visual Studio since I'm already familiar with the language/IDE.
Would Epplus or the Microsoft Interop libraries be a more modern way to do this work? I'm interested in using a modern API that's intuitive if you already have experience with C++/C#.