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

Question

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

Hussam Barouqa · Answer

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 { 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 ); } } } }

Leon D · Answer

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); } } }

Bala S · Answer

Have you tried this link https://www.c-sharpcorner.com/article/creating-and-opening-microsoft-word-documents-from-net-usin/

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

Answers (3)