Excel Exporting Template

Using template to create excel report

customerNameproductNameproductLineorderDayorderMonthorderYearorderQuarterdollar_sales
Vitachrome Inc. 1937 Lincoln Berline Vintage Cars 10 1 2003 Q1 3,726
Vitachrome Inc. 1936 Mercedes-Benz 500K Special Roadster Vintage Cars 10 1 2003 Q1 1,768
Baane Mini Imports 1952 Alpine Renault 1300 Classic Cars 29 1 2003 Q1 5,572
Baane Mini Imports 1962 LanciaA Delta 16V Classic Cars 29 1 2003 Q1 5,026
Baane Mini Imports 1958 Setra Bus Trucks and Buses 29 1 2003 Q1 3,284
Baane Mini Imports 1940 Ford Pickup Truck Trucks and Buses 29 1 2003 Q1 3,308
Baane Mini Imports 1926 Ford Fire Engine Trucks and Buses 29 1 2003 Q1 1,283
Baane Mini Imports 1913 Ford Model T Speedster Vintage Cars 29 1 2003 Q1 2,489
Baane Mini Imports 1934 Ford V8 Coupe Vintage Cars 29 1 2003 Q1 2,164
Baane Mini Imports 18th Century Vintage Horse Carriage Vintage Cars 29 1 2003 Q1 2,173
Baane Mini Imports 1917 Maxwell Touring Car Vintage Cars 29 1 2003 Q1 3,970
Baane Mini Imports 1940s Ford truck Trucks and Buses 29 1 2003 Q1 3,531
Baane Mini Imports 1939 Cadillac Limousine Vintage Cars 29 1 2003 Q1 1,671
Baane Mini Imports 1962 Volkswagen Microbus Trucks and Buses 29 1 2003 Q1 3,864
Baane Mini Imports 1936 Chrysler Airflow Vintage Cars 29 1 2003 Q1 2,216
Baane Mini Imports 1980’s GM Manhattan Express Trucks and Buses 29 1 2003 Q1 2,866
Baane Mini Imports 1996 Peterbilt 379 Stake Bed with Outrigger Trucks and Buses 29 1 2003 Q1 2,851
Baane Mini Imports 1982 Camaro Z28 Classic Cars 29 1 2003 Q1 3,951
Euro+ Shopping Channel 1969 Corvair Monza Classic Cars 31 1 2003 Q1 4,469
Euro+ Shopping Channel 1957 Chevy Pickup Trucks and Buses 31 1 2003 Q1 4,567
Euro+ Shopping Channel 1998 Chrysler Plymouth Prowler Classic Cars 31 1 2003 Q1 3,262
Euro+ Shopping Channel 1964 Mercedes Tour Bus Trucks and Buses 31 1 2003 Q1 3,559
Euro+ Shopping Channel 1992 Ferrari 360 Spider red Classic Cars 31 1 2003 Q1 3,817
Euro+ Shopping Channel 1970 Triumph Spitfire Classic Cars 31 1 2003 Q1 4,530
Euro+ Shopping Channel 1970 Dodge Coronet Classic Cars 31 1 2003 Q1 1,821
Euro+ Shopping Channel 1958 Chevy Corvette Limited Edition Classic Cars 31 1 2003 Q1 1,338
Euro+ Shopping Channel 1992 Porsche Cayenne Turbo Silver Classic Cars 31 1 2003 Q1 2,768
Euro+ Shopping Channel 1954 Greyhound Scenicruiser Trucks and Buses 31 1 2003 Q1 1,818
Euro+ Shopping Channel 1950's Chicago Surface Lines Streetcar Trains 31 1 2003 Q1 2,771
Euro+ Shopping Channel Diamond T620 Semi-Skirted Tanker Trucks and Buses 31 1 2003 Q1 3,781
Euro+ Shopping Channel 1962 City of Detroit Streetcar Trains 31 1 2003 Q1 1,706
Danish Wholesale Imports 1972 Alfa Romeo GTA Classic Cars 11 2 2003 Q1 6,392
Danish Wholesale Imports 2001 Ferrari Enzo Classic Cars 11 2 2003 Q1 8,435
Danish Wholesale Imports 1969 Ford Falcon Classic Cars 11 2 2003 Q1 4,115
Danish Wholesale Imports 1903 Ford Model A Vintage Cars 11 2 2003 Q1 3,005
Danish Wholesale Imports Collectable Wooden Train Trains 11 2 2003 Q1 3,334
Danish Wholesale Imports 1904 Buick Runabout Vintage Cars 11 2 2003 Q1 3,095
Danish Wholesale Imports 18th century schooner Ships 11 2 2003 Q1 5,073
Danish Wholesale Imports 1912 Ford Model T Delivery Wagon Vintage Cars 11 2 2003 Q1 3,232
Danish Wholesale Imports 1940 Ford Delivery Sedan Vintage Cars 11 2 2003 Q1 3,774
Danish Wholesale Imports The Schooner Bluenose Ships 11 2 2003 Q1 2,214
Danish Wholesale Imports The Mayflower Ships 11 2 2003 Q1 2,512
Danish Wholesale Imports The USS Constitution Ship Ships 11 2 2003 Q1 1,882
Danish Wholesale Imports The Titanic Ships 11 2 2003 Q1 3,594
Danish Wholesale Imports The Queen Mary Ships 11 2 2003 Q1 2,185
Danish Wholesale Imports Pont Yacht Ships 11 2 2003 Q1 1,119
Rovelli Gifts 1980s Black Hawk Helicopter Planes 17 2 2003 Q1 4,825
Rovelli Gifts P-51-D Mustang Planes 17 2 2003 Q1 2,757
Rovelli Gifts 1999 Yamaha Speed Boat Ships 17 2 2003 Q1 3,315
Rovelli Gifts 1941 Chevrolet Special Deluxe Cabriolet Vintage Cars 17 2 2003 Q1 3,863



