Topics

• Page Life Cycle
• Find Control by ID
• Getting started with epplus
• Formatting values
• Saving the Excel document
• Styling the Excel document
• Filling the document with data
• Creating formulas and calculate ranges
• Creating charts
• Importing data from existing file
• Append data to existing document
• Columns and Rows
• Pivot Table

Examples

• Code Example
• Accessing the TextBox Control in aspx Page
• Find a control in a GridView, Repeater, ListView etc.
• Installation
• Number formatting
• Date formatting
• Getting started
• Save to disk
• Send to the Browser
• Save to disk with SaveFileDialog
• Background color
• Border styles
• Font styles
• Text alignment and word wrap
• Autofit columns
• Complete example with all styles
• Add an image to a sheet
• Fill with a DataTable
• Fill with a DataTable from an SQL query or Stored Procedure
• Manually fill cells
• Fill from collection
• Add formulas to a cell
• Formula with multiple sheets
• Manual calculation
• Complete example with formulas
• Pie Chart
• Line Chart
• Import data from Excel file
• Import data from CSV file
• Appending data
• Creating a Pivot Table
• Import data from Excel file with FileUpload Control
• Create a DataTable from Excel File