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

System::SharedPtr< IDOMObjectget_Parent_Immediate ()
 Returns Parent_Immediate object. Read-only IDOMObject. More...
 
System::SharedPtr< IChartCellCollectionGetCellCollection (System::String formula, bool skipHiddenCells)
 Gets the set of cells. More...
 
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...
 
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...
 
System::SharedPtr< IChartDataCellGetCell (int32_t worksheetIndex, System::String cellName)
 Gets the cell that can be used for chart series or categories More...
 
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...
 
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...
 
void Clear (int32_t sheetIndex)
 Clear all cells values on sheet More...
 
- Public Member Functions inherited from System::Object
 Object ()
 Creates object. Initializes all internal data structures. More...
 
virtual ~Object ()
 Destroys object. Frees all internal data structures. More...
 
 Object (Object const &x)
 Copy constructor. Doesn't copy anything, really, just initializes new object and enables copy constructing subclasses. More...
 
Objectoperator= (Object const &x)
 Assignment operator. Doesn't copy anything, really, just initializes new object and enables copy constructing subclasses. More...
 
ObjectSharedRefAdded ()
 Increments shared reference count. Shouldn't be called directly; instead, use smart pointers or ThisProtector. More...
 
int SharedRefRemovedSafe ()
 Decrements and returns shared reference count. Shouldn't be called directly; instead, use smart pointers or ThisProtector. More...
 
int RemovedSharedRefs (int count)
 Decreases shared reference count by specified value. More...
 
Detail::SmartPtrCounter * WeakRefAdded ()
 Increments weak reference count. Shouldn't be called directly; instead, use smart pointers or ThisProtector. More...
 
void WeakRefRemoved ()
 Decrements weak reference count. Shouldn't be called directly; instead, use smart pointers or ThisProtector. More...
 
Detail::SmartPtrCounter * GetCounter ()
 Gets reference counter data structure associated with the object. More...
 
int SharedCount () const
 Gets current value of shared refernce counter. More...
 
void Lock ()
 Implements C# lock() statement locking. Call directly or use LockContext sentry object. More...
 
void Unlock ()
 Implements C# lock() statement unlocking. Call directly or use LockContext sentry object. More...
 
virtual bool Equals (ptr obj)
 Compares objects using C# Object.Equals semantics. More...
 
virtual int GetHashCode () const
 Analog of C# Object.GetHashCode() method. Enables hashing of custom objects. More...
 
virtual String ToString () ASPOSE_CONST
 Analog of C# Object.ToString() method. Enables converting custom objects to string. More...
 
virtual ptr MemberwiseClone () const
 Analog of C# Object.MemberwiseClone() method. Enables cloning custom types. More...
 
virtual const TypeInfoGetType () const
 Gets actual type of object. Analog of C# System.Object.GetType() call. More...
 
virtual bool Is (const TypeInfo &targetType) const
 Check if object represents an instance of type described by targetType. Analog of C# 'is' operator. More...
 
virtual void SetTemplateWeakPtr (unsigned int argument)
 Set n'th template argument a weak pointer (rather than shared). Allows switching pointers in containers to weak mode. More...
 
template<>
bool Equals (float const &objA, float const &objB)
 
template<>
bool Equals (double const &objA, double const &objB)
 
template<>
bool ReferenceEquals (String const &str, std::nullptr_t)
 
template<>
bool ReferenceEquals (String const &str1, String const &str2)
 

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, System::SharedPtr< Aspose::Foundation::Blob::BlobManager > blobManager, System::SharedPtr< InterruptionToken > interruptionToken)
 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)
 

Additional Inherited Members

- Public Types inherited from System::Object
typedef SmartPtr< Objectptr
 Alias for smart pointer type. More...
 
typedef System::Details::SharedMembersType shared_members_type
 structure to keep list of shared pointers contained in object. More...
 
- Static Public Member Functions inherited from System::Object
static bool ReferenceEquals (ptr const &objA, ptr const &objB)
 Compares objects by reference. More...
 
template<typename T >
static std::enable_if<!IsSmartPtr< T >::value, bool >::type ReferenceEquals (T const &objA, T const &objB)
 Compares objects by reference. More...
 
template<typename T >
static std::enable_if<!IsSmartPtr< T >::value, bool >::type ReferenceEquals (T const &objA, std::nullptr_t)
 Reference-compares value type object with nullptr. More...
 
template<typename T1 , typename T2 >
static std::enable_if< IsSmartPtr< T1 >::value &&IsSmartPtr< T2 >::value, bool >::type Equals (T1 const &objA, T2 const &objB)
 Compares reference type objects in C# style. More...
 
template<typename T1 , typename T2 >
static std::enable_if<!IsSmartPtr< T1 >::value &&!IsSmartPtr< T2 >::value, bool >::type Equals (T1 const &objA, T2 const &objB)
 Compares value type objects in C# style. More...
 
static const TypeInfoType ()
 Impleemnts C# typeof(System.Object) construct. More...
 

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,
System::SharedPtr< Aspose::Foundation::Blob::BlobManager >  blobManager,
System::SharedPtr< InterruptionToken interruptionToken 
)
protected

Initializes new instance of class ChartDataWorkbook from passed stream

Parameters
parentImmediateThe parent chart object
streamThe data stream
blobManagerThe blob manager for workbook-related resources
interruptionTokenThe token to monitor for interruption requests.

◆ 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()

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_Parent_Immediate()

System::SharedPtr<IDOMObject> Aspose::Slides::Charts::ChartDataWorkbook::get_Parent_Immediate ( )
virtual

Returns Parent_Immediate object. Read-only IDOMObject.

Implements Aspose::Slides::IDOMObject.

◆ 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]

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]

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]

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]

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]

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()

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