customerName{{all}}Q1Q2Q3Q4
Vitachrome Inc. 72497.64 5494.78 22602.36 0 44400.5
Baane Mini Imports 104224.79 50218.95 0 0 54005.84
Euro+ Shopping Channel 820689.54 285274.59 249673.72 64949.38 220791.85
Danish Wholesale Imports 129085.12 53959.21 54561.05 0 20564.86
Rovelli Gifts 127529.69 52151.81 0 0 75377.88



productName{{all}}Q1Q2Q3Q4
1937 Lincoln Berline 102563.52 21151.12 21166.56 19598.65 40647.19
1936 Mercedes-Benz 500K Special Roadster 46078.29 12146.66 8092.53 7590.47 18248.63
1952 Alpine Renault 1300 190017.96 43938.1 34943.71 33460.91 77675.24
1962 LanciaA Delta 16V 123123.01 32472.36 22874.64 19918.52 47857.49
1958 Setra Bus 119085.25 27629.37 23291.46 20586.1 47578.32



dollar_sales - sum
2004
2005
Total
Q3
Q4
Total
Q1
Total
AV Stores, Co.
Classic Cars
34737.87
34737.87
34737.87
Ships
19186.06
19186.06
19186.06
Trains
7873.58
7873.58
7873.58
Vintage Cars
38186.89
38186.89
38186.89
Total
99984.4
99984.4
99984.4
Alpha Cognac
Ships
12432.32
12432.32
12432.32
Total
12432.32
12432.32
12432.32
Amica Models & Co.
Classic Cars
26424.11
26424.11
26424.11
Ships
6251.22
6251.22
6251.22
Trains
2018.72
2018.72
2018.72
Trucks and Buses
2352
2352
2352
Vintage Cars
45177.18
45177.18
45177.18
Total
82223.23
82223.23
82223.23
Anna's Decorations, Ltd
Classic Cars
18187.89
18187.89
18187.89
Trucks and Buses
27396.76
27396.76
27396.76
Vintage Cars
11347.65
11347.65
11347.65
Total
56932.3
56932.3
56932.3
Atelier graphique
Motorcycles
6066.78
6066.78
6066.78
Vintage Cars
1676.14
1676.14
1676.14
Total
6066.78
1676.14
7742.92
7742.92
Total
88290.01
101660.54
189950.55
69364.62
69364.62
259315.17
Description

Excel package of KoolReport is able to export data from database or any other kinds of datasoure to excel file. Only that, it is able to create charts and graphs in excel files.

This example demonstrates how to use PHP template file to dynamically customize exported excel files. The template using familiar html and widgets that allows you to create excel file easily.