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

Тема в разделе "Свободное общение", создана пользователем bait, 16 май 2005.

Статус темы:
Закрыта.
  1. bait

    bait Гость

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

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

    Barmutik Гость

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

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

    Guest Гость

    Т.е. импортировать?
     
  4. Barmutik

    Barmutik Гость

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

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

    Guest Гость

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

    Barmutik Гость

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

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

    Код (Text):
     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;
     
  7. Guest

    Guest Гость

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

    Barmutik Гость

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

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

    Guest Гость

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

    Barmutik Гость

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

    Guest Гость

    так а есть эта информация хде-нибудь в инете***????
     
  12. Barmutik

    Barmutik Гость

Загрузка...
Статус темы:
Закрыта.

Поделиться этой страницей