HotXLS 문서 - 목차

컴포넌트 참조

TGridToXLS
- 속성
- 메서드
- 이벤트
TXLSWorkbookViewer
TDataToXLS
- 속성
- 메서드
- 이벤트
TcxGridAddExcel
- 속성
- 메서드
- 이벤트
  - Export 이벤트

클래스 참조

IXLSWorkbook
- 속성
- 메서드
TXLSWorksheet
- 속성
  - 셀
  - Selection
  - PageSetup
  - 범위
  - RCRange
  - UsedRange
  - 이름
  - Names
  - 인덱스
  - Next
  - Previous
  - HPageBreaks
  - VPageBreaks
  - GridlineColorIndex
  - DisplayGridLines
  - DisplayFormulas
  - DisplayHeadings
  - DisplayOutlineSymbols
  - DisplayZeros
  - DisplayRightToLeft
  - ScrollRow
  - ScrollColumn
  - Zoom
  - NormalViewZoom
  - PageBreakPreviewZoom
  - View
  - Selected
  - StandardHeight
  - StandardWidth
  - 하이퍼링크
  - Shapes
  - Visible
  - Outline
  - IsProtected
  - Protection permissions
  - AutoFilterRange
  - AutoFilterColumns
  - 표
  - TabColor
  - SheetTypeRaw
- 메서드
TXLSWorksheets
- 속성
- 메서드
IXLSRange
- 속성
  - 테두리
  - 셀
  - 열
  - 열
  - ColumnWidth
  - 너비
  - WidthInPixels
  - Comment
  - Count
  - EntireColumn
  - EntireRow
  - 글꼴
  - 수식
  - FormulaHidden
  - HasFormula
  - HorizontalAlignment
  - 하이퍼링크
  - IndentLevel
  - Interior
  - Item
  - Locked
  - NumberFormat
  - MergeArea
  - MergeCells
  - Offset
  - Orientation
  - OutlineLevel
  - ReadingOrder
  - 행
  - RowHeight
  - 행
  - ShrinkToFit
  - 값
  - VerticalAlignment
  - 워크시트
  - WrapText
  - 범위 bounds / XFIndex
  - 행 및 열 범위 interfaces
- 메서드
  - AddComment
  - AutoFit
  - Autofilter
  - ApplyBuiltinStyle
  - ApplyFormat
  - CaptureFormat
  - Clear
  - ClearContents
  - ClearComments
  - ClearOutline
  - Copy
  - 삭제
  - Group
  - Insert
  - Merge
  - Move
  - SaveAs
  - SaveAsCSV
  - SaveAsHTML
  - SetArrayFormula
  - PasteFrom / ShiftTo / ExtendRange / ContractRange
  - Select
  - UnGroup
  - Unmerge
IXLSPageSetup
- 속성
- 메서드
  - SetPrintArea
  - ClearPrinterDriverData
IXLSInterior
- 속성
- 메서드
  - SetThemeColor
  - SetPatternThemeColor
IXLSBorder
- 속성
  - 색
  - ColorIndex
  - LineStyle
  - 두께
- 메서드
  - SetThemeColor
IXLSBorders
- 속성
  - 색
  - ColorIndex
  - LineStyle
  - 두께
  - Item
IXLSFont
- 속성
  - 이름
  - Size
  - ColorIndex
  - 색
  - Bold
  - Italic
  - Strikethrough
  - OutLineFont
  - Shadow
  - CharSet / Family
  - Underline
  - SubScript
  - SuperScript
- 메서드
  - SetThemeColor
TXLSHPageBreaks
- 속성
  - Count
  - Item
- 메서드
  - 추가
TXLSHPageBreak
- 속성
  - Location
- 메서드
  - 삭제
TXLSVPageBreaks
- 속성
  - Count
  - Item
- 메서드
  - 추가
TXLSVPageBreak
- 속성
  - Location
- 메서드
  - 삭제
