ExcelExporter REALbasic Classes |
|
StyleGridExcelExporter.PopulateSheet Method
Call this method to populate a ExcelExporterSheet object.
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