Auto populate Ms Word Table

[ignacio martinez]

Hi,

I would like to use R to fill up an empty word table shell. For example:

I'm able to create a word table, but i'm it does not look like what i want:

    library("ReporteRs")

    

    fake_data <- data.frame("Variable 1" = rnorm(5), "Variable 2" = rnorm(5),

                            "Variable 3" = rnorm(5), "Variable 4" = rnorm(5))

    # Create a word document

    doc <- docx(template="empty_table.docx")

    

    # Add table

    doc <- addFlexTable(doc, vanilla.table(fake_data))

    # Write the word document to a file

    writeDoc(doc, file="example.docx")

Is it possible to do what I want? If so, what am I missing?

Thanks!

Ignacio

[John Vida]

You need to customize your data (i.e the table) to look like the way you want. To fill up an empty word shell table, you need to assign bookmarks in each shell and feed the data to each bookmarks (which is cumbersome).

For your need, grab the data, and feed it to FlexTable object and apply vanilla style and then print on an empty doc. it will be easier to customize colors of certain column.