Creating Worksheets


With ComponentOne Excel for .NET you can create Microsoft Excel files directly from your application's code. The possibilities are endless with an easy-to-manipulate Excel object model exposed in your code. Create Excel files from data that doesn't directly support Excel exportation like any grid, schedule or chart. Excel for .NET supports formulas, cell styles and Excel formatting. This sample creates a workbook with NorthWind product information using the C1XLBook control. Each product category is placed on a separate worksheet.