Export textbox and datagridview data to a WORD document. All to the same document

Question

0.00/5 (No votes)

See more:

I got a Windows Forms application using C# and struggling now for over a week trying to export some textboxes and a datagridview data to a word document. I'v managed to get the textboxes data over to word but cant get the datagridview data in to the same word document. I need both to be on the same document. Please help me with ideas... I'm loosing my mind here. Some Code and examples will be highly appreciated. Thank you in advance.

Code below does get my texbox data over to word but not the datagridview.

What I have tried:

private void btnSaveReport_Click(object sender, EventArgs e) { ToViewFile(docxPath);

        document = new Spire.Doc.Document();
        document.LoadFromFile(samplePath);
       
        Dictionary<string, string> dictReplace = GetReplaceDictionary();

        foreach (KeyValuePair<string, string> kvp in dictReplace)
        {
            document.Replace(kvp.Key, kvp.Value, true, true);
        }

        document.SaveToFile(docxPath, FileFormat.Docx);
    }

    private void ToViewFile(string fileName)
    {
        try
        {
            System.Diagnostics.Process.Start(fileName);
        }
        catch 
        { 
        }
    }

    Dictionary<string, string> GetReplaceDictionary()
    {
        Dictionary<string, string> replaceDict = new Dictionary<string, string>();
        replaceDict.Add("#Date#", txtDate.Text.Trim());
        replaceDict.Add("#DataGrid#", "DataGridView Entries Here");
        replaceDict.Add("#Lead Tech#", txtLeadTech.Text.Trim());
        replaceDict.Add("#Gaming Security#", txtSecurity.Text.Trim());
        replaceDict.Add("#Surveillance#", txtSurv.Text.Trim());
        replaceDict.Add("#Comments#", txtComments.Text.Trim());
        replaceDict.Add("#Book#", txtBooks.Text.Trim());
        return replaceDict;
    }

Posted 4-Feb-22 4:33am

Melger Stander

Updated 16-Feb-22 5:13am

Add a Solution

Comments

Richard MacCutchan 4-Feb-22 11:06am

A DataGridView is just a visula representation of some data. So you need to structure that data into a format that you can then add to your document. It is not clear why you are using Key Value pairs for the text, or why you cannot do that for the other data.

Melger Stander 16-Feb-22 2:47am

Thank you for replying. I'm new in C# and not coming right with this problem. Is there a other way for export my windows form data to a word document? I just found the key value example on a code group. No specific reason for using it.

Richard MacCutchan 16-Feb-22 3:26am

It is not clear exactly what you are trying to do. What is the data that you are trying to export? What library or interface are you using in the export process?

Melger Stander 16-Feb-22 3:35am

I got a windows application using C#. In my form I got texboxes and a datagridview. I need to create a report. I'm trying to export it to a word document. If there is s better reporting way please point me in the right direction. As I said I'm new in this and still learning better and correct ways. Thank you

Richard MacCutchan 16-Feb-22 3:50am

The use of TextBoxes and DataGridViews is irrelevant; they are only used in your Windows Form. You need to decide first how you want your data to appear in the Word document, and how you are going to export it. Until you can answer those questions it is difficult to suggest anything.

If you just want to generate a report from your application then take a look at Crystal Reports, and/or Microsoft's own reporting tools.

Melger Stander 16-Feb-22 4:44am

I am looking into Crystal reports. What I want to do is create a report from my Local SQL database. I realized it sounds easier than it is. tried crystal report but need a licence for it. My budget doesn't allow that :-(

Thank you very much for taking the time to reply my questions.

Richard MacCutchan 16-Feb-22 4:46am

You could try https://www.microsoft.com/en-us/download/details.aspx?id=53613&e6b34bbe-475b-1abd-2c51-b5034bcdd6d2=True[^] if you cannot afford Crystal Reports. The alternative is to write your own reporting tool, but that is probably many weeks of work.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2022-02-16T05:13:00

Assuming that DataGridView is bounded with datasource, like DataTable:

private void btnSaveReport_Click(object sender, EventArgs e)
{
    document = new Spire.Doc.Document();
    document.LoadFromFile(samplePath);
    
    Dictionary<string, string> dictReplace = GetReplaceDictionary();

    foreach (KeyValuePair<string, string> kvp in dictReplace)
    {
        document.Replace(kvp.Key, kvp.Value, true, true);
    }
    
    DataTable dt = DataGridView1.DataSource as DataTable;
    foreach(DataRow dr in dt.Rows)
    {
        //here add code with your logic      
    }

    document.SaveToFile(docxPath, FileFormat.Docx);

    ToViewFile(docxPath);

    }