Excel Data to MS Word Fields

[AutoCraig]

Is there a way I could take a Excel Spreadsheet and populate a document with the data from the spreadsheet dumped in a certain format? For Example:

If I had a spreadsheet of data:

ColumnA ColumnB ColumnC

Data0 More Data0 Even More Data0

Data1 More Data1 Even More Data1

Data2 More Data2 Even More Data2

I want to populate a document with that data in a certain way:

Data0

More Data0 Even More Data0

Data1

More Data1 Even More Data1

Data2

More Data2 Even More Data2

I know how to store excel data to an array (_ExcelReadArray) and I know I can painfully open a new word doc and format it. I was hoping that I could just populate some unique fields over and over again.

I know my formatting in this post won't come out nice, but I hope I got the idea across.

[JLogan3o13]

Hi, AutoCraig. Have you looked into using _ExcelReadCell? You can always read the cells into variables, then dump them into your Word doc in whatever fashion you'd like.

[AutoCraig]

Dumping it willy nilly into a word doc was what I was trying to avoid. There would be potential to have lots of data and I don't want a word doc sitting there filling in data for 5 mins.

[water]

There is an Excel UDF and a Word UDF built into AutoIt. You can access the objects created/returned by this UDFs using pure AutoIt and do what you need.

Have a look at MSDN to get a reference of the Word COM.

You are a bit vague in your description what you want to do. Some more information is needed to really help you. Like:

• What amount of data are we talking about? How big is your Excel file?
• What do you mean by "populate some unique fields"?
• Do you have a word template that needs to be filled or do you want to create the document froms cratch?
• ...

[big_daddy]

Could you attach a sample Excel and Word documents so that we better understand your requirements?

Edit: What water said ^

Edited January 10, 2012 by big_daddy

[AutoCraig]

Sorry for the vagueness. I didn't know about the Word UDFs, that should do it. Thanks for the help.

[water]

I'm not sure if the Word UDF supports you in more than opening a document and returning the object. Inserting text/data has to be done by you using the returned object.

Check the functions of the Word UDF and if you have further questions describe what you want to do as detailed as possible.