Microsoft .NET Excel to Multiple DataGrid Sample
Using C# and SpreadsheetGear
Total Sales for Year
DescriptionQ1Q2Q3Q4
Basil$24,863.06 $32,349.44$39,334.34 $25,830.20
Black Pepper - Fine$49,475.53 $36,014.55$32,280.04 $33,727.20
Cayenne Pepper$57,547.77 $72,075.36$77,848.89 $65,364.18
Chili Powder$40,418.82 $35,781.33$47,301.80 $36,558.73
Cumin - Ground$52,280.15 $46,150.65$34,390.98 $37,587.29
Garlic Powder$36,677.69 $26,098.85$26,815.25 $32,860.87
Marjoram$63,967.68 $61,813.08$52,755.78 $49,256.55
Onion Powder$20,305.96 $35,360.31$24,172.53 $20,638.29
Oregano$35,045.79 $43,938.05$36,531.82 $48,503.78
Red Pepper - Crushed$51,610.39 $32,504.29$46,443.67 $33,595.64
Rosemary$64,981.14 $58,625.07$69,402.06 $52,524.36
Thyme$78,507.24 $59,857.98$68,608.05 $63,448.98
 $575,681.22 $540,568.96 $555,885.21 $499,896.07

Q1 Sales
Product IDDescriptionUnitsUnit CostTotal Sales
10001Basil12494$1.99$24,863.06
10002Black Pepper - Fine16547$2.99$49,475.53
10003Cayenne Pepper14423$3.99$57,547.77
10201Chili Powder13518$2.99$40,418.82
10202Cumin - Ground17485$2.99$52,280.15
10203Garlic Powder18431$1.99$36,677.69
10401Marjoram16032$3.99$63,967.68
10402Onion Powder10204$1.99$20,305.96
10403Oregano11721$2.99$35,045.79
10801Red Pepper - Crushed17261$2.99$51,610.39
10802Rosemary16286$3.99$64,981.14
10803Thyme19676$3.99$78,507.24

Q2 Sales
Product IDDescriptionUnitsUnit CostTotal Sales
10001Basil16256$1.99$32,349.44
10002Black Pepper - Fine12045$2.99$36,014.55
10003Cayenne Pepper18064$3.99$72,075.36
10201Chili Powder11967$2.99$35,781.33
10202Cumin - Ground15435$2.99$46,150.65
10203Garlic Powder13115$1.99$26,098.85
10401Marjoram15492$3.99$61,813.08
10402Onion Powder17769$1.99$35,360.31
10403Oregano14695$2.99$43,938.05
10801Red Pepper - Crushed10871$2.99$32,504.29
10802Rosemary14693$3.99$58,625.07
10803Thyme15002$3.99$59,857.98

Q3 Sales
Product IDDescriptionUnitsUnit CostTotal Sales
10001Basil19766$1.99$39,334.34
10002Black Pepper - Fine10796$2.99$32,280.04
10003Cayenne Pepper19511$3.99$77,848.89
10201Chili Powder15820$2.99$47,301.80
10202Cumin - Ground11502$2.99$34,390.98
10203Garlic Powder13475$1.99$26,815.25
10401Marjoram13222$3.99$52,755.78
10402Onion Powder12147$1.99$24,172.53
10403Oregano12218$2.99$36,531.82
10801Red Pepper - Crushed15533$2.99$46,443.67
10802Rosemary17394$3.99$69,402.06
10803Thyme17195$3.99$68,608.05

Q4 Sales
Product IDDescriptionUnitsUnit CostTotal Sales
10001Basil12980$1.99$25,830.20
10002Black Pepper - Fine11280$2.99$33,727.20
10003Cayenne Pepper16382$3.99$65,364.18
10201Chili Powder12227$2.99$36,558.73
10202Cumin - Ground12571$2.99$37,587.29
10203Garlic Powder16513$1.99$32,860.87
10401Marjoram12345$3.99$49,256.55
10402Onion Powder10371$1.99$20,638.29
10403Oregano16222$2.99$48,503.78
10801Red Pepper - Crushed11236$2.99$33,595.64
10802Rosemary13164$3.99$52,524.36
10803Thyme15902$3.99$63,448.98
Copyright 2005 © SpreadsheetGear LLC. All Rights Reserved.
www.spreadsheetgear.com