how  to convert word paragraphs and  tables full of data to excel tables with the tabular format for the same  data

Posted on 2007-08-03
Last Modified: 2010-04-15
Hi all,
I have nearly 300 files of data (text and tables of data in microsoft word format) and I need to migrate them to excel in tabular format
so my question now is :
can that be done using c# or (I mean reading the word page text and table structure and data then convert them to excel sheet structure and data)?
if so can any body send me an example?
any help, idea, link, tutorial or article is appreciatable
please reply as soon as possible
best Regards
Question by:shang3000
    LVL 7

    Accepted Solution

    This is not a full answer

    This can be done but it's not very easy using C#... As a starter you might take a look at the documentation for the Visual Studio Tools for Office but you can also use the primary interop assemblies for Word and Excel or just add a reference in your project to the word or excel tlb. These options are in order of re-usability.

    You will need to learn about the Excel and Word object model (MSDN sites as a starter) and then implement what you learned.

    The complexitivity of the task entirely depends on the word documents and the required result. You need to program every step you do by hand without the possibility to thing over what your are doing.

    My advise: feasable if 80% of the word documents have somewhat identical layout, otherwise, fetch a cheap employee and let him work on it for a month of two.
    Project time estimate (knowing the word/excel object model):
    - develop frame for the conversions: 5 days
    - conversion: time for a manual conversion x 20

    Kind regards,

    Author Comment

    the first question was asking for sample with and the second one was asking for sample code with c# they are not the same question because the answer is not unique
    I hope that you understand what I mean I'm seeking for a solution of my problem not to make a problem for any one nomatter what is the language that's why I asked about the problem in two separate categories

    I need your cooperations
    best Regards

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
    Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now