Insert DataTable into Excel Workbook with Formats and Formulas
Using C# and SpreadsheetGear for .NET
Product IDDescriptionUnitsUnit CostTotal Cost
10001Basil275$1.99$547.25
10002Black Pepper - Fine325$2.99$971.75
10003Cayenne Pepper150$3.99$598.50
10201Chili Powder500$2.99$1,495.00
10202Cumin - Ground75$2.99$224.25
10203Garlic Powder600$1.99$1,194.00
10401Marjoram250$3.99$997.50
10402Onion Powder300$1.99$597.00
10403Oregano425$2.99$1,270.75
10801Red Pepper - Crushed250$2.99$747.50
10802Rosemary175$3.99$698.25
10803Thyme225$3.99$897.75
   Total$10,239.50
Copyright 2005 © SpreadsheetGear LLC. All Rights Reserved.
www.spreadsheetgear.com