TXLSComment
- 속성
  - Visible
  - 텍스트
  - Shape
TXLSFormatSnapshot
- 메서드
  - ApplyTo
TXLSShape
- 속성
  - 높이
  - 너비
  - 선
  - Fill
  - OfficeArtOptions
- 메서드
  - 삭제
TXLSTextBox
- 속성
  - 텍스트
  - TextRuns
  - Row1
  - Row1Offs
  - Col1
  - Col1Offs
  - Row2
  - Row2Offs
  - Col2
  - Col2Offs
- 메서드
  - SetArea
TXLSOfficeArtOptions
- Members
  - IsDefined / LongValue / WideStringValue / Delete
TXLSShapes
- 속성
  - Count
  - Items
- 메서드
클래식 폼 컨트롤
- TXLSButton
- TXLSRadioButton
- TXLSCheckBox
- TXLSComboBox
- TXLSListBox
TXLSColorFormat
- 속성
  - RGB
  - SchemeColor
- Free helpers (lxHandle unit)
  - XlsApplyThemeColorToDrawing — 통합 문서 테마 idx + tint를 드로잉 색 슬롯(도형, 차트 채우기)에 할당합니다
  - XlsGetDrawingThemeColor — 같은 프로세스 안에서 드로잉 색 슬롯에 마지막으로 할당된 테마 idx + tint를 되돌려줍니다 (v2.64.0부터)
TXLSFillFormat
- 속성
  - ForeColor
  - Visible
- 메서드
  - Solid
TXLSLineFormat
- 속성
  - 스타일
  - DashStyle
  - ForeColor
  - Visible
  - 두께
IXLSHyperLinks
- 속성
  - Count
  - Item
- 메서드
  - 추가
  - 삭제
IXLSHyperLink
- 속성
  - Address
  - 범위
  - ScreenTip
  - SubAddress
  - DisplayText
- 메서드
  - 삭제
IXLSName
- 속성
  - 이름
  - RefersTo
  - RefersToRange
  - Visible
  - 인덱스
  - Comment
- 메서드
  - 삭제
IXLSNames
- 속성
  - Item
  - Count
- 메서드
  - 추가
  - FindByCell
TXLSOutline
- 속성
TXLSVBAProject
- 속성
  - Count / Item
TXLSVBAModule
- 속성
  - 이름 / SourceCode
TXLSTable / TXLSTables
- TXLSTable 속성
  - Id / 이름 / DisplayName / 범위 / 열 / StyleName / ShowFirstColumn / ShowLastColumn / ShowRowStripes / ShowColumnStripes / TotalsRowShown
- TXLSTables members
  - Add (2개 오버로드) / Delete / Clear / Count / Items
TCondFormat / TCondFormatRule
- Enumerations
  - TXLSCfValueKind / TXLSIconSetType
- Spec 클래스
  - TXLSCfValue / TXLSDataBarSpec / TXLSColorScaleSpec / TXLSIconSetSpec
- TCondFormatRule 속성
  - Kind / cfType / Operator_ / DataBar / ColorScale / IconSet / 스타일 / DxfBlob
- TCondFormat members
  - ClearRow / ClearCol / ClearRange / MoveRanges / Range / IsEmpty / IsExt12
TXLSDxfStyle
- Setters
  - SetFontColor / SetFontColorTheme / SetFillBgColor / SetFillBgColorTheme / SetFillFgColor / SetFillFgColorTheme / SetFillPattern / SetFontBold / SetFontItalic / SetFontUnderline / SetNumFormatId
- 속성 (per slot)
  - HasXxx / XxxColor / XxxColorIsTheme / XxxColorThemeId / XxxColorThemeTint
TXLSHTMLExport
- 속성
  - Options / Title / SimpleExport / TableBorderWidth / CellPadding / CellSpacing
- 메서드
  - 통합 문서, 워크시트, 범위, 파일, 스트림 출력을 위한 SaveAsHTML 오버로드

XLSX 파사드 (lxHandleX)

Overview 및 quick start
컴파일된 보고 API
통합 문서 보기, 연결 및 XML 맵
워크시트 분할창 선택
수식 토큰 및 사용자 함수
고급 렌더링 및 내보내기
계산 및 변환 충실도
XLSB 값 및 스타일
추가 XLSX 파사드 API 멤버
- Option 클래스 및 helpers
  - TXLSXHtmlExportOptions / XlsxColumnLabel / XlsxCellRef / XlsxColumnIndex / XlsxParseCellRef / XlsxParseRangeRef / XlsxEscapeText / XlsxEscapeAttr
고급 XLSX API 멤버
TXLSXWorkbook
- 메서드
  - CreateLoadedCellCursor
  - CreateReadOnlyView
  - SaveSemanticSnapshot / ComputeSemanticHash
  - CaptureRenderCalibration / ResetRenderCalibration
  - CreateRenderGeometry
  - ResolveIndexedColor
  - ScanIndexedColorUsage
  - BuildBiffPalettePlan
  - ApplyBiffPalettePlan
  - SaveAs / Open / OpenCSV / OpenODS / SaveAsHTML options
- 속성
  - Sheets / Fonts / Fills / Borders / NumberFormats / DefinedNames
  - RenderCalibration
TXLSXSharedStrings
- Members
  - 추가 / AddRich / IndexOf / Clear / Count / RefCount / Items / RichItems
TXLSXSheets
- 메서드
  - 추가 / Clear / IndexByName / SheetByName / TryGetSheetByName
- 속성
  - Count / Items
TXLSXFont / TXLSXFonts
- TXLSXFont 속성
  - Name / Size / Bold / Italic / Strikethrough / Underline / Color / ColorIsAuto
- TXLSXFonts members
  - Add (3개 오버로드) / Clear / Count / Items
TXLSXFill / TXLSXFills
- TXLSXFill 속성
  - Pattern / ForegroundColor / ForegroundIsAuto / BackgroundColor / BackgroundIsAuto
- TXLSXFills members
  - 추가 / AddSolid / Clear / Count / Items
TXLSXBorder / TXLSXBorders
- TXLSXBorder 속성
  - Left / Right / Top / Bottom / Diagonal (각각 = Style + Color + ColorIsAuto)
- 범위 테두리 selectors
  - TXLSXBorderEdgeKind / xlsxEdgeAll / xlsxEdgeOutline / xlsxEdgeInside / directional 및 diagonal edge selectors
- TXLSXBorders members
  - 추가 / AddBox / Clear / Count / Items
  - LookupOrAdd
TXLSXNumberFormat / TXLSXNumberFormats
- Members
  - FormatCode / 추가 / IndexOf / Clear / Count / Items
TXLSXDefinedName / TXLSXDefinedNames
- TXLSXDefinedName 속성
  - Name / Formula / SheetIndex / Hidden / Comment
- TXLSXDefinedNames members
  - Add (2개 오버로드) / IndexOfName / Clear / Count / Items
TXLSXExternalLink / TXLSXExternalLinks
- TXLSXExternalLink 속성
  - Target / SheetNames
- TXLSXExternalLinks members
  - 추가 / Clear / Count / Items
TXLSXWorksheet
- 메서드
  - Calculate / MergeCells / ForEachCell / ForEachRow / FindText / ReplaceText / WriteCells / WriteRows / AddHyperlink / AddComment / AddImage / AddImageFromFile / AddTextBox / TextBoxCount / TextBox / FindTextBoxAt / DeleteTextBoxAt / DeleteTextBoxesInRange / ClearTextBoxes / AddConditionalFormat / AddCondFormatExpression / AddCondFormatContainsText / AddCondFormatTop10 / AddCondFormatAboveAverage / AddCondFormatDuplicateValues / AddCondFormatContainsBlanks / AddDataValidation / AddListValidation / AutoFitColumn / AutoFitColumns / AutoFitRow / AutoFitRows / InsertRows / DeleteRows / InsertCols / DeleteCols / AddRowBreak / AddColBreak / IndexOfRowBreak / IndexOfColBreak / RemoveRowBreaksInRange / RemoveColBreaksInRange / ClearRowBreaks / ClearColBreaks / ClearPrinterDriverData / KeepRowLinkLevel / KeepColLinkLevel / SortRange / ClearRowHidden / ClearColHidden / ClearRowCollapsed / ClearColCollapsed / SetAutoFilter / AddAutoFilterColumn / AutoFilterRowVisible / PreviewAutoFilterRows / SetColWidth / SetRowHeight / EntireRow / EntireColumn / SetWorkbook / SetIsSelected / Subtotal / SubtotalDefaultEnglishString / AddRawDrawingAnchor / BringToFront / SendToBack / BringForward
- 속성
  - Name / Visibility / Visible / IsSelected / Workbook / StructuralEditRegistry / PageSetupTouched / SheetProtectHash / Zoom / DisplayGridLines / DisplayZeros / DisplayRightToLeft / StandardWidth / StandardHeight / Cells / Range / RCRange / UsedRange / MergedCells / Hyperlinks / Comments / Images / ConditionalFormats / DataValidations / Tables / Charts / AutoFilterRange / AutoFilterColumns / HeaderText / FooterText / LeftHeader / CenterHeader / RightHeader / LeftFooter / CenterFooter / RightFooter / CenterHorizontally / CenterVertically / PrintArea / PrintTitleRows / PrintTitleCols / PrinterDriverData / HasPrinterDriverData / BlackAndWhite / Draft / PrintNotes / PrintOverThenDown / ColWidth / RowHeight
TXLSXStructuralEditRegistry
- Members
  - RegisterParticipant / UnregisterParticipant / Clear / Count
TXLSFormulaDebugger
- Members
  - Analyze / Formula / FinalValue / Nodes / Dependencies / StepNodes / CurrentNode / MoveFirst / MoveNext / MovePrevious / SeekNode / Reset / ErrorOriginNodeId / ErrorCode / ErrorText
TXLSPaginationModel
- Members
  - Build / Clear / Count / Pages / RenderPage / CreatePageMetafile / SavePageAsMetafile / UseWorksheetPageSetup / Orientation / Margin / DefaultRowHeight
TXLSXRange
- Members
  - Create(ASheet, ARow1, ACol1, ARow2, ACol2) / RefA1 / SaveAsHTML / SetValue / SetFormula / Clear / ClearAll / SetNumberFormat / SetBorders / AutoFitColumns / AutoFitRows / Merge / Unmerge / Offset / Resize / Sort / ApplyBuiltinStyle / CopyTo / MoveTo / InsertRows / DeleteRows / InsertCols / DeleteCols
TXLSXCells / TXLSXCell
- TXLSXCell 속성
  - Row / Col / Value / FormatIndex / FontIndex / FillIndex / BorderIndex / NumberFormatIndex / NumberFormat / AlignmentIndex / ProtectionIndex / Formula / RichText / Locked / FormulaHidden / Workbook / ArrayRootRow / ArrayRootCol / ArrayLastRow / ArrayLastCol
- TXLSXCells members
  - 만들기 / Destroy / Remove / Item[행, Col] / Count / CellByIndex / HasCell / Clear
TXLSXMergedCells / TXLSXMergedRange
- TXLSXMergedRange 속성
  - Row1 / Col1 / Row2 / Col2 / Ref
- TXLSXMergedCells members
  - 추가 / Clear / Count / Items
TXLSXHyperlinks / TXLSXHyperlink
- TXLSXHyperlink 속성
  - Row / Col / Url / Display / Tooltip
- TXLSXHyperlinks members
  - Add (3개 오버로드) / Clear / Count / Items
TXLSXComments / TXLSXComment
- TXLSXComment 속성
  - 행 / Col / Author / 텍스트
- TXLSXComments members
  - Add (2개 오버로드) / Clear / Count / Items
TXLSXAutoFilterColumn / TXLSXAutoFilterColumns
- Members
  - ColId / Op1 / Op2 / Criteria1 / Criteria2 / TXLSXAutoFilterOp / IndexOfColId / FindByColId / DeleteByColId / Clear / Count / Items
TXLSXImage / TXLSXImages
- TXLSXImage 속성
  - Row / Col / WidthEMU / HeightEMU / Format / Data / AnchorType / CropLeft / CropTop / CropRight / CropBottom / Transparency / Brightness / Contrast / Rotation / FillMode / HasPreservedXml / ClearPreservedXml
- TXLSXImages members
  - 추가 / Clear / Count / Items
TXLSXHeaderFooterImage / TXLSXHeaderFooterImages
- 이미지 속성
  - PageKind / Position / WidthPt / HeightPt / MarginLeftPt / MarginTopPt / Format / Data / Title
- 컬렉션 멤버
  - Add / AddFromFile / IndexOf / Find / Delete / Assign / Clear / Count / Items
TXLSXConditionalFormat / TXLSXConditionalFormats
- TXLSXConditionalFormat 속성
  - 범위 / Op / Formula1 / Formula2
- TXLSXConditionalFormats members
  - Add (2개 오버로드) / Clear / Count / Items
TXLSXDataValidation / TXLSXDataValidations
- TXLSXDataValidation 속성
  - 범위 / ValidationType / Op / Formula1 / Formula2 / AllowBlank / ShowInputMessage / ShowErrorMessage / PromptTitle / Prompt / ErrorTitle / ErrorMessage / ErrorStyle / ShowDropDown
- TXLSXDataValidations members
  - Add (2개 오버로드) / AddList / Clear / Count / Items
TXLSXTable / TXLSXTables
- Members
  - 이름 / DisplayName / Ref / StyleName / ShowFirstColumn / ShowLastColumn / ShowRowStripes / ShowColumnStripes / 추가 / 삭제 / Clear / Count / Items
TXLSXChart / TXLSXCharts
- Members
  - ChartType / xlsxChartScatter / xlsxChartBubble / xlsxChartRadar / Title / TitleTextStyle / TitleLayout / PlotAreaLayout / ShowLegend / LegendPosition / LegendTextStyle / LegendLayout / CategoryAxisTitle / ValueAxisTitle / FromRow / FromCol / ToRow / ToCol / AddSeries / BubbleSizeRange / ClearSeries / SeriesCount / Series / Add / Clear / Count / Items
  - TXLSXChartTextStyle
  - TXLSXChartLayout
TXLSXRichText
- Members
  - TXLSXRichTextRun 텍스트 / 이름 / Size / Bold / Italic / Strikethrough / Underline / 색 / ColorIsAuto / VertAlign / AddRun / AddRunText / Clear / RunCount / PlainText / Runs
TXLSXAlignment / TXLSXAlignments
- Members
  - Horizontal / Vertical / WrapText / ShrinkToFit / TextRotation / Indent / Add / Clear / Count / Items
TXLSXProtection / TXLSXProtections
- Members
  - Locked / FormulaHidden / IsDefault / 추가 / IndexOf / Clear / Count / Items
TXLSXNamedStyle / TXLSXNamedStyles
- Members
  - Name / XfId / BuiltInId / CustomBuiltIn / Hidden / BuiltinLevel / Add / Clear / Count / Items
TXLSXProtectedRange / TXLSXProtectedRanges
- Members
  - Name / Sqref / Password / SecurityDescriptor / Add / Clear / Count / Items

개요

셀 및 범위

컴포넌트 참조

클래스 참조

XLSX 파사드 (lxHandleX)

예제