using System;

using System.IO;

using NPOI.SS.UserModel;       // learnt along

using NPOI.XSSF.UserModel;  //learnt along

​

​

class Program

{

    static void Main(string[] args)

    {

        string inputFilePath = "ParsingText.XLS";

        string outputFilePath = "ParsingTextFinal.XLS";

        string delimiter = "stringx";

​

        using (FileStream fs = new FileStream(inputFilePath, FileMode.Open, FileAccess.Read))

        {

            IWorkbook wb= new XSSFWorkbook(fs);

            ISheet sheet = wb.GetSheetAt(0); 

​

            for (int rowIndex = 0; rowIndex <= sheet.LastRowNum; rowIndex++)

            {

                IRow row = sheet.GetRow(rowIndex);

                if (row != null)

                {

                    ICell cell = row.GetCell(0);

                    if (cell != null)

                    {

                        string originalText = cell.StringCellValue;

​

                        // Split the text using "stringx" as the delimiter

​

                       string[] parts = originalText.Split(new string[] { delimiter }, StringSplitOptions.None);

                        string lhsString = "";

                        string rhsString = "";

​

                        if (parts.Length > 0)

                            lhsString = parts[0].Trim();

​

                        if (parts.Length > 1)

                            rhsString = parts[1].Trim();

​

                        // calling function to remove punctuations from LHS and RHS

                        lhsString = RemovePunctuation(lhsString);

                        rhsString = RemovePunctuation(rhsString);

​

                        // Creating separate cells for LHS and RHS

                        row.CreateCell(1).SetCellValue(lhsString);

                        row.CreateCell(2).SetCellValue(rhsString);

                    }

                }

            }

​

            // Save the modified Excel file

            using (FileStream fs1= new FileStream(outputFilePath, FileMode.Create, FileAccess.Write))

            {

                wb.Write(fs1);

            }

        }

    }

​

//Function to remove punctuations.

​

    static string RemovePunctuation(string text)

    {

        return text.Replace(".", "").Replace(",", "").Replace("?", "");

    }

}

​