ПОМОГИТЕ НАЙТИ ОПИСАНИЕ

  • Автор темы bait
  • Дата начала
Статус
Закрыто для дальнейших ответов.
B

bait

#1
ТЕма такая Свойства и методы объекта «ячейка» (диапазон ячеек).

Кароче мне б описание переменных всяких типо Range. cells!
человеки я очень нуждаюсь в вашей помощи! просьба никуда не слать в другое место! Жизненно нужно!
 
B

Barmutik

#2
Импортировать TLB и смотреть его методы и свойства...

Что не понятно потом уже спрашивать... или искать .. в любой книжке по программированию для Оффиса будет написано...
 
B

Barmutik

#4
Открыть практически любую среджу программирования и сделать Import Type Library ... в разных средах может варьироваться название...

По русски: импортировать библиотеку типов от того продукта у которого вы хотите посмотреть
 
G

Guest

#5
я вообше непонимаю чегото! ВОобшем нме надо через эксель в VBA , вот из него мне нужно узнать что значат эти всякие ранж, сэллс
 
B

Barmutik

#6
Если в VBA тоя думаю эти объекты описаны в хелпе ..

Вот описание из TLBшника импортнутого в Delphi:

Код:
 Range = dispinterface
 ['{00020846-0000-0000-C000-000000000046}']
 property Application: ExcelApplication readonly dispid 148;
 property Creator: XlCreator readonly dispid 149;
 property Parent: IDispatch readonly dispid 150;
 function Activate: OleVariant; dispid 304;
 property AddIndent: OleVariant dispid 1063;
 property Address[RowAbsolute: OleVariant; ColumnAbsolute: OleVariant; 
          ReferenceStyle: XlReferenceStyle; External: OleVariant; RelativeTo: OleVariant]: WideString readonly dispid 236;
 property AddressLocal[RowAbsolute: OleVariant; ColumnAbsolute: OleVariant; 
            ReferenceStyle: XlReferenceStyle; External: OleVariant; 
            RelativeTo: OleVariant]: WideString readonly dispid 437;
 function AdvancedFilter(Action: XlFilterAction; CriteriaRange: OleVariant; 
             CopyToRange: OleVariant; Unique: OleVariant): OleVariant; dispid 876;
 function ApplyNames(Names: OleVariant; IgnoreRelativeAbsolute: OleVariant; 
           UseRowColumnNames: OleVariant; OmitColumn: OleVariant; OmitRow: OleVariant; 
           Order: XlApplyNamesOrder; AppendLast: OleVariant): OleVariant; dispid 441;
 function ApplyOutlineStyles: OleVariant; dispid 448;
 property Areas: Areas readonly dispid 568;
 function AutoComplete(const String_: WideString): WideString; dispid 1185;
 function AutoFill(const Destination: ExcelRange; Type_: XlAutoFillType): OleVariant; dispid 449;
 function AutoFilter(Field: OleVariant; Criteria1: OleVariant; Operator: XlAutoFilterOperator; 
           Criteria2: OleVariant; VisibleDropDown: OleVariant): OleVariant; dispid 793;
 function AutoFit: OleVariant; dispid 237;
 function AutoFormat(Format: XlRangeAutoFormat; Number: OleVariant; Font: OleVariant; 
           Alignment: OleVariant; Border: OleVariant; Pattern: OleVariant; 
           Width: OleVariant): OleVariant; dispid 114;
 function AutoOutline: OleVariant; dispid 1036;
 function BorderAround(LineStyle: OleVariant; Weight: XlBorderWeight; ColorIndex: XlColorIndex; 
            Color: OleVariant): OleVariant; dispid 1067;
 property Borders: Borders readonly dispid 435;
 function Calculate: OleVariant; dispid 279;
 property Cells: ExcelRange readonly dispid 238;
 property Characters[Start: OleVariant; Length: OleVariant]: Characters readonly dispid 603;
 function CheckSpelling(CustomDictionary: OleVariant; IgnoreUppercase: OleVariant; 
             AlwaysSuggest: OleVariant; SpellLang: OleVariant): OleVariant; dispid 505;
 function Clear: OleVariant; dispid 111;
 function ClearContents: OleVariant; dispid 113;
 function ClearFormats: OleVariant; dispid 112;
 function ClearNotes: OleVariant; dispid 239;
 function ClearOutline: OleVariant; dispid 1037;
 property Column: Integer readonly dispid 240;
 function ColumnDifferences(Comparison: OleVariant): ExcelRange; dispid 510;
 property Columns: ExcelRange readonly dispid 241;
 property ColumnWidth: OleVariant dispid 242;
 function Consolidate(Sources: OleVariant; Function_: OleVariant; TopRow: OleVariant; 
            LeftColumn: OleVariant; CreateLinks: OleVariant): OleVariant; dispid 482;
 function Copy(Destination: OleVariant): OleVariant; dispid 551;
 function CopyFromRecordset(const Data: IUnknown; MaxRows: OleVariant; MaxColumns: OleVariant): Integer; dispid 1152;
 function CopyPicture(Appearance: XlPictureAppearance; Format: XlCopyPictureFormat): OleVariant; dispid 213;
 property Count: Integer readonly dispid 118;
 function CreateNames(Top: OleVariant; Left: OleVariant; Bottom: OleVariant; Right: OleVariant): OleVariant; dispid 457;
 function CreatePublisher(Edition: OleVariant; Appearance: XlPictureAppearance; 
              ContainsPICT: OleVariant; ContainsBIFF: OleVariant; 
              ContainsRTF: OleVariant; ContainsVALU: OleVariant): OleVariant; dispid 458;
 property CurrentArray: ExcelRange readonly dispid 501;
 property CurrentRegion: ExcelRange readonly dispid 243;
 function Cut(Destination: OleVariant): OleVariant; dispid 565;
 function DataSeries(Rowcol: OleVariant; Type_: XlDataSeriesType; Date: XlDataSeriesDate; 
           Step: OleVariant; Stop: OleVariant; Trend: OleVariant): OleVariant; dispid 464;
 property _Default[RowIndex: OleVariant; ColumnIndex: OleVariant]: OleVariant dispid 0;
 function Delete(Shift: OleVariant): OleVariant; dispid 117;
 property Dependents: ExcelRange readonly dispid 543;
 function DialogBox: OleVariant; dispid 245;
 property DirectDependents: ExcelRange readonly dispid 545;
 property DirectPrecedents: ExcelRange readonly dispid 546;
 function EditionOptions(Type_: XlEditionType; Option: XlEditionOptionsOption; Name: OleVariant; 
             Reference: OleVariant; Appearance: XlPictureAppearance; 
             ChartSize: XlPictureAppearance; Format: OleVariant): OleVariant; dispid 1131;
 property End_[Direction: XlDirection]: ExcelRange readonly dispid 500;
 property EntireColumn: ExcelRange readonly dispid 246;
 property EntireRow: ExcelRange readonly dispid 247;
 function FillDown: OleVariant; dispid 248;
 function FillLeft: OleVariant; dispid 249;
 function FillRight: OleVariant; dispid 250;
 function FillUp: OleVariant; dispid 251;
 function Find(What: OleVariant; After: OleVariant; LookIn: OleVariant; LookAt: OleVariant; 
        SearchOrder: OleVariant; SearchDirection: XlSearchDirection; 
        MatchCase: OleVariant; MatchByte: OleVariant; SearchFormat: OleVariant): ExcelRange; dispid 398;
 function FindNext(After: OleVariant): ExcelRange; dispid 399;
 function FindPrevious(After: OleVariant): ExcelRange; dispid 400;
 property Font: Font readonly dispid 146;
 property Formula: OleVariant dispid 261;
 property FormulaArray: OleVariant dispid 586;
 property FormulaLabel: XlFormulaLabel dispid 1380;
 property FormulaHidden: OleVariant dispid 262;
 property FormulaLocal: OleVariant dispid 263;
 property FormulaR1C1: OleVariant dispid 264;
 property FormulaR1C1Local: OleVariant dispid 265;
 function FunctionWizard: OleVariant; dispid 571;
 function GoalSeek(Goal: OleVariant; const ChangingCell: ExcelRange): WordBool; dispid 472;
 function Group(Start: OleVariant; End_: OleVariant; By: OleVariant; Periods: OleVariant): OleVariant; dispid 46;
 property HasArray: OleVariant readonly dispid 266;
 property HasFormula: OleVariant readonly dispid 267;
 property Height: OleVariant readonly dispid 123;
 property Hidden: OleVariant dispid 268;
 property HorizontalAlignment: OleVariant dispid 136;
 property IndentLevel: OleVariant dispid 201;
 procedure InsertIndent(InsertAmount: Integer); dispid 1381;
 function Insert(Shift: OleVariant; CopyOrigin: OleVariant): OleVariant; dispid 252;
 property Interior: Interior readonly dispid 129;
 property Item[RowIndex: OleVariant; ColumnIndex: OleVariant]: OleVariant dispid 170;
 function Justify: OleVariant; dispid 495;
 property Left: OleVariant readonly dispid 127;
 property ListHeaderRows: Integer readonly dispid 1187;
 function ListNames: OleVariant; dispid 253;
 property LocationInTable: XlLocationInTable readonly dispid 691;
 property Locked: OleVariant dispid 269;
 procedure Merge(Across: OleVariant); dispid 564;
 procedure UnMerge; dispid 1384;
 property MergeArea: ExcelRange readonly dispid 1385;
 property MergeCells: OleVariant dispid 208;
 property Name: OleVariant dispid 110;
 function NavigateArrow(TowardPrecedent: OleVariant; ArrowNumber: OleVariant; 
             LinkNumber: OleVariant): OleVariant; dispid 1032;
 property _NewEnum: IUnknown readonly dispid -4;
 property Next: ExcelRange readonly dispid 502;
 function NoteText(Text: OleVariant; Start: OleVariant; Length: OleVariant): WideString; dispid 1127;
 property NumberFormat: OleVariant dispid 193;
 property NumberFormatLocal: OleVariant dispid 1097;
 property Offset[RowOffset: OleVariant; ColumnOffset: OleVariant]: ExcelRange readonly dispid 254;
 property Orientation: OleVariant dispid 134;
 property OutlineLevel: OleVariant dispid 271;
 property PageBreak: Integer dispid 255;
 function Parse(ParseLine: OleVariant; Destination: OleVariant): OleVariant; dispid 477;
 function _PasteSpecial(Paste: XlPasteType; Operation: XlPasteSpecialOperation; 
             SkipBlanks: OleVariant; Transpose: OleVariant): OleVariant; dispid 1027;
 property PivotField: PivotField readonly dispid 731;
 property PivotItem: PivotItem readonly dispid 740;
 property PivotTable: PivotTable readonly dispid 716;
 property Precedents: ExcelRange readonly dispid 544;
 property PrefixCharacter: OleVariant readonly dispid 504;
 property Previous: ExcelRange readonly dispid 503;
 function _PrintOut(From: OleVariant; To_: OleVariant; Copies: OleVariant; Preview: OleVariant; 
           ActivePrinter: OleVariant; PrintToFile: OleVariant; Collate: OleVariant): OleVariant; dispid 905;
 function PrintPreview(EnableChanges: OleVariant): OleVariant; dispid 281;
 property QueryTable: ExcelQueryTable readonly dispid 1386;
 property Range[Cell1: OleVariant; Cell2: OleVariant]: ExcelRange readonly dispid 197;
 function RemoveSubtotal: OleVariant; dispid 883;
 function Replace(What: OleVariant; Replacement: OleVariant; LookAt: OleVariant; 
          SearchOrder: OleVariant; MatchCase: OleVariant; MatchByte: OleVariant; 
          SearchFormat: OleVariant; ReplaceFormat: OleVariant): WordBool; dispid 226;
 property Resize[RowSize: OleVariant; ColumnSize: OleVariant]: ExcelRange readonly dispid 256;
 property Row: Integer readonly dispid 257;
 function RowDifferences(Comparison: OleVariant): ExcelRange; dispid 511;
 property RowHeight: OleVariant dispid 272;
 property Rows: ExcelRange readonly dispid 258;
 function Run(Arg1: OleVariant; Arg2: OleVariant; Arg3: OleVariant; Arg4: OleVariant; 
        Arg5: OleVariant; Arg6: OleVariant; Arg7: OleVariant; Arg8: OleVariant; 
        Arg9: OleVariant; Arg10: OleVariant; Arg11: OleVariant; Arg12: OleVariant; 
        Arg13: OleVariant; Arg14: OleVariant; Arg15: OleVariant; Arg16: OleVariant; 
        Arg17: OleVariant; Arg18: OleVariant; Arg19: OleVariant; Arg20: OleVariant; 
        Arg21: OleVariant; Arg22: OleVariant; Arg23: OleVariant; Arg24: OleVariant; 
        Arg25: OleVariant; Arg26: OleVariant; Arg27: OleVariant; Arg28: OleVariant; 
        Arg29: OleVariant; Arg30: OleVariant): OleVariant; dispid 259;
 function Select: OleVariant; dispid 235;
 function Show: OleVariant; dispid 496;
 function ShowDependents(Remove: OleVariant): OleVariant; dispid 877;
 property ShowDetail: OleVariant dispid 585;
 function ShowErrors: OleVariant; dispid 878;
 function ShowPrecedents(Remove: OleVariant): OleVariant; dispid 879;
 property ShrinkToFit: OleVariant dispid 209;
 function Sort(Key1: OleVariant; Order1: XlSortOrder; Key2: OleVariant; Type_: OleVariant; 
        Order2: XlSortOrder; Key3: OleVariant; Order3: XlSortOrder; Header: XlYesNoGuess; 
        OrderCustom: OleVariant; MatchCase: OleVariant; Orientation: XlSortOrientation; 
        SortMethod: XlSortMethod; DataOption1: XlSortDataOption; 
        DataOption2: XlSortDataOption; DataOption3: XlSortDataOption): OleVariant; dispid 880;
 function SortSpecial(SortMethod: XlSortMethod; Key1: OleVariant; Order1: XlSortOrder; 
            Type_: OleVariant; Key2: OleVariant; Order2: XlSortOrder; 
            Key3: OleVariant; Order3: XlSortOrder; Header: XlYesNoGuess; 
            OrderCustom: OleVariant; MatchCase: OleVariant; 
            Orientation: XlSortOrientation; DataOption1: XlSortDataOption; 
            DataOption2: XlSortDataOption; DataOption3: XlSortDataOption): OleVariant; dispid 881;
 property SoundNote: SoundNote readonly dispid 916;
 function SpecialCells(Type_: XlCellType; Value: OleVariant): ExcelRange; dispid 410;
 property Style: OleVariant dispid 260;
 function SubscribeTo(const Edition: WideString; Format: XlSubscribeToFormat): OleVariant; dispid 481;
 function Subtotal(GroupBy: Integer; Function_: XlConsolidationFunction; TotalList: OleVariant; 
          Replace: OleVariant; PageBreaks: OleVariant; SummaryBelowData: XlSummaryRow): OleVariant; dispid 882;
 property Summary: OleVariant readonly dispid 273;
 function Table(RowInput: OleVariant; ColumnInput: OleVariant): OleVariant; dispid 497;
 property Text: OleVariant readonly dispid 138;
 function TextToColumns(Destination: OleVariant; DataType: XlTextParsingType; 
             TextQualifier: XlTextQualifier; ConsecutiveDelimiter: OleVariant; 
             Tab: OleVariant; Semicolon: OleVariant; Comma: OleVariant; 
             Space: OleVariant; Other: OleVariant; OtherChar: OleVariant; 
             FieldInfo: OleVariant; DecimalSeparator: OleVariant; 
             ThousandsSeparator: OleVariant; TrailingMinusNumbers: OleVariant): OleVariant; dispid 1040;
 property Top: OleVariant readonly dispid 126;
 function Ungroup: OleVariant; dispid 244;
 property UseStandardHeight: OleVariant dispid 274;
 property UseStandardWidth: OleVariant dispid 275;
 property Validation: Validation readonly dispid 1387;
 property Value[RangeValueDataType: OleVariant]: OleVariant dispid 6;
 property Value2: OleVariant dispid 1388;
 property VerticalAlignment: OleVariant dispid 137;
 property Width: OleVariant readonly dispid 122;
 property Worksheet: ExcelWorksheet readonly dispid 348;
 property WrapText: OleVariant dispid 276;
 function AddComment(Text: OleVariant): Comment; dispid 1389;
 property Comment: Comment readonly dispid 910;
 procedure ClearComments; dispid 1390;
 property Phonetic: Phonetic readonly dispid 1391;
 property FormatConditions: FormatConditions readonly dispid 1392;
 property ReadingOrder: Integer dispid 975;
 property Hyperlinks: Hyperlinks readonly dispid 1393;
 property Phonetics: Phonetics readonly dispid 1811;
 procedure SetPhonetic; dispid 1812;
 property ID: WideString dispid 1813;
 function PrintOut(From: OleVariant; To_: OleVariant; Copies: OleVariant; Preview: OleVariant; 
          ActivePrinter: OleVariant; PrintToFile: OleVariant; Collate: OleVariant; 
          PrToFileName: OleVariant): OleVariant; dispid 1772;
 property PivotCell: PivotCell readonly dispid 2013;
 procedure Dirty; dispid 2014;
 property Errors: Errors readonly dispid 2015;
 property SmartTags: SmartTags readonly dispid 2016;
 procedure Speak(SpeakDirection: OleVariant; SpeakFormulas: OleVariant); dispid 2017;
 function PasteSpecial(Paste: XlPasteType; Operation: XlPasteSpecialOperation; 
            SkipBlanks: OleVariant; Transpose: OleVariant): OleVariant; dispid 1928;
 property AllowEdit: WordBool readonly dispid 2020;
end;
 
G

Guest

#7
ого... Плин а может у тя справка на русском есь? из ВБА этого*?
 
B

Barmutik

#8
Открываете Хелп в продуктt Microsoft Excel и там ищите...

Или открываете MSDN и там подробно всё написано... к сожалению как я думаю и то и другое будет на английском...
 
G

Guest

#9
так оно и есть все оно на английском, хоть я и знаю английский но там очень много непонятных выражений... А времени уже в обрез :)
 
B

Barmutik

#10
Тогда взять любую книжку по программированию на VisualBasic for Application и почитать.. там всё будет написано ...
 
G

Guest

#11
так а есть эта информация хде-нибудь в инете***????
 
Статус
Закрыто для дальнейших ответов.