//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); #region Define custom classes //public class SalesRecord //{ // public string Area; // public string Salesman; // public string Product; // public string ProductType; // public int Sales; //} #endregion #region Init data var record = new SalesRecord { Area = "North America", City = "Chicago", Category = "Consumer Electronics", Name = "Bose 785593-0050", Revenue = 92800 }; #endregion IWorksheet worksheet = workbook.Worksheets[0]; // Set binding path for cell. worksheet.Range["A1"].BindingPath = "Area"; worksheet.Range["B2"].BindingPath = "City"; worksheet.Range["C2"].BindingPath = "Name"; worksheet.Range["D3"].BindingPath = "Revenue"; // Set data source. worksheet.DataSource = record; // Save to an excel file workbook.Save("CellBinding.xlsx");
' Create a new Workbook Dim workbook As New Workbook #Region "Define custom classes" 'Public Class SalesRecord ' Public Area As String ' Public City As String ' Public Category As String ' Public Name As String ' Public Revenue As Integer 'End Class #End Region #Region "Init data" Dim record As New SalesRecord With { .Area = "North America", .City = "Chicago", .Category = "Consumer Electronics", .Name = "Bose 785593-0050", .Revenue = 92800 } #End Region Dim worksheet As IWorksheet = workbook.Worksheets(0) ' Set binding path for cell. worksheet.Range!A1.BindingPath = "Area" worksheet.Range!B2.BindingPath = "City" worksheet.Range!C2.BindingPath = "Name" worksheet.Range!D3.BindingPath = "Revenue" ' Set data source. worksheet.DataSource = record ' save to an excel file workbook.Save("CellBinding.xlsx")