📄 uexcel97.pas
字号:
XlCellType = TOleEnum;
const
xlCellTypeBlanks = $00000004;
xlCellTypeConstants = $00000002;
xlCellTypeFormulas = $FFFFEFE5;
xlCellTypeLastCell = $0000000B;
xlCellTypeComments = $FFFFEFD0;
xlCellTypeVisible = $0000000C;
xlCellTypeAllFormatConditions = $FFFFEFB4;
xlCellTypeSameFormatConditions = $FFFFEFB3;
xlCellTypeAllValidation = $FFFFEFB2;
xlCellTypeSameValidation = $FFFFEFB1;
// XlArrangeStyle constants
type
XlArrangeStyle = TOleEnum;
const
xlArrangeStyleCascade = $00000007;
xlArrangeStyleHorizontal = $FFFFEFE0;
xlArrangeStyleTiled = $00000001;
xlArrangeStyleVertical = $FFFFEFBA;
// XlMousePointer constants
type
XlMousePointer = TOleEnum;
const
xlIBeam = $00000003;
xlDefault = $FFFFEFD1;
xlNorthwestArrow = $00000001;
xlWait = $00000002;
// XlEditionOptionsOption constants
type
XlEditionOptionsOption = TOleEnum;
const
xlAutomaticUpdate = $00000004;
xlCancel = $00000001;
xlChangeAttributes = $00000006;
xlManualUpdate = $00000005;
xlOpenSource = $00000003;
xlSelect = $00000003;
xlSendPublisher = $00000002;
xlUpdateSubscriber = $00000002;
// XlAutoFillType constants
type
XlAutoFillType = TOleEnum;
const
xlFillCopy = $00000001;
xlFillDays = $00000005;
xlFillDefault = $00000000;
xlFillFormats = $00000003;
xlFillMonths = $00000007;
xlFillSeries = $00000002;
xlFillValues = $00000004;
xlFillWeekdays = $00000006;
xlFillYears = $00000008;
xlGrowthTrend = $0000000A;
xlLinearTrend = $00000009;
// XlAutoFilterOperator constants
type
XlAutoFilterOperator = TOleEnum;
const
xlAnd = $00000001;
xlBottom10Items = $00000004;
xlBottom10Percent = $00000006;
xlOr = $00000002;
xlTop10Items = $00000003;
xlTop10Percent = $00000005;
// XlClipboardFormat constants
type
XlClipboardFormat = TOleEnum;
const
xlClipboardFormatBIFF = $00000008;
xlClipboardFormatBIFF2 = $00000012;
xlClipboardFormatBIFF3 = $00000014;
xlClipboardFormatBIFF4 = $0000001E;
xlClipboardFormatBinary = $0000000F;
xlClipboardFormatBitmap = $00000009;
xlClipboardFormatCGM = $0000000D;
xlClipboardFormatCSV = $00000005;
xlClipboardFormatDIF = $00000004;
xlClipboardFormatDspText = $0000000C;
xlClipboardFormatEmbeddedObject = $00000015;
xlClipboardFormatEmbedSource = $00000016;
xlClipboardFormatLink = $0000000B;
xlClipboardFormatLinkSource = $00000017;
xlClipboardFormatLinkSourceDesc = $00000020;
xlClipboardFormatMovie = $00000018;
xlClipboardFormatNative = $0000000E;
xlClipboardFormatObjectDesc = $0000001F;
xlClipboardFormatObjectLink = $00000013;
xlClipboardFormatOwnerLink = $00000011;
xlClipboardFormatPICT = $00000002;
xlClipboardFormatPrintPICT = $00000003;
xlClipboardFormatRTF = $00000007;
xlClipboardFormatScreenPICT = $0000001D;
xlClipboardFormatStandardFont = $0000001C;
xlClipboardFormatStandardScale = $0000001B;
xlClipboardFormatSYLK = $00000006;
xlClipboardFormatTable = $00000010;
xlClipboardFormatText = $00000000;
xlClipboardFormatToolFace = $00000019;
xlClipboardFormatToolFacePICT = $0000001A;
xlClipboardFormatVALU = $00000001;
xlClipboardFormatWK1 = $0000000A;
// XlFileFormat constants
type
XlFileFormat = TOleEnum;
const
xlAddIn = $00000012;
xlCSV = $00000006;
xlCSVMac = $00000016;
xlCSVMSDOS = $00000018;
xlCSVWindows = $00000017;
xlDBF2 = $00000007;
xlDBF3 = $00000008;
xlDBF4 = $0000000B;
xlDIF = $00000009;
xlExcel2 = $00000010;
xlExcel2FarEast = $0000001B;
xlExcel3 = $0000001D;
xlExcel4 = $00000021;
xlExcel5 = $00000027;
xlExcel7 = $00000027;
xlExcel9795 = $0000002B;
xlExcel4Workbook = $00000023;
xlIntlAddIn = $0000001A;
xlIntlMacro = $00000019;
xlWorkbookNormal = $FFFFEFD1;
xlSYLK = $00000002;
xlTemplate = $00000011;
xlCurrentPlatformText = $FFFFEFC2;
xlTextMac = $00000013;
xlTextMSDOS = $00000015;
xlTextPrinter = $00000024;
xlTextWindows = $00000014;
xlWJ2WD1 = $0000000E;
xlWK1 = $00000005;
xlWK1ALL = $0000001F;
xlWK1FMT = $0000001E;
xlWK3 = $0000000F;
xlWK4 = $00000026;
xlWK3FM3 = $00000020;
xlWKS = $00000004;
xlWorks2FarEast = $0000001C;
xlWQ1 = $00000022;
xlWJ3 = $00000028;
xlWJ3FJ3 = $00000029;
// XlApplicationInternational constants
type
XlApplicationInternational = TOleEnum;
const
xl24HourClock = $00000021;
xl4DigitYears = $0000002B;
xlAlternateArraySeparator = $00000010;
xlColumnSeparator = $0000000E;
xlCountryCode = $00000001;
xlCountrySetting = $00000002;
xlCurrencyBefore = $00000025;
xlCurrencyCode = $00000019;
xlCurrencyDigits = $0000001B;
xlCurrencyLeadingZeros = $00000028;
xlCurrencyMinusSign = $00000026;
xlCurrencyNegative = $0000001C;
xlCurrencySpaceBefore = $00000024;
xlCurrencyTrailingZeros = $00000027;
xlDateOrder = $00000020;
xlDateSeparator = $00000011;
xlDayCode = $00000015;
xlDayLeadingZero = $0000002A;
xlDecimalSeparator = $00000003;
xlGeneralFormatName = $0000001A;
xlHourCode = $00000016;
xlLeftBrace = $0000000C;
xlLeftBracket = $0000000A;
xlListSeparator = $00000005;
xlLowerCaseColumnLetter = $00000009;
xlLowerCaseRowLetter = $00000008;
xlMDY = $0000002C;
xlMetric = $00000023;
xlMinuteCode = $00000017;
xlMonthCode = $00000014;
xlMonthLeadingZero = $00000029;
xlMonthNameChars = $0000001E;
xlNoncurrencyDigits = $0000001D;
xlNonEnglishFunctions = $00000022;
xlRightBrace = $0000000D;
xlRightBracket = $0000000B;
xlRowSeparator = $0000000F;
xlSecondCode = $00000018;
xlThousandsSeparator = $00000004;
xlTimeLeadingZero = $0000002D;
xlTimeSeparator = $00000012;
xlUpperCaseColumnLetter = $00000007;
xlUpperCaseRowLetter = $00000006;
xlWeekdayNameChars = $0000001F;
xlYearCode = $00000013;
// XlPageBreakExtent constants
type
XlPageBreakExtent = TOleEnum;
const
xlPageBreakFull = $00000001;
xlPageBreakPartial = $00000002;
// XlCellInsertionMode constants
type
XlCellInsertionMode = TOleEnum;
const
xlOverwriteCells = $00000000;
xlInsertDeleteCells = $00000001;
xlInsertEntireRows = $00000002;
// XlFormulaLabel constants
type
XlFormulaLabel = TOleEnum;
const
xlNoLabels = $FFFFEFD2;
xlRowLabels = $00000001;
xlColumnLabels = $00000002;
xlMixedLabels = $00000003;
// XlHighlightChangesTime constants
type
XlHighlightChangesTime = TOleEnum;
const
xlSinceMyLastSave = $00000001;
xlAllChanges = $00000002;
xlNotYetReviewed = $00000003;
// XlCommentDisplayMode constants
type
XlCommentDisplayMode = TOleEnum;
const
xlNoIndicator = $00000000;
xlCommentIndicatorOnly = $FFFFFFFF;
xlCommentAndIndicator = $00000001;
// XlFormatConditionType constants
type
XlFormatConditionType = TOleEnum;
const
xlCellValue = $00000001;
xlExpression = $00000002;
// XlFormatConditionOperator constants
type
XlFormatConditionOperator = TOleEnum;
const
xlBetween = $00000001;
xlNotBetween = $00000002;
xlEqual = $00000003;
xlNotEqual = $00000004;
xlGreater = $00000005;
xlLess = $00000006;
xlGreaterEqual = $00000007;
xlLessEqual = $00000008;
// XlEnableSelection constants
type
XlEnableSelection = TOleEnum;
const
xlNoRestrictions = $00000000;
xlUnlockedCells = $00000001;
xlNoSelection = $FFFFEFD2;
// XlDVType constants
type
XlDVType = TOleEnum;
const
xlValidateInputOnly = $00000000;
xlValidateWholeNumber = $00000001;
xlValidateDecimal = $00000002;
xlValidateList = $00000003;
xlValidateDate = $00000004;
xlValidateTime = $00000005;
xlValidateTextLength = $00000006;
xlValidateCustom = $00000007;
// XlIMEMode constants
type
XlIMEMode = TOleEnum;
const
xlIMEModeNoControl = $00000000;
xlIMEModeOn = $00000001;
xlIMEModeOff = $00000002;
xlIMEModeDisable = $00000003;
xlIMEModeHiragana = $00000004;
xlIMEModeKatakana = $00000005;
xlIMEModeKatakanaHalf = $00000006;
xlIMEModeAlphaFull = $00000007;
xlIMEModeAlpha = $00000008;
xlIMEModeHangulFull = $00000009;
xlIMEModeHangul = $0000000A;
// XlDVAlertStyle constants
type
XlDVAlertStyle = TOleEnum;
const
xlValidAlertStop = $00000001;
xlValidAlertWarning = $00000002;
xlValidAlertInformation = $00000003;
// XlChartLocation constants
type
XlChartLocation = TOleEnum;
const
xlLocationAsNewSheet = $00000001;
xlLocationAsObject = $00000002;
xlLocationAutomatic = $00000003;
// XlPaperSize constants
type
XlPaperSize = TOleEnum;
const
xlPaper10x14 = $00000010;
xlPaper11x17 = $00000011;
xlPaperA3 = $00000008;
xlPaperA4 = $00000009;
xlPaperA4Small = $0000000A;
xlPaperA5 = $0000000B;
xlPaperB4 = $0000000C;
xlPaperB5 = $0000000D;
xlPaperCsheet = $00000018;
xlPaperDsheet = $00000019;
xlPaperEnvelope10 = $00000014;
xlPaperEnvelope11 = $00000015;
xlPaperEnvelope12 = $00000016;
xlPaperEnvelope14 = $00000017;
xlPaperEnvelope9 = $00000013;
xlPaperEnvelopeB4 = $00000021;
xlPaperEnvelopeB5 = $00000022;
xlPaperEnvelopeB6 = $00000023;
xlPaperEnvelopeC3 = $0000001D;
xlPaperEnvelopeC4 = $0000001E;
xlPaperEnvelopeC5 = $0000001C;
xlPaperEnvelopeC6 = $0000001F;
xlPaperEnvelopeC65 = $00000020;
xlPaperEnvelopeDL = $0000001B;
xlPaperEnvelopeItaly = $00000024;
xlPaperEnvelopeMonarch = $00000025;
xlPaperEnvelopePersonal = $00000026;
xlPaperEsheet = $0000001A;
xlPaperExecutive = $00000007;
xlPaperFanfoldLegalGerman = $00000029;
xlPaperFanfoldStdGerman = $00000028;
xlPaperFanfoldUS = $00000027;
xlPaperFolio = $0000000E;
xlPaperLedger = $00000004;
xlPaperLegal = $00000005;
xlPaperLetter = $00000001;
xlPaperLetterSmall = $00000002;
xlPaperNote = $00000012;
xlPaperQuarto = $0000000F;
xlPaperStatement = $00000006;
xlPaperTabloid = $00000003;
xlPaperUser = $00000100;
// XlPasteSpecialOperation constants
type
XlPasteSpecialOperation = TOleEnum;
const
xlPasteSpecialOperationAdd = $00000002;
xlPasteSpecialOperationDivide = $00000005;
xlPasteSpecialOperationMultiply = $00000004;
xlPasteSpecialOperationNone = $FFFFEFD2;
xlPasteSpecialOperationSubtract = $00000003;
// XlPasteType constants
type
XlPasteType = TOleEnum;
const
xlPasteAll = $FFFFEFF8;
xlPasteAllExceptBorders = $00000006;
xlPasteFormats = $FFFFEFE6;
xlPasteFormulas = $FFFFEFE5;
xlPasteComments = $FFFFEFD0;
xlPasteValues = $FFFFEFBD;
// XlPhoneticCharacterType constants
type
XlPhoneticCharacterType = TOleEnum;
const
xlKatakanaHalf = $00000000;
xlKatakana = $00000001;
xlHiragana = $00000002;
xlNoConversion = $00000003;
// XlPhoneticAlignment constants
type
XlPhoneticAlignment = TOleEnum;
const
xlPhoneticAlignNoControl = $00000000;
xlPhoneticAlignLeft = $00000001;
xlPhoneticAlignCenter = $00000002;
xlPhoneticAlignDistributed = $00000003;
// XlPictureAppearance constants
type
XlPictureAppearance = TOleEnum;
const
xlPrinter = $00000002;
xlScreen = $00000001;
// XlPivotFieldOrientation constants
type
XlPivotFieldOrientation = TOleEnum;
const
xlColumnField = $00000002;
xlDataField = $00000004;
xlHidden = $00000000;
xlPageField = $00000003;
xlRowField = $00000001;
// XlPivotFieldCalculation constants
type
XlPivotFieldCalculation = TOleEnum;
const
xlDifferenceFrom = $00000002;
xlIndex = $00000009;
xlNoAdditionalCalculation = $FFFFEFD1;
xlPercentDifferenceFrom = $00000004;
xlPercentOf = $00000003;
xlPercentOfColumn = $00000007;
xlPercentOfRow = $00000006;
xlPercentOfTotal = $00000008;
xlRunningTotal = $00000005;
// XlPlacement constants
type
XlPlacement = TOleEnum;
const
xlFreeFloating = $00000003;
xlMove = $00000002;
xlMoveAndSize = $00000001;
// XlPlatform constants
type
XlPlatform = TOleEnum;
const
xlMacintosh = $00000001;
xlMSDOS = $00000003;
xlWindows = $00000002;
// XlPrintLocation constants
type
XlPrintLocation = TOleEnum;
const
xlPrintSheetEnd = $00000001;
xlPrintInPlace = $00000010;
xlPrintNoComments = $FFFFEFD2;
// XlPriority constants
type
XlPriority = TOleEnum;
const
xlPriorityHigh = $FFFFEFE1;
xlPriorityLow = $FFFFEFDA;
xlPriorityNormal = $FFFFEFD1;
// XlPTSelectionMode constants
type
XlPTSelectionMode = TOleEnum;
const
xlLabelOnly = $00000001;
xlDataAndLabel = $00000000;
xlDataOnly = $00000002;
xlOrigin = $00000003;
xlButton = $0000000F;
xlBlanks = $00000004;
// XlRangeAutoFormat constants
type
XlRangeAutoFormat = TOleEnum;
const
xlRangeAutoFormat3DEffects1 = $0000000D;
xlRangeAutoFormat3DEffects2 = $0000000E;
xlRangeAutoFormatAccounting1 = $00000004;
xlRangeAutoFormatAccounting2 = $00000005;
xlRangeAutoFormatAccounting3 = $00000006;
xlRangeAutoFormatAccounting4 = $00000011;
xlRangeAutoFormatClassic1 = $00000001;
xlRangeAutoFormatClassic2 = $00000002;
xlRangeAutoFormatClassic3 = $00000003;
xlRangeAutoFormatColor1 = $00000007;
xlRangeAutoFormatColor2 = $00000008;
xlRangeAutoFormatColor3 = $00000009;
xlRangeAutoFormatList1 = $0000000A;
xlRangeAutoFormatList2 = $0000000B;
xlRangeAutoFormatList3 = $0000000C;
xlRangeAutoFormatLocalFormat1 = $0000000F;
xlRangeAutoFormatLocalFormat2 = $00000010;
xlRangeAutoFormatLocalFormat3 = $00000013;
xlRangeAutoFormatLocalFormat4 = $00000014;
xlRangeAutoFormatNone = $FFFFEFD2;
xlRangeAutoFormatSimple = $FFFFEFC6;
// XlReferenceType constants
type
XlReferenceType = TOleEnum;
const
xlAbsolute = $00000001;
xlAbsRowRelColumn = $00000002;
xlRelative = $00000004;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -