I have a requirement where I have to import a lot of text files into excel. Up till now I can import the text files using visual studio C# but after importing the format is not exactly the way I want (mostly the delimiters). So I have to manually use the text import wizard and make the changes. I was just wondering if there is any way to program all of it.
Delimiting the spaces, specifying the column widths, eliminating a few rows and columns.
Just an idea also will be great.
Thank you in advance!!!
Delimiting the spaces, specifying the column widths, eliminating a few rows and columns.
Just an idea also will be great.
Thank you in advance!!!
Comment