While coverting XLS to csv one of the column values going in to other line. I think that is because of double quote
Column which is creating problem is in double quote. PFB
"Sambhavan park,TowerA
Bhorivali east Marg, Rahul nagar
IN/Badlapur 76534."
Can you please help me to get rid of this, I am using below code to covert.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Xls;
namespace xls2csv
{
class Program
{
static void Main(string[] args)
{
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"E:\file.xls");
Worksheet sheet = workbook.Worksheets[0];
sheet.SaveToFile(@"E:\file.csv", "|", Encoding.ASCII);
}
}
}