Aspose::Slides::Charts::ChartDataWorkbook Class Reference

Provides access to embedded Excel workbook More...

Inherits Aspose::Slides::Charts::IChartDataWorkbook, and Aspose::Slides::IDOMObject.

Public Member Functions

ASPOSE_SLIDES_SHARED_API System::SharedPtr< IChartCellCollectionGetCellCollection (System::String formula, bool skipHiddenCells)
 Gets the set of cells. More...
 
ASPOSE_SLIDES_SHARED_API System::SharedPtr< IChartDataCellGetCell (System::String worksheetName, int32_t row, int32_t column)
 Gets the cell that can be used for chart series or categories More...
 
ASPOSE_SLIDES_SHARED_API System::SharedPtr< IChartDataCellGetCell (int32_t worksheetIndex, int32_t row, int32_t column)
 Gets the cell that can be used for chart series or categories More...
 
ASPOSE_SLIDES_SHARED_API System::SharedPtr< IChartDataCellGetCell (int32_t worksheetIndex, System::String cellName)
 Gets the cell that can be used for chart series or categories More...
 
ASPOSE_SLIDES_SHARED_API System::SharedPtr< IChartDataCellGetCell (int32_t worksheetIndex, System::String cellName, System::SharedPtr< System::Object > value)
 Gets the cell that can be used for chart series or categories More...
 
ASPOSE_SLIDES_SHARED_API System::SharedPtr< IChartDataCellGetCell (int32_t worksheetIndex, int32_t row, int32_t column, System::SharedPtr< System::Object > value)
 Gets the cell that can be used for chart series or categories More...
 
ASPOSE_SLIDES_SHARED_API void Clear (int32_t sheetIndex)
 Clear all cells values on sheet More...
 

Protected Member Functions

Aspose::Slides::XlsxSerialization::WorkbookType get_WorkbookType ()
 
void set_WorkbookType (Aspose::Slides::XlsxSerialization::WorkbookType value)
 
System::SharedPtr< Aspose::Slides::Xlsx::XlsxLoadOptions > get_LoadOptions ()
 
System::SharedPtr< Aspose::Slides::Xlsx::ChartDataWorksheetCollection > get_Worksheets ()
 
System::SharedPtr< Aspose::Slides::Xlsx::StylesPartXLSXUnsupportedProps > get_StylesPartXLSXUnsupportedProps ()
 
System::SharedPtr< Aspose::Slides::Xlsx::WorkbookPartXLSXUnsupportedProps > get_WorkbookPartXLSXUnsupportedProps ()
 
System::SharedPtr< Chartget_ChartInternal ()
 Returns the parent chart. Read-only IChart. More...
 
System::SharedPtr< ChartDataget_ChartDataInternal ()
 
 ChartDataWorkbook (System::SharedPtr< ChartData > parentImmediate, System::SharedPtr< System::IO::Stream > stream)
 Initializes new instance of class ChartDataWorkbook from passed stream More...
 
 ChartDataWorkbook (System::SharedPtr< ChartData > parentImmediate)
 Initializes new instance of class ChartDataWorkbook from emdebbed template More...
 
void Write (System::SharedPtr< System::IO::Stream > output)
 Serializes workbook to xlsx and writes to output stream More...
 
System::String GetWorkbookFileExtention ()
 Returns workbook file extention More...
 
System::SharedPtr< ChartDataCellGetEmptyCell ()
 Gets the empty cell. More...
 
System::SharedPtr< ChartDataWorksheetGetOrCreateWorksheet (System::String worksheetName)
 
void AddDefinedName (System::String name, System::String value)
 
System::SharedPtr< System::Collections::Generic::List< System::SharedPtr< ChartDataCell > > > GetCells (System::String formulasString, bool skipHiddenCells, bool createNotExistedSheets)
 
System::SharedPtr< System::Collections::Generic::List< System::SharedPtr< ChartDataWorkbookFormula > > > ParseFormulas (System::String s)
 
System::SharedPtr< System::Collections::Generic::List< System::SharedPtr< ChartDataWorkbookFormula > > > TryRepareFormulas (uint32_t pointsCount, System::String &strF)
 
