When exporting orders/customers etc to Excel there is a '(single quota) in front of every value
- 714
- 9597
- 12/08/2009
- United States
Bigal99 wrote:
The leading single quote is to identify the cell as text so Excel doesn't format cells containing only numbers, but aren't numeric (postal codes, phone numbers, addresses, etc.) as numbers. I'm not sure if they can be removed as they are inserted by ADO. http://stackoverflow.com/questions/755621/oledb-writing-excel-cell-without-leading-apostrophe
If you need to remove the leading quote, you could, in Excel, save the exported Excel file as a CSV file to strip the leading quotes and then open the CSV file and save it as an Excel file (for importing). To import, you will need to restore the worksheet name in Excel (saving as a CSV removes the worksheet name).
.
sangheraajit, have you solved this issue??
Does anyone now how to fix this?
Does anyone now how to fix this?
The leading single quote is to identify the cell as text so Excel doesn't format cells containing only numbers, but aren't numeric (postal codes, phone numbers, addresses, etc.) as numbers. I'm not sure if they can be removed as they are inserted by ADO. http://stackoverflow.com/questions/755621/oledb-writing-excel-cell-without-leading-apostrophe
If you need to remove the leading quote, you could, in Excel, save the exported Excel file as a CSV file to strip the leading quotes and then open the CSV file and save it as an Excel file (for importing). To import, you will need to restore the worksheet name in Excel (saving as a CSV removes the worksheet name).
.
- 2
- 10
- 14/05/2010
- India
mb wrote:
Yes i have solved this problem but i changed the code and class to export data to excel.
Bigal99 wrote:
The leading single quote is to identify the cell as text so Excel doesn't format cells containing only numbers, but aren't numeric (postal codes, phone numbers, addresses, etc.) as numbers. I'm not sure if they can be removed as they are inserted by ADO. http://stackoverflow.com/questions/755621/oledb-writing-excel-cell-without-leading-apostrophe
If you need to remove the leading quote, you could, in Excel, save the exported Excel file as a CSV file to strip the leading quotes and then open the CSV file and save it as an Excel file (for importing). To import, you will need to restore the worksheet name in Excel (saving as a CSV removes the worksheet name).
.
sangheraajit, have you solved this issue??
Does anyone now how to fix this?
Does anyone now how to fix this?
The leading single quote is to identify the cell as text so Excel doesn't format cells containing only numbers, but aren't numeric (postal codes, phone numbers, addresses, etc.) as numbers. I'm not sure if they can be removed as they are inserted by ADO. http://stackoverflow.com/questions/755621/oledb-writing-excel-cell-without-leading-apostrophe
If you need to remove the leading quote, you could, in Excel, save the exported Excel file as a CSV file to strip the leading quotes and then open the CSV file and save it as an Excel file (for importing). To import, you will need to restore the worksheet name in Excel (saving as a CSV removes the worksheet name).
.
Yes i have solved this problem but i changed the code and class to export data to excel.