Export to Excel - Single quote at the beginning of each string value

Export to excel has a single quote (') at the beginning of each string value.

For example, products_2010-09-17-15-42-28_7759.xls
'Name
'$25 Gift Card
'$5 Gift Card

Is it a known issue?

Thank you!

Same Problem Here Too.

Kokkos

Don't worry about it. You can modify the xls and add new products without the quote and it will still work fine. I'm sure nopCommerce has a reason for putting it in, but it does work fine without the quote on an import.

If this is causing you problems just do a find and replace all on the quote. You will still be able to import the same xls back in.

Seem to remember it's the oledb driver does this and that there isn't an easy way round it other than using a different excel library.

Thank you all for the comments!