How to print data table along with its Color code in Word File?

[Gopikrishna_S]

This is my Input excel file I want this same table with its Color Code in Word file, Unfortunately Cant able to get the Color Code in Word File…Suggest a method to get blue Color in Required area.

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

please check this , follow if it is of any use

Move the DataTable to Word with the same formatting

you can try this 1.Use excel scope 2.Use excel file activity 3.use copy/paste range activity , in destination give as copy to clip board 4.now open the word file indicate/click the place using ui activities 5.send keys Ctrl+V to paste the value Hope this is like a work around , if have some idea that you can do with word activities will be better but in the mean check for better solution Edit : Better solution , seems this will solve your problem After point 3 above try below steps Use …

Regards

[Gopikrishna_S]

I have tried this perfectly working for Small Data Table, In the Case of Big Data Table Alignments are not Comming Perfectly. Cant able to see half of the table.

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

can you try in this way

First format the the cells in excel width and height by reducing

Later you try remaining steps

---

Can you let me know how is manually done in this scenario (ie Large data tables )

Regards

[Gopikrishna_S]

how to reduce width and height in excel

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

Try autofit activity and check how it works

also other way would be using macro

is it possible to change the word file alignment to landscape?

Can you give the sample file that could be required to paste in the word

also how this is handled manually?

Regards