Open a word file, read all its contents and write to excel

Vaadeendra S

8y1.3kGeneral

write a program to Open a word file, read all its contents and write the contents to excel file

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hussam Barouqa8y ago
You can accomplish this using OCR to extract the text from Word documents. Consider using the LEADTOOLS OCR toolkit (https://www.leadtools.com/sdk/ocr) which you can use with document writer classes to produce the recognized text in XLS or XLSX format.
The code to do this looks something like this:
using (IOcrEngine ocrEngine = OcrEngineManager.CreateEngine(OcrEngineType.OmniPage, false))
{
    using (RasterCodecs rasterCodecs = new RasterCodecs())
    {
        rasterCodecs.Options.Load.AllPages = true;
        ocrEngine.Startup(rasterCodecs, null, null, null);
        string fileName = @"WordFile.docx";

        using (var ocrDocument = ocrEngine.DocumentManager.CreateDocument())
        {
            using (CodecsImageInfo fileinfo = rasterCodecs.GetInformation(fileName, true))
            {
                for (int pagenumber = 1; pagenumber < fileinfo.TotalPages; pagenumber++)
                {
                    ocrDocument.Pages.AddPage(rasterCodecs.Load(fileName, 0, CodecsLoadByteOrder.Bgr, pagenumber, pagenumber), null);
                }
                ocrDocument.Pages.Recognize(null);
                ocrEngine.DocumentManager.EngineFormat = "Excel2007";
                ocrDocument.Save(fileName + ".xlsx", DocumentFormat.User, null);
            }
        }
    }
}
0
Leon D8y ago
You can use Free Spire.Office library to achieve this.

First reference Free Spire.Office dll (search Free Spire.Office in NuGet), then try the following code:
using Spire.Doc;
using Spire.Xls;

namespace WordToExcel
{
    class Program
    {
        static void Main(string[] args)
        {
            //Load the word file
            Document document = new Document();
            document.LoadFromFile("Input.docx");

            //Read its contents
            string wordContent = document.GetText();

            //Create a excel file
            Workbook workbook = new Workbook();
            //Get the first worksheet
            Worksheet sheet = workbook.Worksheets[0];

            //Write the contents to excel
            sheet.Range["A1"].Text = wordContent;

            //Save the excel file
            workbook.SaveToFile("Output.xlsx", ExcelVersion.Version2013);
        }
    }
}
0
Bala S8y ago
Have you tried this link
https://www.c-sharpcorner.com/article/creating-and-opening-microsoft-word-documents-from-net-usin/
0