Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search
Home
Docs
Support Resources
.
Spaces
Quick Search
Help
Online Help
Keyboard Shortcuts
Feed Builder
What’s new
Available Gadgets
About Confluence
Log In
ExcelWriter v8 Docs
Space Shortcuts
Installation
System Requirements
Change Log
Page tree
Browse pages
Configure
Space tools
View Page
Tools
A
t
tachments (0)
Page History
Restrictions
Page Information
Link to this Page…
View in Hierarchy
View Source
Export to PDF
Export to Word
Pages
…
ExcelWriter Introduction
API Reference
ExcelApplication API
Area
Page Information
Title:
Area
Author:
Anonymous
Aug 01, 2011
Last Changed by:
Anonymous
Aug 01, 2011
Tiny Link:
(useful for email)
https://wiki.softartisans.com/x/BgQe
Export As:
PDF
·
Word
Incoming Links
ExcelWriter v8 Docs (41)
Page:
Range.Item(Int32)
Page:
SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)
Page:
Area.ImportData(System.Data.DataTable)
Page:
Workbook.CreateDataImportProperties()
Page:
Area.ImportData(System.Data.DataTable, DataImportProperties)
Page:
Areas and Ranges
Page:
Worksheet.CreateAreaOfColumns(Int32, Int32)
Page:
SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList, DataImportProperties)
Page:
Area.ImportData(System.Data.IDataReader)
Page:
PageSetup.PrintTitles
Page:
Workbook.CreateConditionalFormat()
Page:
Area.ToString()
Page:
Area.ImportData(System.Data.DataView)
Page:
Creating a Basic PivotTable
Page:
Workbook.CreateRange(String)
Page:
Workbook.CreateDataValidation(DataValidation.ValidationType, DataValidation.ComparisonType, Object)
Page:
Area.ImportData(Object(,), String(), DataImportProperties)
Page:
Workbook.CreateNamedRange(Area(), String)
Page:
Worksheet.CreateArea(String)
Page:
Workbook.CreateDataValidation(DataValidation.ValidationType, DataValidation.ComparisonType, String)
Page:
Workbook.CreateDataValidation(DataValidation.ValidationType, String)
Page:
DataImportProperties
Page:
Hyperlink.Area
Page:
Worksheet.CreateArea(Int32, Int32, Int32, Int32)
Page:
Workbook.CreateDataValidation(DataValidation.ValidationType, Object)
Page:
Range.AreaCount
Page:
PivotTable.ChangeDataSource(Area)
Page:
Area.ImportData(System.Data.DataView, DataImportProperties)
Page:
SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)
Page:
Area.ImportData(Object()(), String(), DataImportProperties)
Page:
AutoFilter.Area
Page:
SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList)
Page:
Area.ImportData(System.Data.IDataReader, DataImportProperties)
Page:
Workbook.CreateNamedRange(String, String)
Page:
Workbook.CreateRange(Area())
Page:
Area.ImportData(Object(,))
Page:
Worksheet.CreateAreaOfRows(Int32, Int32)
Page:
Area.ImportData(Object()())
Page:
Workbook.CreateDataValidation(DataValidation.ValidationType, DataValidation.ComparisonType, String, String)
Page:
Workbook.CreateDataValidation(DataValidation.ValidationType, DataValidation.ComparisonType, Object, Object)
Page:
Hyperlink
Hierarchy
Parent Page
Page:
ExcelApplication API
Children (35)
Page:
Area.AllColumnWidths
Page:
Area.AllColumnWidthsInChars
Page:
Area.AllRowsHeight
Page:
Area.ApplyStyle(Style)
Page:
Area.ArrayFormula
Page:
Area.AutoFitHeight()
Page:
Area.AutoFitWidth()
Page:
Area.BorderAround
Page:
Area.ClearContent()
Page:
Area.ColumnCount
Show all...
Page:
Area.CreateHyperlink(String)
Page:
Area.Dimensions
Page:
Area.FirstColumn
Page:
Area.FirstRow
Page:
Area.GetColumnWidth(Int32)
Page:
Area.GetColumnWidthInChars(Int32)
Page:
Area.GetRowHeight(Int32)
Page:
Area.GroupColumns(Boolean)
Page:
Area.GroupRows(Boolean)
Page:
Area.ImportData
Page:
Area.Item(Int32, Int32)
Page:
Area.MergeCells()
Page:
Area.PopulatedCells
Page:
Area.RemoveConditionalFormat()
Page:
Area.RowCount
Page:
Area.SetColumnWidth(Int32, Double)
Page:
Area.SetColumnWidthInChars(Int32, Double)
Page:
Area.SetConditionalFormat(ConditionalFormat)
Page:
Area.SetDataValidation(DataValidation)
Page:
Area.SetRowHeight(Int32, Double)
Page:
Area.SetStyle(Style)
Page:
Area.ToString()
Page:
Area.UngroupColumns()
Page:
Area.UngroupRows()
Page:
Area.WorksheetIndex
Hide...
Labels
There are no labels assigned to this page.
Hot Referrers
(14)
wiki.softartisans.com/display/EW8/Area
(14)
search.daum.net/
(7)
www.officewriter.com/searchresults?search=area
(4)
www.officewriter.com/searchresults?search=border+cell
(3)
wiki.softartisans.com/pages/viewinfo.action?pageId=1967110
(2)
https://wiki.softartisans.com/display/EW8/ExcelApplication+…
(2)
https://wiki.softartisans.com/display/EW8/Range.Areas
(2)
www.officewriter.com/searchresults?search=color
(2)
www.officewriter.com/searchresults?search=Two-dimensional+A…
(2)
blog.softartisans.com/2013/12/31/kb-excel-charts-dont-follo…
Recent Changes
Time
Editor
Aug 01, 2011 14:52
Anonymous
View Changes
Migration of unmigrated content due to installation of a new plugin
Aug 01, 2011 14:52
Anonymous
View Changes
Migration of unmigrated content due to installation of a new plugin
Aug 01, 2011 14:52
Anonymous
View Changes
Migration of unmigrated content due to installation of a new plugin
Aug 01, 2011 14:52
Anonymous
View Changes
Migration of unmigrated content due to installation of a new plugin
Aug 01, 2011 14:52
Anonymous
Migrated to Confluence 4.0
View Page History
Outgoing Links
ExcelWriter v8 Docs (49)
Page:
Area.RowCount
Page:
Area.MergeCells()
Page:
Area
Page:
Area.CreateHyperlink(String)
Page:
Area.GetColumnWidthInChars(Int32)
Page:
Area.GetColumnWidth(Int32)
Page:
Area.UngroupRows()
Page:
SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList)
Page:
Area.ImportData(Object()())
Page:
Area.FirstRow
Page:
Area.ApplyStyle(Style)
Page:
Area.SetStyle(Style)
Page:
Area.SetColumnWidth(Int32, Double)
Page:
Area.ImportData(System.Data.DataView)
Page:
Area.ImportData(System.Data.DataTable)
Page:
Area.GroupColumns(Boolean)
Page:
Area.Item(Int32, Int32)
Page:
SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList)
Page:
Area.ArrayFormula
Page:
Area.ImportData(System.Data.IDataReader, DataImportProperties)
Page:
Area.AutoFitHeight()
Page:
Area.WorksheetIndex
Page:
Area.ClearContent()
Page:
Area.ImportData(System.Data.DataTable, DataImportProperties)
Page:
Area.FirstColumn
Page:
Area.AutoFitWidth()
Page:
Area.ImportData(Object()(), String(), DataImportProperties)
Page:
Area.ColumnCount
Page:
Area.UngroupColumns()
Page:
Area.AllColumnWidths
Page:
Area.GroupRows(Boolean)
Page:
Area.SetColumnWidthInChars(Int32, Double)
Page:
Area.BorderAround
Page:
Area.ImportData(Object(,))
Page:
Area.SetDataValidation(DataValidation)
Page:
Area.RemoveConditionalFormat()
Page:
Area.ImportData(System.Data.IDataReader)
Page:
Area.PopulatedCells
Page:
Area.AllColumnWidthsInChars
Page:
Area.ImportData(System.Data.DataView, DataImportProperties)
Page:
Area.AllRowsHeight
Page:
Area.ImportData(Object(,), String(), DataImportProperties)
Page:
Area.Dimensions
Page:
SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPList, DataImportProperties)
Page:
SharePointIntegration.ImportData(Area, Microsoft.SharePoint.SPView, Microsoft.SharePoint.SPList, DataImportProperties)
Page:
Area.SetRowHeight(Int32, Double)
Page:
Area.ToString()
Page:
Area.SetConditionalFormat(ConditionalFormat)
Page:
Area.GetRowHeight(Int32)
Overview
Content Tools