XlsIO.AspNet Open TSV File

Question

Hi,

i'm currently using the XlsIO.AspNet library to read spreadsheets as part of the functions of our windows service. In generally it works very well. However when i throw it a tab seperated file, it doesn't recognise the tab delimiters. Opening CSV works fine, but i can't get it to work with TSV files as it just clumps all the text together in the one cell. I checked some of the other forums and they indicate that this should be possible but i can't get it to work. Any clues would be appreciated.

Regards,

Brett

Konduru Keerthi Konduru Ravichandra Raju · Answer

Hi Brett, 

Greetings from Syncfusion. 

Syncfusion XlsIO considers the default delimiter as Comma(,). If you are trying to open the tab delimited file, you need to specify the delimiter. Please go through the below link. 
https://help.syncfusion.com/file-formats/xlsio/working-with-excel-worksheet?cs-save-lang=1&cs-lang=csharp#open-a-csv-file  

Kindly try the suggestion and let us know if this helps. 

Regards, 
Keerthi.

Brett Macpherson · Answer

thank you.I was looking in there but couldn't find that bit, works perfectly

Konduru Keerthi Konduru Ravichandra Raju · Answer

Hi Brett, 

Thanks for the update and we are glad that the provided information helped you. 

Kindly let us know if you need any further assistance. 

Regards, 
Keerthi.