Farpoint使用基础.ppt

Farpoint使用基础 文档编号 HD600 内容提要 了解产品入门使用SpreadDesigner Spread设计器 控制外观控制交互管理单元格类型管理公式管理控件的数据管理数据绑定管理文件操作管理打印管理输入映射使用模型 了解产品 结构图 入门 安装 略 添加项目引用 入门 选择以下组件 入门 向工具箱添加控件 入门 单击浏览 入门 选择如下dll 入门 向窗体添加控件 入门 控件名称约定 入门 可以在属性编辑器修改属性 使用SpreadDesigner Spread设计器 打开编辑器 使用SpreadDesigner Spread设计器 编辑器结构 控制外观 重点 添加一个sheet页 CreateanewsheetFarPoint Win Spread SheetViewnewsheet newFarPoint Win Spread SheetView newsheet SheetName North newsheet ColumnCount 10 newsheet RowCount 100 AddthenewsheettothecontrolfpSpread1 Sheets Add newsheet 控制外观 删除一个sheet页 RemovethesecondsheetfpSpread1 Sheets Remove fpSpread1 Sheets 1 控制外观 设置背景色 Setthefirstsheet sbackgroundcolortolightyellowfpSpread1 Sheets 0 GrayAreaBackColor Color LightYellow 控制外观 重点 设置网格线样式FarPoint Win Spread GridLineHGridLine newFarPoint Win Spread GridLine FarPoint Win Spread GridLineType Flat Color Red FarPoint Win Spread GridLineVGridLine newFarPoint Win Spread GridLine FarPoint Win Spread GridLineType Flat Color Chartreuse fpSpread1 Sheets 0 HorizontalGridLine HGridLine fpSpread1 Sheets 0 VerticalGridLine VGridLine 控制外观 设置角样式fpSpread1 ActiveSheet SheetCornerStyle BackColor Color Blue 控制外观 应用默认样式FarPoint Win Spread DefaultSkins Colorful2 Apply fpSpread1 Sheets 0 控制外观 定义并应用默认样式 CreateacustomskinFarPoint Win Spread SheetSkinmyskin newFarPoint Win Spread SheetSkin MySkin Color AliceBlue Color BlanchedAlmond Color Navy Color CornflowerBlue FarPoint Win Spread GridLines Both Color Coral Color Navy Color Bisque Color Crimson Color AntiqueWhite Color BlanchedAlmond true true true true true Applythecustomskintothefirstsheetinthecontrolmyskin Apply fpSpread1 Sheets 0 控制外观 重点 设置表格行列数fpSpread1 Sheets 0 ColumnCount 10 fpSpread1 Sheets 0 RowCount 100 添加列fpSpread1 Sheets 0 AddColumns 6 2 删除列fpSpread1 Sheets 0 RemoveColumns 6 2 控制外观 重点 定义列宽 Setsecondcolumnwidthto100fpSpread1 Sheets 0 Columns 1 Width 100 控制外观 重点 设置交叉列样式fpSpread1 Sheets 0 AlternatingRows Count 3 fpSpread1 Sheets 0 AlternatingRows 1 BackColor Color LightBlue fpSpread1 Sheets 0 AlternatingRows 1 ForeColor Color Navy fpSpread1 Sheets 0 AlternatingRows 2 BackColor Color LightYellow fpSpread1 Sheets 0 AlternatingRows 2 ForeColor Color Navy 控制外观 重点 不显示行标题 TurnoffdisplayofrowheadersfpSpread1 Sheets 0 RowHeaderVisible false 控制外观 定义列标题的文本显示模式为数字 SetthecolumnheadertodisplaynumbersinsteadoflettersfpSpread1 Sheets 0 ColumnHeaderAutoText FarPoint Win Spread HeaderAutoText Numbers 控制外观 设置列标题文本 SetcustomtextforcolumnsAthroughDfpSpread1 Sheets 0 ColumnHeader Columns 0 Label North fpSpread1 Sheets 0 ColumnHeader Columns 1 Label South fpSpread1 Sheets 0 ColumnHeader Columns 2 Label East fpSpread1 Sheets 0 ColumnHeader Columns 3 Label West 控制外观 控制行标题行数 DisplaytwocolumnheaderrowsfpSpread1 Sheets 0 ColumnHeaderRowCount 3 控制外观 控制单元格背景色fpSpread1 Sheets 0 Cells 0 0 BackColor Color Azure fpSpread1 Sheets 0 Cells 2 2 3 3 BackColor Color Bisque 控制外观 重点 控制对齐方式fpSpread1 Sheets 0 Cells 0 0 HorizontalAlignment FarPoint Win Spread CellHorizontalAlignment Right fpSpread1 Sheets 0 Cells 0 0 VerticalAlignment FarPoint Win Spread CellVerticalAlignment Bottom fpSpread1 Sheets 0 Cells 2 2 3 3 HorizontalAlignment FarPoint Win Spread CellHorizontalAlignment Center fpSpread1 Sheets 0 Cells 2 2 3 3 VerticalAlignment FarPoint Win Spread CellVerticalAlignment Center 控制外观 重点 控制外观 设置边框 CreatethebevelborderFarPoint Win BevelBorderbevelbrdr newFarPoint Win BevelBorder FarPoint Win BevelBorderType Raised Color Cyan Color DarkCyan SetcellB3bordertothebevelborderfpSpread1 Sheets 0 Cells 4 3 Border bevelbrdr 控制外观 边框设置 CreateanewcomplexbordersidewiththreelinesFarPoint Win ComplexBorderSidebevelbrdr newbottomborderAsNewFarPoint Win ComplexBorderSide True Color Black 3 Drawing2D DashStyle Solid Nothing NewSingle 0 1 0 2 0 3 0 6 0 7 0 9 FpSpread1 Sheets 0 Cells 3 7 Border NewFarPoint Win ComplexBorder leftborder Nothing Nothing bottomborder 控制外观 设置备注FarPoint Win Spread Cellrange1 range1 fpSpread1 ActiveSheet Cells 1 1 3 3 range1 Value ValueHere range1 Note Thisisthenotethatdescribesthevalue 控制外观 合并单元格 CreatesomecontentintwocellsfpSpread1 ActiveSheet Cells 1 1 Text Thesesixcellsarespanned fpSpread1 ActiveSheet Cells 2 2 Text Thisistextin2 2 SpansixcellsincludingtheoneswithdifferentcontentfpSpread1 ActiveSheet AddSpanCell 1 1 2 3 控制外观 重点 自动合并fpSpread1 Sheets 0 SetRowMerge 1 FarPoint Win Spread Model MergePolicy Always fpSpread1 Sheets 0 SetColumnMerge 1 FarPoint Win Spread Model MergePolicy Always 控制外观 重点 设置溢出长度fpSpread1 AllowCellOverflow true fpSpread1 SetMaximumCellOverflowWidth 130 控制外观 重点 应用自定义样式FarPoint Win Spread NamedStylebackstyle newFarPoint Win Spread NamedStyle BlueBack backstyle BackColor Color Blue FarPoint Win Spread NamedStyletext1style newFarPoint Win Spread NamedStyle OrangeText BlueBack text1style ForeColor Color Orange FarPoint Win Spread NamedStyletext2style newFarPoint Win Spread NamedStyle YellowText BlueBack text2style ForeColor Color Yellow fpSpread1 NamedStyles Add backstyle fpSpread1 NamedStyles Add text1style fpSpread1 NamedStyles Add text2style fpSpread1 ActiveSheet Cells 0 0 4 0 StyleName OrangeText fpSpread1 ActiveSheet Cells 0 1 4 1 StyleName YellowText 控制交互 重点 默认表格行为 控制交互 重点 默认图形行为 控制交互 重点 自定义行为 CreateInputMapobjectFarPoint Win Spread InputMapinputmap1 Setobjectequaltoexistingmapinputmap1 fpSpread1 GetInputMap FarPoint Win Spread InputMapMode WhenAncestorOfFocused MapEnterkeyinputmap1 Put newFarPoint Win Spread Keystroke Keys Enter Keys None FarPoint Win Spread SpreadActions MoveToNextRow CreateInputMapobjectFarPoint Win Spread InputMapinputmap2 Setobjectequaltoexistingmapinputmap2 fpSpread1 GetInputMap FarPoint Win Spread InputMapMode WhenFocused MapEnterkeyinputmap2 Put newFarPoint Win Spread Keystroke Keys Enter Keys None FarPoint Win Spread SpreadActions MoveToNextRow 控制交互 重点 控制仅能选择单元格 UserscanselectonlycellsfpSpread1 SelectionBlockOptions FarPoint Win Spread SelectionBlockOptions Cells SetoperationmodeandletusersselectmultipleblocksofcellsfpSpread1 Sheets 0 OperationMode FarPoint Win Spread OperationMode Normal fpSpread1 Sheets 0 SelectionPolicy FarPoint Win Spread Model SelectionPolicy MultiRange 控制交互 多区域选择 SetthesheettoallowmultiplerangeselectionsfpSpread1 Sheets 0 SelectionPolicy FarPoint Win Spread Model SelectionPolicy MultiRange SelectcellsC3throughD4fpSpread1 Sheets 0 AddSelection 2 2 2 2 SelectcellsF6throughH8fpSpread1 Sheets 0 AddSelection 5 5 3 3 控制交互 控制滚动条FarPoint Win Spread FpSpreadfpSpread1 newFarPoint Win Spread FpSpread FarPoint Win Spread SheetViewshv newFarPoint Win Spread SheetView fpSpread1 Location newPoint 10 10 fpSpread1 Height 250 fpSpread1 Width 400 Controls Add fpSpread1 fpSpread1 Sheets Add shv fpSpread1 HorizontalScrollBarPolicy FarPoint Win Spread ScrollBarPolicy Always fpSpread1 VerticalScrollBarPolicy FarPoint Win Spread ScrollBarPolicy AsNeeded fpSpread1 HorizontalScrollBarHeight 30 fpSpread1 VerticalScrollBarWidth 30 fpSpread1 ScrollBarMaxAlign true fpSpread1 ScrollBarShowMax true fpSpread1 ScrollBarTrackPolicy FarPoint Win Spread ScrollBarTrackPolicy Horizontal fpSpread1 ScrollTipPolicy FarPoint Win Spread ScrollTipPolicy Vertical 控制交互 理解viewport 控制当前选择对象时会用到 控制交互 调整viewport 暂时翻成视区 控制交互 代码控制视区fpSpread1 AddViewport 1 2 fpSpread1 SetViewportLeftColumn 1 3 fpSpread1 SetViewportTopRow 0 6 fpSpread1 SetViewportPreferredHeight 0 100 fpSpread1 SetViewportPreferredWidth 0 100 控制交互 视区滚动条fpSpread1 ColumnSplitBoxAlignment FarPoint Win Spread SplitBoxAlignment Leading fpSpread1 RowSplitBoxAlignment FarPoint Win Spread SplitBoxAlignment Trailing fpSpread1 ColumnSplitBoxPolicy FarPoint Win Spread SplitBoxPolicy AsNeeded fpSpread1 RowSplitBoxPolicy FarPoint Win Spread SplitBoxPolicy Always 控制交互 是否允许拖放fpSpread1 AllowDragDrop true 控制交互 拖拽填充fpSpread1 AllowDragFill true 控制交互 提示文本框FarPoint Win Spread FpSpreadfpSpread1 newFarPoint Win Spread FpSpread FarPoint Win Spread SheetViewshv newFarPoint Win Spread SheetView fpSpread1 Location newPoint 10 10 fpSpread1 Height 200 fpSpread1 Width 400 Controls Add fpSpread1 fpSpread1 Sheets Add shv fpSpread1 ActiveSheet SetValue 0 0 TestTextTip fpSpread1 TextTipPolicy FarPoint Win Spread TextTipPolicy Floating fpSpread1 TextTipDelay 1000 MessageBox Show Placethepointeroverthetexttoseethetexttip MessageBoxButtons OK 控制交互 备注fpSpread1 Sheets 0 Cells 1 1 3 3 Note Thisisthenotethatdescribesthevalue fpSpread1 Sheets 0 Cells 1 1 3 3 Value ValueHere 控制交互 Tag属性fpSpread1 Sheets 0 Cells 1 1 3 3 Tag Thisisthetagthatdescribesthevalue fpSpread1 Sheets 0 Cells 1 1 3 3 Value ValueHere 控制交互 锁定单元格fpSpread1 ActiveSheet Protect true fpSpread1 ActiveSheet LockBackColor Color LightCyan fpSpread1 ActiveSheet LockForeColor Color Green FarPoint Win Spread Columncolumnobj columnobj fpSpread1 ActiveSheet Columns 0 3 columnobj Locked true FarPoint Win Spread Cellcellobj cellobj fpSpread1 ActiveSheet Cells 1 1 1 2 cellobj Locked false fpSpread1 ActiveSheet Cells 1 0 1 4 Text FirstFive 控制交互 设置锁定与未锁定的样式fpSpread1 ActiveSheet Protect true fpSpread1 ActiveSheet LockBackColor Color LightCyan fpSpread1 ActiveSheet LockForeColor Color Green fpSpread1 ActiveSheet Columns 0 3 Locked true fpSpread1 ActiveSheet Cells 1 1 1 2 Locked false 控制交互 添加图形 Createanewshape FarPoint Win Spread DrawingSpace RectangleShaperShape newFarPoint Win Spread DrawingSpace RectangleShape Assignaname overridingtheuniquedefaultassignedname Allshapenameswithinasheetmustbeunique rShape Name myRect1 Assignalocationatwhichtostartthedisplayoftheshape rShape Top 20 rShape Left 60 Alternatively youcouldsettheLocationproperty withaPointobjectasin rShape Location newPoint 20 60 Assignacustomfillcolortotheshape rShape BackColor Color Blue Assignasizetotheshape rShape Width 100 rShape Height 100 Alternatively youcouldsettheSizeproperty withaSizeobjectasin rShape Size newSize 100 100 Addtheshapetothesheetsothatitappearsonthatsheet fpSpread1 ActiveSheet AddShape rShape 管理单元格类型 重点 定义货币型单元格FarPoint Win Spread CellType CurrencyCellTypecurrcell newFarPoint Win Spread CellType CurrencyCellType currcell CurrencySymbol US currcell DecimalSeparator currcell DecimalPlaces 8 fpSpread1 ActiveSheet Cells 1 1 CellType currcell 管理单元格类型 重点 控制有效值范围FarPoint Win Spread CellType CurrencyCellTypecurrcell newFarPoint Win Spread CellType CurrencyCellType Pickanumberbetween1and10 currcell MinimumValue 1 currcell MaximumValue 10 currcell Multiline true fpSpread1 ActiveSheet Cells 1 1 CellType currcell 管理单元格类型 重点 日期型FarPoint Win Spread CellType DateTimeCellTypedatecell newFarPoint Win Spread CellType DateTimeCellType datecell ErrorMessage Needadate datecell FormatString dddd MMMMd fpSpread1 ActiveSheet Columns 1 Width 175 fpSpread1 ActiveSheet Cells 1 1 CellType datecell 管理单元格类型 重点 定义日期格式参数FarPoint Win Spread CellType DateTimeCellTypedatecell newFarPoint Win Spread CellType DateTimeCellType string daynames Sunday Monday Tuesday Wednesday Thursday Friday Saturday string months January February March April May June July August September October November December string dayabbrev Su My Ty Wy Th Fy Sy string mthabbrev Jy Fy Mh Al My Jn Jl At Sr Or Nr Dr stringokbuttn Fine stringcancelb Quit datecell DateTimeFormat FarPoint Win Spread CellType DateTimeFormat UserDefined datecell UserDefinedFormat ddddMMMMd yyyy datecell SetCalendarText daynames months dayabbrev mthabbrev okbuttn cancelb fpSpread1 ActiveSheet Cells 1 1 CellType datecell fpSpread1 ActiveSheet Cells 1 1 Value System DateTime Now fpSpread1 ActiveSheet Columns 1 Width 130 管理单元格类型 XXXXXXXX XXXXXXXXULLLLLLL ULLLLLLL maskcell MaskChar Convert ToChar X fpSpread1 ActiveSheet Cells 1 1 CellType maskcell 管理单元格类型 重点 设置数值FarPoint Win Spread CellType NumberCellTypenmbrcell newFarPoint Win Spread CellType NumberCellType nmbrcell DecimalSeparator nmbrcell DecimalPlaces 5 nmbrcell LeadingZero FarPoint Win Spread CellType LeadingZero UseRegional nmbrcell MaximumValue 500 000 nmbrcell MinimumValue 10 000 fpSpread1 ActiveSheet Cells 1 1 CellType nmbrcell 管理单元格类型 重点 设置百分比FarPoint Win Spread CellType PercentCellTypeprctcell newFarPoint Win Spread CellType PercentCellType prctcell PercentSign PRCNT prctcell PositiveFormat FarPoint Win Spread CellType PercentPositiveFormat PercentSignBeforeWithSpace fpSpread1 ActiveSheet Cells 1 1 CellType prctcell 管理单元格类型 重点 设置文本FarPoint Win Spread CellType TextCellTypetcell newFarPoint Win Spread CellType TextCellType tcell ErrorMessage OnlyText fpSpread1 ActiveSheet Cells 0 0 CellType tcell 管理单元格类型 重点 微调框可应用于以下单元格类型 CurrencyCells Date TimeCells NumberCells PercentCells 管理单元格类型 重点 按钮单元格FarPoint Win Spread CellType ButtonCellTypebttncell newFarPoint Win Spread CellType ButtonCellType bttncell ButtonColor Color Cyan bttncell DarkColor Color DarkCyan bttncell LightColor Color AliceBlue bttncell TwoState false bttncell Text ClickandHold bttncell TextDown nowletgo bttncell ShadowSize 3 fpSpread1 Sheets 0 Cells 0 2 CellType bttncell 管理单元格类型 重点 复选框类型FarPoint Win Spread CellType CheckBoxCellTypeckbxcell newFarPoint Win Spread CellType CheckBoxCellType ckbxcell ThreeState true ckbxcell TextTrue Checked ckbxcell TextFalse Unchecked ckbxcell TextIndeterminate NotSure fpSpread1 ActiveSheet Cells 0 0 CellType ckbxcell 管理单元格类型 重点 下拉列表FarPoint Win Spread CellType ComboBoxCellTypecmbocell newFarPoint Win Spread CellType ComboBoxCellType cmbocell Items newString January February March April May June cmbocell AutoSearch FarPoint Win AutoSearch SingleCharacter cmbocell Editable true cmbocell MaxDrop 4 fpSpread1 ActiveSheet Cells 0 0 CellType cmbocell 管理单元格类型 链接fpSpread2 ActiveSheet Columns 1 Width 145 fpSpread2 ActiveSheet Rows 1 Height 45 FarPoint Win Spread CellType HyperLinkCellTypehlnkcell newFarPoint Win Spread CellType HyperLinkCellType hlnkcell Text ClicktoSeeOurWebSite hlnkcell Link hlnkcell LinkArea newLinkArea 9 25 hlnkcell LinkColor Color DarkSlateBlue fpSpread2 ActiveSheet Cells 1 1 CellType hlnkcell 管理单元格类型 重点 单选钮FarPoint Win Spread CellType MultiOptionCellTypemultcell newFarPoint Win Spread CellType MultiOptionCellType multcell Items newString Carbon Oxygen Hydrogen multcell Orientation FarPoint Win RadioOrientation Horizontal fpSpread1 ActiveSheet Cells 0 0 CellType multcell 管理单元格类型 进度条FarPoint Win Spread CellType ProgressCellTypeprogcell newFarPoint Win Spread CellType ProgressCellType progcell FillColor Color Red fpSpread1 ActiveSheet Cells 0 0 CellType progcell 管理单元格类型 滑块FarPoint Win Spread CellType SliderCellTypesldrcell newFarPoint Win Spread CellType SliderCellType sldrcell KnobColor Color Green sldrcell TrackColor Color Yellow fpSpread1 ActiveSheet Cells 0 0 CellType sldrcell 管理公式 求和FarPoint Win Spread Cellmycell mycell fpSpread1 Cells 2 0 mycell Formula SUM A1 A2 2 管理公式 公式编辑器 管理公式 引用样式 A1或R1C1 fpSpread1 Sheets 0 ReferenceStyle FarPoint Win Spread Model ReferenceStyle A1 管理公式 循环引用fpSpread1 ActiveSheet Iteration true fpSpread1 ActiveSheet SetValue 0 1 20 fpSpread1 ActiveSheet MaximumChange 5 fpSpread1 ActiveSheet MaximumIterations 5 fpSpread1 ActiveSheet SetFormula 0 2 A1 3 fpSpread1 ActiveSheet SetFormula 0 0 B1 C1 管理公式 嵌套函数fpSpread1 Sheets 0 Cells 3 1 Formula PRODUCT A1 SUM A2 A3 用户定义公式fpSpread1 AllowUserFormulas true 定义变量名FarPoint Win Spread Model DefaultSheetDataModeld d FarPoint Win Spread Model DefaultSheetDataModel FpSpread1 Sheets 0 DataModel d AddCustomName alpha 101 0 0 管理公式 自定义函数publicclassNullFunctionInfo FunctionInfo publicoverridestringName get return NULL publicoverrideintMinArgs get return0 publicoverrideintMaxArgs get return0 publicoverrideobjectEvaluate object args returnnull 管理控件的数据 管理控件的数据 设置多个单元格 AdddatatocellsA1throughC3fpSpread1 Sheets 0 SetClip 0 0 3 3 Sunday tMonday tTuesday r nWednesday tThursday tFriday r nSaturday tSunday tMonday 管理控件的数据 通过单元格属性处理数据 管理控件的数据 单元格的值 管理控件的数据 扩展属性 管理控件的数据 排序行fpoint1 ActiveSheet SortRows 1 true true 排序一个区域FarPoint Win Spread SortInfo sorter newFarPoint Win Spread SortInfo 1 sorter 0 newFarPoint Win Spread SortInfo 0 false System Collections Comparer Default fpoint1 ActiveSheet SortColumns 12 230 sorter 管理控件的数据 设置自动排列fpSpread1 ActiveSheet SetColumnAllowAutoSort 0 true fpSpread1 ActiveSheet SetColumnShowSortIndicator 0 false fpSpread1 ActiveSheet AutoSortColumn 0 管理控件的数据 设置0 30行自动排序fpSpread1 Sheets 0 Columns 0 29 AllowAutoSort true orfpSpread1 Sheets 0 SetColumnAllowAutoSort 0 30 true 搜索数据fpSpread1 Search 2 Total true true false false 1 1 56 56 refrowindx refcolindx 管理控件的数据 显示搜索模态窗口fpSpread1 SearchWithDialog 3 NotAvailable 1 1 true true false false 0 0 管理数据绑定 重点 绑定数据源 BindthecontroltothedatasetfpSpread1 DataSource dbDataSet 添加一个不接受绑定的行 BindthecontroltothedatasetfpSpread1 DataSource dbDataSet AddanunboundrowfpSpread1 Sheets 0 AddUnboundRows 20 1 管理数据绑定 重点 设置列标题文本 BindthecontroltothedatasetfpSpread1 DataSource dbDataSet SetcustomtextinthefirstcolumnheaderfpSpread1 Sheets 0 ColumnHeader Cells 0 0 Text StudentID 管理数据绑定 重点 自定义绑定列的类型 BindthecontroltothedatasetfpSpread1 DataSource dbDataSet TurnoffautomaticcelltypeassignmentfpSpread1 Sheets 0 DataAutoCellTypes false SetthefirstcolumnasgeneralcelltypeFarPoint Win Spread CellType GeneralCellTypegeneralct newFarPoint Win Spread CellType GeneralCellType fpSpread1 Sheets 0 Columns 0 CellType generalct SetthesecondcolumnasnumbercelltypeFarPoint Win Spread CellType NumberCellTypenumberct newFarPoint Win Spread CellType NumberCellType fpSpread1 Sheets 0 Columns 1 CellType numberct SetthethirdcolumnascurrencycelltypeFarPoint Win Spread CellType CurrencyCellTypecurrct newFarPoint Win Spread CellType CurrencyCellType fpSpread1 Sheets 0 Columns 2 CellType currct 管理数据绑定 重点 自定义列的绑定数据列 TurnoffautomaticcolumnandfieldmappingfpSpread1 Sheets 0 AutoGenerateColumns false BindthecontroltothedatasetfpSpread1 DataSource dataSet1 SetthefieldsforthecolumnsfpSpread1 Sheets 0 Columns 0 DataField Description fpSpread1 Sheets 0 Columns 1 DataField ID fpSpread1 Sheets 0 Columns 2 DataField LeadTime fpSpread1 Sheets 0 Columns 3 DataField Price 管理数据绑定 重点 多级显示System Data DataSetds newSystem Data DataSet DataTablename DataTablecity name ds Tables Add Customers name Columns AddRange newDataColumn newDataColumn LastName typeof string newDataColumn FirstName typeof string newDataColumn ID typeof Int32 name Rows Add