System::SharedPtr< System::Collections::Generic::List< System::SharedPtr< ChartDataWorkbookFormula > > > ParseFormulas (System::SharedPtr< Aspose::Slides::PptxSerialization::PartParser::XmlParser::cht_CT_StrRefElementData > strRefElementData)
 
System::SharedPtr< System::Collections::Generic::List< System::SharedPtr< ChartDataWorkbookFormula > > > ParseFormulas (System::SharedPtr< Aspose::Slides::PptxSerialization::PartParser::XmlParser::cht_CT_NumRefElementData > strRefElementData)
 
bool CheckFStringCanBeResolved (System::String s)
 
void UpdateWorkbookTableRanges ()
 
void ReadWorkbook (System::SharedPtr< Aspose::Slides::Xlsx::WorkbookML::XlsxFile > package)
 

Static Protected Member Functions

static bool ParseCellsAdress (System::String cellAdress, int32_t &columnIndex, int32_t &rowIndex)
 Parses cells adress to column and row indexes. More...
 
static void SaveXmpDocumentToEntry (System::SharedPtr< Aspose::Slides::Xlsx::PresentationML::PptxSaveContext > context, System::SharedPtr< System::IO::Stream > stream, System::SharedPtr< System::Xml::XmlDocument > document)
 
static void CheckUsedRelationships (System::SharedPtr< Aspose::Slides::Xlsx::PresentationML::PptxBaseXmlDocument > document)
 

Detailed Description

Provides access to embedded Excel workbook

Constructor & Destructor Documentation

◆ ChartDataWorkbook() [1/2]

Aspose::Slides::Charts::ChartDataWorkbook::ChartDataWorkbook ( System::SharedPtr< ChartData parentImmediate,
System::SharedPtr< System::IO::Stream >  stream 
)
protected

Initializes new instance of class ChartDataWorkbook from passed stream

Parameters
parentImmediateThe parent chart object
streamThe data stream

◆ ChartDataWorkbook() [2/2]

Aspose::Slides::Charts::ChartDataWorkbook::ChartDataWorkbook ( System::SharedPtr< ChartData parentImmediate)
protected

Initializes new instance of class ChartDataWorkbook from emdebbed template

Parameters
parentImmediateThe parent chart object

Member Function Documentation

◆ AddDefinedName()

void Aspose::Slides::Charts::ChartDataWorkbook::AddDefinedName ( System::String  name,
System::String  value 
)
protected

◆ CheckFStringCanBeResolved()

bool Aspose::Slides::Charts::ChartDataWorkbook::CheckFStringCanBeResolved ( System::String  s)
protected

◆ CheckUsedRelationships()

static void Aspose::Slides::Charts::ChartDataWorkbook::CheckUsedRelationships ( System::SharedPtr< Aspose::Slides::Xlsx::PresentationML::PptxBaseXmlDocument >  document)
staticprotected

◆ Clear()

ASPOSE_SLIDES_SHARED_API void Aspose::Slides::Charts::ChartDataWorkbook::Clear ( int32_t  sheetIndex)
virtual

Clear all cells values on sheet

Parameters
sheetIndexIndex of sheet

Implements Aspose::Slides::Charts::IChartDataWorkbook.

◆ get_ChartDataInternal()

System::SharedPtr<ChartData> Aspose::Slides::Charts::ChartDataWorkbook::get_ChartDataInternal ( )
protected

◆ get_ChartInternal()

System::SharedPtr<Chart> Aspose::Slides::Charts::ChartDataWorkbook::get_ChartInternal ( )
protected

Returns the parent chart. Read-only IChart.

◆ get_LoadOptions()

System::SharedPtr<Aspose::Slides::Xlsx::XlsxLoadOptions> Aspose::Slides::Charts::ChartDataWorkbook::get_LoadOptions ( )
protected

◆ get_StylesPartXLSXUnsupportedProps()

System::SharedPtr<Aspose::Slides::Xlsx::StylesPartXLSXUnsupportedProps> Aspose::Slides::Charts::ChartDataWorkbook::get_StylesPartXLSXUnsupportedProps ( )
protected

