ExcelExporter REALbasic Classes

StyleGridExcelExporter.PopulateSheet Method

Call this method to populate a ExcelExporterSheet object.

PopulateSheet(
   sheet as ExcelExporterSheet,
   inGrid as StyleGrid)

Parameters

sheet
The Worksheet to populate.
inGrid
The StyleGrid to populate the sheet with.

Remarks

Dim f as FolderItem
Dim exporter as StyleGridExcelExporter
Dim workbook as ExcelExporterWorkbook
Dim sheet as ExcelExporterSheet

f = GetSaveFolderItem("Excel","Test.xls")

if f <> nil then
    exporter = new StyleGridExcelExporter()
    workbook = exporter.Workbook
   
    workbook.Author = "Bjorn Eiriksson"
    workbook.LastAuthor = "Bjorn Eiriksson"
    workbook.Company = "Einhugur Software"
    workbook.CreatedDate = new Date()
    exporter.ExportHeader = chkIncludeHeader.Value
   
    sheet = workbook.Sheet(1)
    sheet.Name = "Grid 1"
    sheet.Column(1).DefineNumeric()
   
    exporter.PopulateSheet(sheet,StyleGrid1)
   
    sheet.PageLayoutView = chkViewPageLayout.Value
   
    // Change something in the Grid to show the sheets will be different
    StyleGrid1.CellText(1,2) = "Hello World"
   
    // Add a second sheet to the workbook
    sheet = workbook.Sheet(2)
    sheet.Name = "Grid 2"
    sheet.Column(1).DefineNumeric()
   
    exporter.PopulateSheet(sheet,StyleGrid1)
   
    exporter.Save(f)
end if

See Also

StyleGridExcelExporter Class