Is it possible to program the text import wizard of Excel using C#?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • user033088
    New Member
    • Mar 2013
    • 25

    Is it possible to program the text import wizard of Excel using C#?

    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!!!
  • vijay6
    New Member
    • Mar 2010
    • 158

    #2
    Delimiting the spaces, specifying the column widths, eliminating a few rows and columns.
    Hey user033088, can you show some sample content of your text-file(s) and how you want your output format?

    Comment

    Working...