With help of this plugin you can export your collection to MS Excel with templates. You are able to change templates as you want.
Exports movie collection to MS Excel using sorting by any field. Templates are used for export. You can use standard or create your own ones.
Installation: Download and unzip to the "plugins" folder in the All My Movies installation folder. By default it is "Program Files\AllMyMovies\plugins\"
First plugin release.
Author: Alexey Poddubny
[Download (about 450 KB)]
Short template creation guide
To generate reports, the first thing you need is a template. Create a document like template.xls provided in the plugin's installation package.
Here you put:
1) All the titles, images and formatting of the report. You can include graphs, filters, conditional format, images or anything you can think of. You can also fill as many sheets as you want, all of them will be filled with the data you request.
2) The fields to be filled from the database. Here you have to put a text on the form ##<ADODataSet1>##<field>
Note that you can use the replaced field values inside a formula. For example, if you have in the cells:
A1: ## ADODataSet1##FirstName
A2: ## ADODataSet1##LastName
A3: (formula) =A1 &" " & A2
(value) ## ADODataSet1##FirstName ## ADODataSet1##LastName
After the report is run, you will get:
A3: (formula) =A1 &" " & A2
(Value) John Smith
But you can't replace more than one value in the same cell. For example, if you have in A1: ## ADODataSet1##FirstName ## ADODataSet1##LastName, this will not be replaced correctly.
Another thing to take in count, date and time fields. They will be passed as a number to Excel. So you must format the cell including the date (for example ##Client##SaleDate) with a date format.
Now, It's time to add the ranges
You have to define one named range for movies dataset you want to use, with the name "__<ADODataSet1>__" For example, if you want to populate the dataset "ADODataSet1" in the range A1:C3 you should:
Go to Excel and select Insert->Name->Define from the menu.
Create a "__ADODataSet1__"" range for A1:C3
Note that there are 2 "_", not one. It is "__<ADODataSet1>__", not "_<ADODataSet1>_"
You MUST use only "__<ADODataSet1>__" name for export movies database.
This range will be copied once for each entry of the Dataset, with the values replaced.
Note 1: Don't intersect ranges, or you are going to get strange results. Each range should be either completely inside or completely outside the others.
Note 2: The ranges affect the entire row that will be copied. Never put one range to the right or left of the other.
Note 3: It is possible to define some __XX__ ranges that don't correspond to any dataset. These ranges are not going to be copied, but values will be substituted
Note 4: Always define some Range that includes all the others