[aueddonline]

I'm trying to create a word document from my web application which grabs some data from my sql database and puts it in the document. Here's the code behind my button

            object missing = System.Reflection.Missing.Value;
            object Visible=true;
            object start1 = 0;
            object end1 = 0;

            string name = "edward";

            _Application WordApp = new Application();
            Document adoc = WordApp.Documents.Add(ref missing, ref missing, ref missing, ref missing);
            Range rng = adoc.Range(ref start1, ref missing);

            try

            {              
                rng.Font.Name = "Verdana";
                rng.InsertAfter("Hello World!" + "\r" + "Something in-between" + "\r" + "Hello World!");

                object filename = @"C:\Users\edward\Documents\" + name + ".docx";
                adoc.SaveAs(ref filename, ref missing, ref missing, ref missing, ref missing, ref missing,
                ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);
                WordApp.Visible = true;
            }
            catch (Exception ex)
            {
                keeper = "Bugger";
            }

The current problem is I want a new line, but a single new line, the kind you'd get if you held down Shift while pressing the enter key in Word. I have tried /n and /r and they both seem to do the same.

[Momerath]

IIRC Word treats a hard newline as a new paragraph. Have you checked your paragraph spacing?

I could be way off here, also

[aueddonline]

Momerath, on 11 July 2011 - 04:14 PM, said:

IIRC Word treats a hard newline as a new paragraph. Have you checked your paragraph spacing?

I could be way off here, also

okay, so you're right. I took out 'Add space after paragraph' within my Normal.dot file (word template) and that has worked. This isn't really the way I wanted to do it because it's a web service and I don't want to change the template file on every PC I use but it's a start. And maybe the only solution

[Curtis Rutland]

According to another site I've read, word uses a vertical tab character for a line break. This is character 11 in ASCII, so you could get it like this:

char vt = (char)11;

Then add it to the document.

Also, you might look at upgrading to .NET 4. They added support for default/named parameters, as well as dynamic objects, so you don't have to fill in all the .Missing values yourself.

[aueddonline]

Curtis Rutland, on 11 July 2011 - 09:30 PM, said:

According to another site I've read, word uses a vertical tab character for a line break. This is character 11 in ASCII, so you could get it like this:

char vt = (char)11;

Then add it to the document.

Also, you might look at upgrading to .NET 4. They added support for default/named parameters, as well as dynamic objects, so you don't have to fill in all the .Missing values yourself.

Excellent! This works perfectly.

[aueddonline]

Next thing I wanted to do was add some structure; headers, footers, tables, if anyone has a head start on that?