How I can remove the Carriage return in the Excel Cell

How I can remove the Carriage return in the Excel Cell

Posted by: berubea on 29 April 2021, 1:58 am EST

• 

  berubea

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 29 April 2021, 1:58 am EST

  Hi,
  
  I use a DataTable to transfert the data to the Excel. When I open the Excel file in the text data they always have a carriage return at the end. Is there a way to remove the carriage return.

  Code
  
  xlxWorkSheet.DataSource = myTable
  
  xlxWorkbook.Save(“C:\temp\toto.xlsx”)

  Best regards

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 29 April 2021, 5:29 pm EST

  Hello,

  Your case has been replied on your support case: CAS-21747-W7K7J6, please continue the thread there only to avoid confusion.

  Regards,
  
  Prabhat Sharma.