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...
 
- 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...
 
void SharedRefRemoved ()
 Decrements shared reference count and deletes object if it hits zero. Shouldn't be called directly; instead, use smart pointers or ThisProtector. 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 FreeOrDetectCycles (int count)
 Reacts on shared reference counter decrement. Shouldn't be called directly, use smart pointers instead. If neccessary, deletes the object. If allowed, initiates loop references lookup. 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...
 
void __FreePointers ()
 Resets all smart pointers stored inside this object directly (in fields) or indirectly (in value type fields). Used by memory management systems, shouldn't be called directly. 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)
 
- Protected Member Functions inherited from System::Object
template<class Container , typename Value = typename Container::value_type>
std::enable_if<!System::IsSmartPtr< Value >::value &&!System::detail::is_a< Value, std::pair >::value, void >::type PopulateSharedMembers (Object::shared_members_type &, const char *, Container &)
 
template<class Container , typename Value = typename Container::value_type>
std::enable_if< System::IsSmartPtr< Value >::value, void >::type PopulateSharedMembers (Object::shared_members_type &data, const char *name, Container &container)
 
template<class Container , typename Value = typename Container::value_type>
std::enable_if< System::detail::is_a< Value, std::pair >::value &&!System::IsSmartPtr< typename Value::first_type >::value &&!System::IsSmartPtr< typename Value::second_type >::value, void >::type PopulateSharedMembers (Object::shared_members_type &, const char *, Container &)
 
template<class Container , typename Value = typename Container::value_type>
std::enable_if< System::detail::is_a< Value, std::pair >::value &&System::IsSmartPtr< typename Value::first_type >::value &&!System::IsSmartPtr< typename Value::second_type >::value, void >::type PopulateSharedMembers (Object::shared_members_type &data, const char *name, Container &container)
 
template<class Container , typename Value = typename Container::value_type>
std::enable_if< System::detail::is_a< Value, std::pair >::value &&!System::IsSmartPtr< typename Value::first_type >::value &&System::IsSmartPtr< typename Value::second_type >::value, void >::type PopulateSharedMembers (Object::shared_members_type &data, const char *name, Container &container)
 
template<class Container , typename Value = typename Container::value_type>
std::enable_if< System::detail::is_a< Value, std::pair >::value &&System::IsSmartPtr< typename Value::first_type >::value &&System::IsSmartPtr< typename Value::second_type >::value, void >::type PopulateSharedMembers (Object::shared_members_type &data, const char *name, Container &container)
 

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)
 
- Static Protected Member Functions inherited from System::Object
template<class T , class Check = decltype(std::declval<T*>()->__FreePointers())>
static std::true_type __SupportsFreePointers (T *)
 Formal function for template magic to check if type T supports __FreePointers() method. More...
 
static std::false_type __SupportsFreePointers (...)
 Formal function for template magic to check if type T supports __FreePointers() method. More...
 
template<class T >
static std::enable_if< supports_free_pointers< T >::value, void >::type __DoFreePointers (T &t)
 
template<class T >
static std::enable_if<!supports_free_pointers< T >::value &&!std::is_fundamental< T >::value &&!std::is_enum< T >::value &&!std::is_const< T >::value, void >::type __DoFreePointers (const T &)
 
template<class T >
static std::enable_if<!supports_free_pointers< T >::value &&!std::is_fundamental< T >::value &&!std::is_enum< T >::value &&std::is_const< T >::value, void >::type __DoFreePointers (T &)
 
template<class T >
static std::enable_if< std::is_fundamental< T >::value||std::is_enum< T >::value, void >::type __DoFreePointers (T)
 

Additional Inherited Members

- Public Types inherited from System::Object
typedef SmartPtr< Objectptr
 Alias for smart pointer type. 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...
 
- Protected Types inherited from System::Object
template<class T >
using supports_free_pointers = decltype(__SupportsFreePointers(std::declval< T * >()))
 Checks if T type supports __FreePointers() method. 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()

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