◆ get_WorkbookPartXLSXUnsupportedProps()

System::SharedPtr<Aspose::Slides::Xlsx::WorkbookPartXLSXUnsupportedProps> Aspose::Slides::Charts::ChartDataWorkbook::get_WorkbookPartXLSXUnsupportedProps ( )
protected

◆ get_WorkbookType()

Aspose::Slides::XlsxSerialization::WorkbookType Aspose::Slides::Charts::ChartDataWorkbook::get_WorkbookType ( )
protected

◆ get_Worksheets()

System::SharedPtr<Aspose::Slides::Xlsx::ChartDataWorksheetCollection> Aspose::Slides::Charts::ChartDataWorkbook::get_Worksheets ( )
protected

◆ GetCell() [1/5]

ASPOSE_SLIDES_SHARED_API System::SharedPtr<IChartDataCell> Aspose::Slides::Charts::ChartDataWorkbook::GetCell ( System::String  worksheetName,
int32_t  row,
int32_t  column 
)
virtual

Gets the cell that can be used for chart series or categories

Parameters
worksheetNameName of the worksheet.
rowThe row.
columnThe column.
Returns
Cell object

Implements Aspose::Slides::Charts::IChartDataWorkbook.

◆ GetCell() [2/5]

ASPOSE_SLIDES_SHARED_API System::SharedPtr<IChartDataCell> Aspose::Slides::Charts::ChartDataWorkbook::GetCell ( int32_t  worksheetIndex,
int32_t  row,
int32_t  column 
)
virtual

Gets the cell that can be used for chart series or categories

Parameters
worksheetIndexIndex of the worksheet.
rowThe row.
columnThe column.
Returns
Cell object

Implements Aspose::Slides::Charts::IChartDataWorkbook.

◆ GetCell() [3/5]

ASPOSE_SLIDES_SHARED_API System::SharedPtr<IChartDataCell> Aspose::Slides::Charts::ChartDataWorkbook::GetCell ( int32_t  worksheetIndex,
System::String  cellName 
)
virtual

Gets the cell that can be used for chart series or categories

Parameters
worksheetIndexIndex of the worksheet.
cellNameName of the cell.
Returns
Cell object

Implements Aspose::Slides::Charts::IChartDataWorkbook.

◆ GetCell() [4/5]

ASPOSE_SLIDES_SHARED_API System::SharedPtr<IChartDataCell> Aspose::Slides::Charts::ChartDataWorkbook::GetCell ( int32_t  worksheetIndex,
System::String  cellName,
System::SharedPtr< System::Object value 
)
virtual

Gets the cell that can be used for chart series or categories

Parameters
worksheetIndexIndex of the worksheet.
cellNameName of the cell.
valueThe value.
Returns
Cell object

Implements Aspose::Slides::Charts::IChartDataWorkbook.

◆ GetCell() [5/5]

ASPOSE_SLIDES_SHARED_API System::SharedPtr<IChartDataCell> Aspose::Slides::Charts::ChartDataWorkbook::GetCell ( int32_t  worksheetIndex,
int32_t  row,
int32_t  column,
System::SharedPtr< System::Object value 
)
virtual

Gets the cell that can be used for chart series or categories

Parameters
worksheetIndexIndex of the worksheet.
rowThe row.
columnThe column.
valueThe value.
Returns
Cell object

Implements Aspose::Slides::Charts::IChartDataWorkbook.

◆ GetCellCollection()

ASPOSE_SLIDES_SHARED_API System::SharedPtr<IChartCellCollection> Aspose::Slides::Charts::ChartDataWorkbook::GetCellCollection ( System::String  formula,
bool  skipHiddenCells 
)
virtual

Gets the set of cells.

Parameters
formulaExcel formula like "Sheet1!$A$2:$A$5".
skipHiddenCellsIf true then method returns collection without hidden cells.

Implements Aspose::Slides::Charts::IChartDataWorkbook.

◆ GetCells()

