...

6. Place the text 'Welcome,' and the data marker %%=CompanyEmployee.Employee Name in this text box.
The data marker indicates where the data in the 'Employee' column from the 'Company' data source will be placed.

...

8. Place the data marker %%=Company.Logo(image(2,4.25,1,2)) in the text box.

We are using the image modifier with 3 parameters. The first and second parameters are the width and height of the image respectively. All dimensions are in inches.

The third parameter is the scaling mode, which tells PowerPointWriter to use how to scale the image. In this example we are using scaling mode 2, meaning that the image will be enlarged or shrunk to fit within the bounds specified, but it will keep its natural aspect ratio. The second and third parameters are the width and height of the image respectively. All dimensions are in inches.

For more information on scaling modes and the image modifier see the Quick Guide Importing Images.

...

14. Add three items to this list:

• 'Company History'
• 'Product Overview'
• 'Your Team:' followed by the data marker %%=Employee.Team

...

Our slide so far should look like the following:

...

1. Include the SoftArtisans.OfficeWriter.PowerPointWriter namespace in the code behind

   Code Block
   using SoftArtisans.OfficeWriter.PowerPointWriter;

2. In the method that will create the presentation, instantiate the PowerPointTemplate object.

   Code Block
   PowerPointTemplate pptt = new PowerPointTemplate();

3. Open the template file for the presentation.

   Code Block
   pptt.Open(Page.MapPath("//templates//part1_template.pptx"));

4. Create a DatabindingProperties object for binding data to the template.

   Code Block
   DataBindingProperties dataProps = pptt.CreateDataBindingProperties();

5. Create the 'Company' data source. When importing data with arrays, the values and column names are placed in separate arrays. This first array will contain the column names.

   Code Block
   //The column names are the same as the data markers string[] columnNamesArray = {"Logo"};

6. Create a second array that contains the values for the data source. When importing an image, the image value must be placed in a byte array. This can be done by using the File.ReadAllBytes method. See Importing Images for more information.

   Code Block
   Byte[] logoArray = System.IO.File.ReadAllBytes((Page.MapPath("//data//logo.png"))); //Place the image byte[] into an object[] for the BindData call object[] valuesArray = {logoArray};

7. Bind the 'Company data to the template. Make sure the data source name is the same as the name used in the template.

   Code Block
   pptt.BindData(valuesArray, columnNamesArray, "Company", dataProps);

8. Create the 'Employee' data source. This contains the Employee's name and team

   Code Block
   string[] employeeColNames = {"Name", "Team"}; object[] employeeValues = {"Amy Alberts", "Development"};

9. Bind the Employee data to the presentation

   Code Block
   pptt.BindData(employeeValues, employeeColNames, "Employee", dataProps);

10. Get the data for the Team data source

    Info
    title Following the Sample
    In the sample project, we are parsing CSV files with query results, rather than querying a live database. The CSV files are available under the data directory. There is a copy of the CSV parser, GenericParsing.dll in the bin directory of the project GetCSVData is defined in Part1.aspx.cs in a region marked Utility Methods.

    To create the DataTable, we will call a helper method GetCSVData that parses the CSV files and returns a DataTable with the values.

    Code Block
    DataTable teamData = GetCSVData((Page.MapPath("//data//Team.csv")));

11. Bind the Team data to the presentation

    Code Block
    pptt.BindData(teamData, "Team", dataProps);

12. Call process to import the data into the template and save the file.

    Code Block
    pptt.Process();

13. Stream the output in the response as an attachment

    Code Block
    pptt.Save(Page.Response, "Part1_Output.pptx", false);

Final Code

PowerPointTemplate pptt = new PowerPointTemplate();
pptt.Open(Page.MapPath("//templates//part1_template.pptx"));
DataBindingProperties dataProps = pptt.CreateDataBindingProperties();
string[] columnNamesArray = {"Logo"};
Byte[] logoArray = System.IO.File.ReadAllBytes((Page.MapPath("//data//logo.png")));
object[] valuesArray = {logoArray};
pptt.BindData(valuesArray, columnNamesArray, "Company", dataProps);
string[] employeeColNames = {"Name", "Team"};
                object[] employeeValues = {"Amy Alberts", "Development"};
pptt.BindData(employeeValues, employeeColNames, "Employee", dataProps);
DataTable teamData = GetCSVData((Page.MapPath("//data//Team.csv")));
pptt.BindData(teamData, "Team", dataProps);
pptt.Process();
pptt.Save(Page.Response, "Part1_Output.pptx", false);

Downloads

You can download the code for the Basic PowerPointWriter Tutorials as a Visual Studio solution, which includes the Project Proposal.

• PowerPointWriter_BasicTutorials.zip

Next Steps

Continue on to Part 2 - The Continue Modifier