Hi All,
I want to import a CSV file programmaticaly in Excel.
I've searched the internet and came up with this code:
xlWorkBooks.OpenText(@"C:\WOC\Example.CSV",
DataType: Excel.XlTextParsingType.xlDelimited,
TextQualifier: Excel.XlTextQualifier.xlTextQualifierNone,
ConsecutiveDelimiter: false,
Semicolon: true);
But this is not working. Whatever I do a row is just a long string as if the Semicolon is not recognized.
I tried so many possible options but none is working.
Pls find in the attachment what I see when Excel is openend.
Your help is very much appreciated!
Best regards,
Bert
I want to import a CSV file programmaticaly in Excel.
I've searched the internet and came up with this code:
xlWorkBooks.OpenText(@"C:\WOC\Example.CSV",
DataType: Excel.XlTextParsingType.xlDelimited,
TextQualifier: Excel.XlTextQualifier.xlTextQualifierNone,
ConsecutiveDelimiter: false,
Semicolon: true);
But this is not working. Whatever I do a row is just a long string as if the Semicolon is not recognized.
I tried so many possible options but none is working.
Pls find in the attachment what I see when Excel is openend.
Your help is very much appreciated!
Best regards,
Bert