[Solved] Read Table (Grid) data from PDF, Convert and export to Excel File in ASP.Net

Please refer this code

HTML

Upload PDF File :<asp:FileUpload ID="fuPdfUpload" runat="server" />
<asp:Button ID="btnExportToExcel" Text="Export To Excel" OnClick="ExportToExcel"
    runat="server" />

Namespaces

using System.Text;
using System.IO;
using iTextSharp.text;
using iTextSharp.text.pdf;
using iTextSharp.text.pdf.parser;
using System.Data;
using ClosedXML.Excel;

C#

protected void ExportToExcel(object sender, EventArgs e)
{
    if (this.fuPdfUpload.HasFile)
    {
        string currentText = string.Empty;
        StringBuilder text = new StringBuilder();
        PdfReader pdfReader = new PdfReader(fuPdfUpload.FileBytes);

        for (int page = 1; page <= pdfReader.NumberOfPages; page++)
        {
            ITextExtractionStrategy strategy = new LocationTextExtractionStrategy();
            currentText = PdfTextExtractor.GetTextFromPage(pdfReader, page, strategy);
            currentText = Encoding.UTF8.GetString(Encoding.Convert(Encoding.Default, Encoding.UTF8, Encoding.UTF8.GetBytes(currentText)));
            text.Append(currentText);
            pdfReader.Close();
        }

        string[] data = currentText.Split('\n');

        //Creating DataTable
        DataTable dt = new DataTable("PdfTable");

        string[] headers = data[0].Split(' ');

        //Adding the Columns
        for (int j = 0; j < headers.Length; j++)
        {
            if (!string.IsNullOrEmpty(headers[j]))
            {
                dt.Columns.Add(headers[j], typeof(string));
            }

        }
        for (int i = 1; i < data.Length; i++)
        {
            string[] content = data[i].Split(' ');
            dt.Rows.Add();
            for (int k = 0; k < content.Length; k++)
            {
                if (!string.IsNullOrEmpty(content[k]))
                {
                    dt.Rows[dt.Rows.Count - 1][k] = content[k];
                }
            }
        }

        using (XLWorkbook wb = new XLWorkbook())
        {
            wb.Worksheets.Add(dt);                
            Response.Clear();
            Response.Buffer = true;
            Response.Charset = "";
            Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
            Response.AddHeader("content-disposition", "attachment;filename=Excel.xlsx");
            using (MemoryStream MyMemoryStream = new MemoryStream())
            {
                wb.SaveAs(MyMemoryStream);
                MyMemoryStream.WriteTo(Response.OutputStream);
                Response.Flush();
                Response.End();
            }
        }
    }
}

Screenshot

Pdf File

Remember dont add the space between name and country.

Excel