System::SharedPtr<System::Collections::Generic::List<System::SharedPtr<ChartDataCell> > > Aspose::Slides::Charts::ChartDataWorkbook::GetCells ( System::String  formulasString,
bool  skipHiddenCells,
bool  createNotExistedSheets 
)
protected

◆ GetEmptyCell()

System::SharedPtr<ChartDataCell> Aspose::Slides::Charts::ChartDataWorkbook::GetEmptyCell ( )
protected

Gets the empty cell.

Returns
Exceptions
System::InvalidOperationExceptionWorksheet's limit exceeded, use ChartDataWorkbook.GetCell to add cells to chart

◆ GetOrCreateWorksheet()

System::SharedPtr<ChartDataWorksheet> Aspose::Slides::Charts::ChartDataWorkbook::GetOrCreateWorksheet ( System::String  worksheetName)
protected

◆ GetWorkbookFileExtention()

System::String Aspose::Slides::Charts::ChartDataWorkbook::GetWorkbookFileExtention ( )
protected

Returns workbook file extention

Returns

◆ ParseCellsAdress()

static bool Aspose::Slides::Charts::ChartDataWorkbook::ParseCellsAdress ( System::String  cellAdress,
int32_t &  columnIndex,
int32_t &  rowIndex 
)
staticprotected

Parses cells adress to column and row indexes.

Parameters
cellAdressThe cells adress. E.g: "$AZ$3" , "B$78", "C3"
columnIndexThe output zero-based column index
rowIndexThe output zero-based row index
Returns
True if parsing is successfull, otherwise false

◆ ParseFormulas() [1/3]

System::SharedPtr<System::Collections::Generic::List<System::SharedPtr<ChartDataWorkbookFormula> > > Aspose::Slides::Charts::ChartDataWorkbook::ParseFormulas ( System::String  s)
protected

◆ ParseFormulas() [2/3]

System::SharedPtr<System::Collections::Generic::List<System::SharedPtr<ChartDataWorkbookFormula> > > Aspose::Slides::Charts::ChartDataWorkbook::ParseFormulas ( System::SharedPtr< Aspose::Slides::PptxSerialization::PartParser::XmlParser::cht_CT_StrRefElementData >  strRefElementData)
protected

◆ ParseFormulas() [3/3]

System::SharedPtr<System::Collections::Generic::List<System::SharedPtr<ChartDataWorkbookFormula> > > Aspose::Slides::Charts::ChartDataWorkbook::ParseFormulas ( System::SharedPtr< Aspose::Slides::PptxSerialization::PartParser::XmlParser::cht_CT_NumRefElementData >  strRefElementData)
protected

◆ ReadWorkbook()

void Aspose::Slides::Charts::ChartDataWorkbook::ReadWorkbook ( System::SharedPtr< Aspose::Slides::Xlsx::WorkbookML::XlsxFile >  package)
protected

◆ SaveXmpDocumentToEntry()

static void Aspose::Slides::Charts::ChartDataWorkbook::SaveXmpDocumentToEntry ( System::SharedPtr< Aspose::Slides::Xlsx::PresentationML::PptxSaveContext >  context,
System::SharedPtr< System::IO::Stream >  stream,
System::SharedPtr< System::Xml::XmlDocument >  document 
)
staticprotected

◆ set_WorkbookType()

void Aspose::Slides::Charts::ChartDataWorkbook::set_WorkbookType ( Aspose::Slides::XlsxSerialization::WorkbookType  value)
protected

◆ TryRepareFormulas()

System::SharedPtr<System::Collections::Generic::List<System::SharedPtr<ChartDataWorkbookFormula> > > Aspose::Slides::Charts::ChartDataWorkbook::TryRepareFormulas ( uint32_t  pointsCount,
System::String &  strF 
)
protected

◆ UpdateWorkbookTableRanges()

void Aspose::Slides::Charts::ChartDataWorkbook::UpdateWorkbookTableRanges ( )
protected

◆ Write()

void Aspose::Slides::Charts::ChartDataWorkbook::Write ( System::SharedPtr< System::IO::Stream >  output)
protected

Serializes workbook to xlsx and writes to output stream

Parameters
outputThe output stream