Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Thu Jan 16, 2020 10:31 am

Hello

We have a csv file, from a 3rd party, and when we open/look at it one of the column headings has a carriage return and/or space in it and both Excel and Spire.XLS see it as a new row/column heading.

My question is, before I export the data into a Datatable, how can I check if the column name has a carriage return/space in it so that an extra column/row is not created?

Thanks
Attachments
Dodgy Column Name.jpg
Dodgy Column Name.jpg (300.98 KiB) Viewed 2370 times

sconly
 
Posts: 12
Joined: Wed May 08, 2019 10:11 am

Fri Jan 17, 2020 2:40 am

Hello,

Thank you for contacting us.
Could you please provide your sample CSV file to help us investigate your issue accurately and quickly? You could attach it here or send it to our email (support@e-iceblue.com). Thanks in advance.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Tue Jan 21, 2020 1:00 pm

Thanks, but we're bouncing the problem back to the 3rd party to see if they can fix it.

sconly
 
Posts: 12
Joined: Wed May 08, 2019 10:11 am

Wed Jan 22, 2020 1:45 am

Hi,

Thanks for your feedback.
If you need further assistance related to our product, please do not hesitate to contact us.
Wish you a nice day!

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Return to Spire.XLS