How I can remove the Carriage return in the Excel Cell

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

  • 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
  • Replied 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.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels