TsSpreadOOXMLWriter

type TsSpreadOOXMLWriter = class(TsCustomSpreadWriter)

protected

  FDateMode: TDateMode;

  FPointSeparatorSettings: TFormatSettings;

  FSharedStringsCount: Integer;

  FFillList: array of PsCellFormat;

  FBorderList: array of PsCellFormat;

  FDifferentialFormatIndexList: array of Integer;

  function GetActiveTab;

  procedure Get_rId();

  procedure AddBuiltinNumFormats; override;

  procedure CreateStreams;

  procedure DestroyStreams;

  function FindBorderInList();

  function FindFillInList();

  function GetStyleIndex();

  procedure ListAllBorders;

  procedure ListAllDifferentialFormats;

  procedure ListAllFills;

  function PrepareFormula();

  procedure ResetStreams;

  procedure WriteBorderList();

  procedure WriteCFCellRule();

  procedure WriteCFColorRangeRule();

  procedure WriteCFDataBarRule();

  procedure WriteCFIconSetRule();

  procedure WriteChart();

  procedure WriteChartColors;

  procedure WriteChartRels;

  procedure WriteCharts;

  procedure WriteChartStyles;

  procedure WriteColBreaks();

  procedure WriteCols();

  procedure WriteComments();

  procedure WriteConditionalFormat();

  procedure WriteConditionalFormats();

  procedure WriteCustomMetaData();

  procedure WriteDefinedNames();

  procedure WriteDifferentialFormat();

  procedure WriteDifferentialFormats();

  procedure WriteDimension();

  procedure WriteDrawings();

  procedure WriteDrawingRels();

  procedure WriteFillList();

  procedure WriteFont();

  procedure WriteFontList();

  procedure WriteHeaderFooter();

  procedure WriteHyperlinks();

  procedure WriteMetadata();

  procedure WriteMergedCells();

  procedure WriteNumFormatList();

  procedure WritePalette();

  procedure WritePageMargins();

  procedure WritePageSetup();

  procedure WritePrintOptions();

  procedure WriteRowBreaks();

  procedure WriteSheetData();

  procedure WriteSheetFormatPr();

  procedure WriteSheetPr();

  procedure WriteSheetProtection();

  procedure WriteSheets();

  procedure WriteSheetViews();

  procedure WriteStyle();

  procedure WriteStyleList();

  procedure WriteVMLDrawings();

  procedure WriteVMLDrawings_Comments();

  procedure WriteVMLDrawings_HeaderFooterImages();

  procedure WriteVMLDrawingRels();

  procedure WriteWorkbook();

  procedure WriteWorkbookProtection();

  procedure WriteWorkbookRels();

  procedure WriteWorksheet();

  procedure WriteWorksheetRels();

  FSContentTypes: TStream;

  FSRelsRels: TStream;

  FSWorkbook: TStream;

  FSWorkbookRels: TStream;

  FSMetaData: TStream;

  FSCustomMetaData: TStream;

  FSStyles: TStream;

  FSSharedStrings: TStream;

  FSSharedStrings_complete: TStream;

  FSMedia: array of TStream;

  FSSheets: array of TStream;

  FSSheetRels: array of TStream;

  FSCharts: array of TStream;

  FSChartRels: array of TStream;

  FSChartStyles: array of TStream;

  FSChartColors: array of TStream;

  FSComments: array of TStream;

  FSDrawings: array of TStream;

  FSDrawingsRels: array of TStream;

  FSVmlDrawings: array of TStream;

  FSVmlDrawingsRels: array of TStream;

  FCurSheetNum: Integer;

  procedure WriteContent;

  procedure WriteContentTypes;

  procedure WriteGlobalFiles;

  procedure WriteMedia();

  procedure WriteBlank(); override;

  procedure WriteBool(); override;

  procedure WriteDateTime(); override;

  procedure WriteError(); override;

  procedure WriteFormula(); override;

  procedure WriteLabel(); override;

  procedure WriteNumber(); override;

public

  constructor Create(); override;

  destructor Destroy; override;

  procedure WriteStringToFile();

  procedure WriteToStream(); override;

end;

TsSpreadOOXMLWriter

TsCustomSpreadWriter

TsBasicSpreadWriter

TsBasicSpreadReaderWriter

TObject