Wed Dec 24, 2014 8:45 am
Helas, this doesn't help for me. I tried you code but still get the text qualifier.
Dim Delimeter As String = "|"
Dim workbook As New Spire.Xls.Workbook()
workbook.LoadFromFile(PathFileName, Spire.Xls.ExcelVersion.Version2010)
Dim sheet As Spire.Xls.Worksheet = workbook.Worksheets(0)
' Add the data to the excel sheet,
'Then save the file
sheet.SaveToFile(OutputPathFileName, Delimeter, Encoding.UTF8)
The result is still:
"naam_organisatie"|"straat"|"huisnummer"|"toevoeging"|
Where I need:
naam_organisatie|straat|huisnummer|toevoeging|
In the mean time I hace started rewrited my code to using a Textwriter and doingit that. I was just find it a lot easy using XLS.
Hoop there is a solution.
REgards Ediwn