Create Word files from Excel content

Posted by Lennart on Super User See other posts from Super User or by Lennart
Published on 2012-11-26T20:11:21Z Indexed on 2012/11/27 23:12 UTC
Read the original article Hit count: 299

Filed under:

script

|

excel-2010

I have an Excel file that I want to split into several files (Word, PDF is also good), based on content. The content is somewhat like this:

Person  Fase  Date       Item  Text
A       1     01-01-2012 Z     Lorem ipsum
A       2     01-02-2012 X     Lorem ipsum
B       1     02-01-2012 Y     Lorem ipsum
C       2     01-01-2012 Z     Lorem ipsum

I want Word/PDF documents with names like

Person_Fase.docx

And as content the date, item and text. Idealy in a table layout. Any hints/ clues on how to get there? It's about 700 clients, with up to 300 Excel entries each.

© Super User or respective owner

Related posts about script

Asset Pipeline acting up

as seen on Stack Overflow - Search for 'Stack Overflow'
Ok, so my asset pipeline has suddenly started acting up on my development machine. JS functions that previously worked are now throwing "not a function" errors.. I know I must be doing something wrong. A minute ago the datatables jquery function was working, then it was throwing an error, then it… >>> More
Rendering ASP.NET Script References into the Html Header

as seen on West-Wind - Search for 'West-Wind'
One thing that I’ve come to appreciate in control development in ASP.NET that use JavaScript is the ability to have more control over script and script include placement than ASP.NET provides natively. Specifically in ASP.NET you can use either the ClientScriptManager or ScriptManager to embed scripts… >>> More
How do I configure Tomcat services in Ubuntu?

as seen on Server Fault - Search for 'Server Fault'
I have created a Tomcat script inside the /etc/init.d directory which is #!/bin/bash # description: Tomcat Start Stop Restart # processname: tomcat # chkconfig: 234 20 80 JAVA_HOME=/usr/java/jdk1.6.0_30 export JAVA_HOME PATH=$JAVA_HOME/bin:$PATH export PATH CATALINA_HOME=/usr/tomcat/apache-tomcat-6… >>> More
Avoid richfaces to send back javascript libraries in the ajax responses

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using JSF 1.2 with Richfaces, and for every ajax request, the server is sending back the response, whichi is good, but it also contains all the links to the javascript files. I want to improve the performance so I just want the <body> to be returned, because all the javascript files are… >>> More
Whats the difference between running a shell script as ./script.sh and sh script.sh

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a script that looks like this #!/bin/bash function something() { echo "hello world!!" } something | tee logfile I have set the execute permission on this file and when I try running the file like this $./script.sh it runs perfectly fine, but when I run it on the command line like… >>> More

Related posts about excel-2010

Sum and chart in excel

as seen on Super User - Search for 'Super User'
I have data like the following: Both Hour and Count are columns in an excel file. Hour Count 17 79 18 122 19 123 20 142 21 150 22 78 23 15 13 33 14 33 15 40 16 33 17 56 18 46 19 35 20 67 21 65 22 45 23 36 What I want is to create a chart that shows over… >>> More
Offset the tickmarks of a secondary axis

as seen on Super User - Search for 'Super User'
I would like to offset the tickmarks of a secondary axis in excel WITHOUT changing the minimum. Here is a very complicated VBA class that apparently solves the issue but I would like a solution that doesn't require me to construct my entire chart in VBA. Here is an example of what I mean (I removed… >>> More
Find a non-case-sensitive text string within a range of cells

as seen on Super User - Search for 'Super User'
I've got a bit of a problem to solve in Excel, and I'm not quite sure how to go about doing it. I've done a few searches online, and haven't really found any formulas that seem to be useful. Here's the situation (simplified just a bit, for the purpose of this question): I have data in columns A-E… >>> More
How can I split Excel data from one row into multiple rows

as seen on Super User - Search for 'Super User'
Good afternoon, Is there a way to split data from one row and store to separate rows? I have a large file that contains scheduling information and I'm trying to develop a list that comprises each combination of course, day, term and period per line. For example I have a file similiar to this: Crs:Sn… >>> More
Keyboard shortcut in excel for expanding the pivot table row?

as seen on Super User - Search for 'Super User'
I'm able to expand/collapse the row in the pivot table with mouse by: right clicking on cell in the first column of the row + selecting "Expand/Collapse"/"Expand" from context menu. or double clicking on the cell in the first column of the row Is there a keybord shortcut for same action? I'm using… >>> More