Skip to main content

C# read word document and get specific data from document




  // Reding all word document from a specific folder  
       foreach (string file in Directory.EnumerateFiles(@"D:\", "*.doc"))  
       {  
         //string contents = File.ReadAllText(file);  
         Microsoft.Office.Interop.Word.Application word = new Microsoft.Office.Interop.Word.Application();  
         object miss = System.Reflection.Missing.Value;  
         object path = file; // @"D:\35339.doc";  
         object readOnly = true;  
         Microsoft.Office.Interop.Word.Document docs = word.Documents.Open(ref path, ref miss, ref readOnly, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss);  
         string totaltext = "";  
         for (int i = 0; i < 2; i++) // i set value 2 you can change  
         {  
           totaltext += " \r\n " + docs.Paragraphs[i + 1].Range.Text.ToString();  
         }  
         // Getting data after specific data from the string  
         string _findName = "Name :";  
         string code = totaltext.Substring((totaltext.IndexOf(_findName) + _findName.Length), 20);  
         string _findMrno = "MR. No.      :";  
         string mrNo = totaltext.Substring((totaltext.IndexOf(_findMrno) + _findMrno.Length), 12);  
         string _findAge = "Age     :";  
         string age = totaltext.Substring((totaltext.IndexOf(_findAge) + _findAge.Length), 6);  
         string _findDate = " Date           :";  
         string date = totaltext.Substring((totaltext.IndexOf(_findDate) + _findDate.Length));  
         // You code for insert or other things to do  
         docs.Close();  
         word.Quit();  
       }  



Comments

Popular posts from this blog

WPF datagrid cell textbox change event

Entity/Class: public class FeesDetails : INotifyPropertyChanged { public int Id { get; set; } public string FeesName { get; set;} public string FeesDetailsName { get; set; } public int? PaidAmount { get; set; } public event PropertyChangedEventHandler PropertyChanged; private void NotifyPropertyChanged(System.String info) { if (PropertyChanged != null) { PropertyChanged(this, new PropertyChangedEventArgs(info)); } } public int feesAmount { get; set; } public int FeesAmount { get { return this.feesAmount; } set { if (value != this.feesAmount) { this.feesAmount = value; NotifyPropertyChanged("FeesAmount"); } } } } XAML: <DataGrid AutoGenerateColumns="False" Height="21

ASP.NET MVC razor SAP Crystal report

Crete a new project: Add a aspx Master Page Create a new folder Reports and 2 sub folder crystal & crystalviewer Now add a web form page in crystalviewer  folder. Add the master page namespace in your web form page. MasterPageFile ="~/Views/Shared/ReportSite.Master" Replace your web form by this code < asp : Content ID ="Content1" ContentPlaceHolderID ="ContentPlaceHolder1" runat ="server">      </ asp : Content > Now go to design mode of your web form drag & drop the crystal report viewer in your web form. After that your page will be look look like this. Replace the code: < CR : CrystalReportViewer ID ="EmployeeList" runat ="server"   HasCrystalLogo ="False"     AutoDataBind ="True"   Height ="50px"   EnableParameterPrompt ="false" EnableDatabaseLogonPrompt

C# run powershell script as administrator

Recently I was fetching a problem that I need to run a PowerShell script that will change TFS user Display name and SID. I was trying to run that script from C# that was not working due to TFS security update and TLS certificate. Using this code block I resolve the Issue. var newProcessInfo = new System.Diagnostics.ProcessStartInfo(); newProcessInfo.FileName = @"C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe"; newProcessInfo.Verb = "runas"; // Define Run as administrator newProcessInfo.Arguments = script; //Define your powershell script newProcessInfo.UseShellExecute = false; newProcessInfo.RedirectStandardOutput = true; // This will enable to read Powershell run output newProcessInfo.RedirectStandardError = true; Process proces = System.Diagnostics.Process.Start(newProcessInfo); proces.WaitForExit(); // I want to read the output string from powershell window StringBuilder output = new StringBuilder(); output.Append("Started"); while (!proces.St