SoftArtisans ExcelWriter Guide

Object Model

ExcelWriter includes two separate components:

ExcelApplication
Represents an Excel spreadsheet. The ExcelApplication object creates several additional objects, each of which represents some aspect of an Excel spreadsheet. The sub-objects are listed in the table below. Create an instance of the ExcelApplication object, as follows.
```
	Set xlw = Server.CreateObject("Softartisans.ExcelWriter")
```

ExcelTemplate
Represents a template spreadsheet. To create an instance of the ExcelTemplate object, use,
```
	Set objTemplate = Server.CreateObject("SoftArtisans.ExcelTemplate")
```

ExcelApplication

Object	Properties and Methods
Principal object ExcelApplication	AnsiToUnicode, ContentType, CreateFont, CreateStyle, GetDataFromDataSet, NamedRange, Open, Save, ShowHScrollBar, ShowVScrollBar*, SpreadsheetsCreatedToday, Style, UnicodeToAnsi, Version, VersionEX, Worksheets
Worksheets	Add, Count, Item
Worksheet	Cells, Charts, Copy, FreezePanes, Name, PageSetup, Pictures, SelectSheet, ShowGridlines, ShowRowColHeaders, Visible, WriteProtect, Zoom*
Cells	AddHyperlink, Cell, Columns, ColumnWidth, CopyFromRecordset, GetCellAt, GetDataFromExcelSheet, GetDataFromRecordset, GroupColumns, GroupRows, HPageBreak, Item, MergeCells, PreserveStrings, Range, RowHeight, Rows, StandardHeight, StandardWidth, SummaryColumn, SummaryRow, VPageBreak*
Cell	ClearContents, Col, Format, Formula, Name, PutValue, Row, Style, Value
Range	AddHyperlink, Area, AreaCount, AutoFitHeight, AutoFitWidth, Cell, ColumnCount, ColumnWidth, FirstColumn, FirstRow, GetCellAt, GroupColumns, GroupRows, Intersect, Item, MergeCells, Name, RowCount, RowHeight, Style, Union, Value*
Style	BackgroundColor, BorderColor, BorderLineStyle, ForegroundColor, Font, Hidden, HorizontalAlignment, Locked, Name, Number, Orientation, Pattern, VerticalAlignment, WrapText
Font	Bold, Charset, Color, Italic, Name, QueryFontDisp, Size, Strikethrough, Subscript, Superscript, Underline, Weight*
Charts	Add, Count, Item
Chart	BopPopGapSize, BopPopSecondPieSize, BopPopSplitType, BopPopSplitValue, CategoryAxis, ChartArea, DataTable, DataTableHasHorizontalBorders, DataTableHasVerticalBorders, DataTableShowsSeriesKeys, FillSurfaceArea, Legend, LegendLocation, LegendVertical, Move, PlotArea, RectangleCorner, SeriesCollection, SetChartType, ShowDataTable, ShowCategoryAndValueAsPercent, ShowHorizontal, ShowLegend, ShowValueAsPercent, SizeOfCenterHole, SliceDistanceFromCenter, SpaceBetweenBars, SpaceBetweenCategories, StackDisplayedValues, Subtype, Title, Type, Valueaxis, View3D
SeriesCollection	Add, CategoryData, Item, LabelShowActualValue, LabelShowCategoryAndValueAsPercent, LabelShowCategoryLabel, LabelShowValueAsPercent
Series	Area, Border, ErrorBar, ErrorBarLine, HasSmoothedLine, LabelFrame, LabelShowActualValue, LabelShowCategoryAndValueAsPercent, LabelShowCategoryLabel, LabelShowValueAsPercent, MarkerFormat, MarkerType, Name, ScatterValues, Values , XErrorBarCustomMinusValues, XErrorBarCustomPlusValues, XErrorBarTShaped, XErrorBarValue, XErrorBarValueSource, YErrorBarCustomMinusValues, YErrorBarCustomPlusValues, YErrorBarTShaped, YErrorBarValue, YErrorBarValueSource
3DProperties	ChartDepth, DistanceFromEyeToChart, ElevationAngle, PlotVolumeHeight, RotationAngle, SeriesGapDepth, Show3D, Stack3DColumns, UseAutoScaling, UsePerspectiveTransform, ZAxis
Axis	AxisCrossesMidCategory, AxisLine, CategoryAxisCrossMaxValue, CategoryCrossingValue, LabelFont, LabelPosition, LogarithmicScale, MajorGridline, MajorIncrement, MajorTickType, MaxValue, MinorGridline, MinorIncrement, MinorTickType, MinValue, Number, Title, Type, ValuesInReverseOrder, Wall3D, Wall3DBorder
ChartFrame	Area, Border, HasShadow, Height, Number, Text, TextFont, TextHorizontalAlignment, TextRotationAngle, TextVerticalAlignment, Width, X, Y
Line	LineColor, LineFormatting, LineStyle, LineWeight
Area*	AreaFormatting, BackgroundColor, ForegroundColor, Pattern
Pictures*	Count, CreateFromFile, Item*
Picture*	AreaBackgroundColor, AreaForegroundColor, AreaPattern, BorderColor, BorderLineType, BorderWeight, HasShadow, LowerDeltaX, LowerDeltaY, UpperDeltaX, UpperDeltaY*
PageSetup*	BlackAndWhite, BottomMargin, CenterFooter, CenterHeader, CenterHorizontally, CenterVertically, Draft, FirstPageNumber, FitToPagesTall, FitToPagesWide, FooterMargin, GetPrintTitles, HeaderMargin, LeftFooter, LeftHeader, LeftMargin, Order, Orientation, PaperSize, PrintArea, PrintComments, PrintGridlines, PrintHeadings, PrintNotes, PrintQuality, RightFooter, RightHeader, RightMargin, SetPrintTitleColumns, SetPrintTitleRows, TopMargin, Zoom
This feature is not* available in ExcelWriterSE, ExcelWriterLE, or ExcelWriterFree.

ExcelTemplate

Object	Properties and Methods
ExcelTemplate	AnsiToUnicode, ContentType, DataSource, Open, PreserveStrings, Process, SpreadsheetsCreatedToday, UnicodeToAnsi

Top