The main class for pivot table import. More...
#include <xipivot.hxx>
Public Member Functions | |
| XclImpPivotTableManager (const XclImpRoot &rRoot) | |
| virtual | ~XclImpPivotTableManager () override |
| XclImpPivotCacheRef | GetPivotCache (sal_uInt16 nCacheIdx) |
| Returns the pivot cache with the specified 0-based index. More... | |
| void | ReadSxidstm (XclImpStream &rStrm) |
| Reads an SXIDSTM record containing a pivot cache stream identifier and the pivot cache. More... | |
| void | ReadSxvs (XclImpStream &rStrm) |
| Reads an SXVS record containing the source type of a pivot cache. More... | |
| void | ReadDconref (XclImpStream &rStrm) |
| Reads a DCONREF record containing the source range of a pivot cache. More... | |
| void | ReadDConName (XclImpStream &rStrm) |
| void | ReadSxview (XclImpStream &rStrm) |
| Reads an SXVIEW record describing a new pivot table. More... | |
| void | ReadSxvd (XclImpStream &rStrm) |
| Reads an SXVD record describing a new field. More... | |
| void | ReadSxvdex (XclImpStream &rStrm) |
| Reads an SXVDEX record describing extended options of a field. More... | |
| void | ReadSxivd (XclImpStream &rStrm) |
| Reads an SXIVD record containing the row field or column field order. More... | |
| void | ReadSxpi (XclImpStream &rStrm) |
| Reads an SXPI record containing page field data. More... | |
| void | ReadSxdi (XclImpStream &rStrm) |
| Reads an SXDI record containing data field data. More... | |
| void | ReadSxvi (XclImpStream &rStrm) |
| Reads an SXVI record describing a new item of the current field. More... | |
| void | ReadSxex (XclImpStream &rStrm) |
| Reads an SXEX record containing additional settings for a pivot table. More... | |
| void | ReadSxViewEx9 (XclImpStream &rStrm) |
| Reads an SXVIEWEX9 record that specifies the pivot tables autoformat. More... | |
| void | ReadSxAddl (XclImpStream &rStrm) |
| Reads an SXADDL record that specifies additional info for pivot table. More... | |
| void | ReadPivotCaches (const XclImpStream &rStrm) |
| Reads all used pivot caches and creates additional sheets for external data sources. More... | |
| void | ConvertPivotTables () |
| Inserts all pivot tables into the Calc document. More... | |
| void | MaybeRefreshPivotTables () |
Private Attributes | |
| std::vector< XclImpPivotCacheRef > | maPCaches |
| std::vector< XclImpPivotTableRef > | maPTables |
| List of all pivot caches. More... | |
Additional Inherited Members | |
 Protected Member Functions inherited from XclImpRoot | |
| XclImpRoot (XclImpRootData &rImpRootData) | |
| const XclImpRoot & | GetRoot () const |
| Returns this root instance - for code readability in derived classes. More... | |
| XclImpRoot & | GetRoot () |
| void | SetCodePage (sal_uInt16 nCodePage) |
| Sets a code page read from a CODEPAGE record for byte string import. More... | |
| void | InitializeTable (SCTAB nScTab) |
| Is called when import filter starts importing a single sheet (all BIFF versions). More... | |
| void | FinalizeTable () |
| Is called when import filter stops importing a single sheet (all BIFF versions). More... | |
| XclImpAddressConverter & | GetAddressConverter () const |
| Returns the address converter. More... | |
| XclImpFormulaCompiler & | GetFormulaCompiler () const |
| Returns the formula converter. More... | |
| ExcelToSc & | GetOldFmlaConverter () const |
| Returns the old formula converter. More... | |
| XclImpSst & | GetSst () const |
| Returns the shared string table. More... | |
| XclImpPalette & | GetPalette () const |
| Returns the color buffer. More... | |
| XclImpFontBuffer & | GetFontBuffer () const |
| Returns the font buffer. More... | |
| XclImpNumFmtBuffer & | GetNumFmtBuffer () const |
| Returns the number format buffer. More... | |
| XclImpXFBuffer & | GetXFBuffer () const |
| Returns the cell formatting attributes buffer. More... | |
| XclImpXFRangeBuffer & | GetXFRangeBuffer () const |
| Returns the buffer of XF index ranges for a sheet. More... | |
| ScRangeListTabs & | GetPrintAreaBuffer () const |
| Returns the buffer that contains all print areas in the document. More... | |
| ScRangeListTabs & | GetTitleAreaBuffer () const |
| Returns the buffer that contains all print titles in the document. More... | |
| XclImpTabInfo & | GetTabInfo () const |
| Returns the buffer that contains the sheet creation order. More... | |
| XclImpNameManager & | GetNameManager () const |
| Returns the buffer that contains internal defined names. More... | |
| XclImpLinkManager & | GetLinkManager () const |
| Returns the link manager. More... | |
| XclImpObjectManager & | GetObjectManager () const |
| Returns the drawing object manager. More... | |
| XclImpSheetDrawing & | GetCurrSheetDrawing () const |
| Returns the drawing container of the current sheet. More... | |
| XclImpCondFormatManager & | GetCondFormatManager () const |
| Returns the conditional formatting manager. More... | |
| XclImpValidationManager & | GetValidationManager () const |
| XclImpAutoFilterBuffer & | GetFilterManager () const |
| Returns the filter manager. More... | |
| XclImpWebQueryBuffer & | GetWebQueryBuffer () const |
| Returns the web query buffer. More... | |
| XclImpPivotTableManager & | GetPivotTableManager () const |
| Returns the pivot table manager. More... | |
| XclImpSheetProtectBuffer & | GetSheetProtectBuffer () const |
| Returns the sheet protection options of the current sheet. More... | |
| XclImpDocProtectBuffer & | GetDocProtectBuffer () const |
| Returns the document protection options. More... | |
| XclImpPageSettings & | GetPageSettings () const |
| Returns the page settings of the current sheet. More... | |
| XclImpDocViewSettings & | GetDocViewSettings () const |
| Returns the view settings of the entire document. More... | |
| XclImpTabViewSettings & | GetTabViewSettings () const |
| Returns the view settings of the current sheet. More... | |
| bool | HasBasic () const |
| Returns true, if the document contains a VB project. More... | |
| void | SetHasBasic () |
| Called to indicate that the document contains a VB project. More... | |
| void | ReadCodeName (XclImpStream &rStrm, bool bGlobals) |
| Reads the CODENAME record and inserts the codename into the document. More... | |
| ScDocumentImport & | GetDocImport () |
| Protected Member Functions inherited from XclRoot | |
| XclRoot (XclRootData &rRootData) | |
| XclRoot (const XclRoot &rRoot) | |
| virtual | ~XclRoot () |
| XclRoot & | operator= (const XclRoot &rRoot) |
| RootData & | GetOldRoot () const |
| Returns old RootData struct. More... | |
| XclBiff | GetBiff () const |
| Returns the current BIFF version of the importer/exporter. More... | |
| XclOutput | GetOutput () const |
| Returns the current output format of the importer/exporter. More... | |
| bool | IsImport () const |
| Returns true, if currently a document is imported. More... | |
| rtl_TextEncoding | GetTextEncoding () const |
| Returns the text encoding to import/export byte strings. More... | |
| LanguageType | GetSysLanguage () const |
| Returns the system language, i.e. More... | |
| LanguageType | GetDocLanguage () const |
| Returns the document language. More... | |
| LanguageType | GetUILanguage () const |
| Returns the UI language. More... | |
| sal_Int16 | GetDefApiScript () const |
| Returns the default script type, e.g. More... | |
| tools::Long | GetCharWidth () const |
| Returns the width of the '0' character (default font) for the current printer (twips). More... | |
| tools::Long | GetSpaceWidth () const |
| bool | IsInGlobals () const |
| Returns the current Calc sheet index. More... | |
| SCTAB | GetCurrScTab () const |
| Returns the current Calc sheet index. More... | |
| sal_Int32 | GetHmmFromPixelX (double fPixelX) const |
| Calculates the width of the passed number of pixels in 1/100 mm. More... | |
| sal_Int32 | GetHmmFromPixelY (double fPixelY) const |
| Calculates the height of the passed number of pixels in 1/100 mm. More... | |
| SfxMedium & | GetMedium () const |
| Returns the medium to import from. More... | |
| const OUString & | GetDocUrl () const |
| Returns the document URL of the imported/exported file. More... | |
| const OUString & | GetBasePath () const |
| Returns the base path of the imported/exported file. More... | |
| const OUString & | GetUserName () const |
| Returns the current user name. More... | |
| css::uno::Sequence< css::beans::NamedValue > | RequestEncryptionData (::comphelper::IDocPasswordVerifier &rVerifier) const |
| Requests and verifies a password from the medium or the user. More... | |
| const tools::SvRef< SotStorage > & | GetRootStorage () const |
| Returns the OLE2 root storage of the imported/exported file. More... | |
| bool | HasVbaStorage () const |
| Returns true, if the document contains a VBA storage. More... | |
| tools::SvRef< SotStorage > | OpenStorage (tools::SvRef< SotStorage > const &xStrg, const OUString &rStrgName) const |
| Tries to open a storage as child of the specified storage for reading or writing. More... | |
| tools::SvRef< SotStorage > | OpenStorage (const OUString &rStrgName) const |
| Tries to open a storage as child of the root storage for reading or writing. More... | |
| tools::SvRef< SotStorageStream > | OpenStream (tools::SvRef< SotStorage > const &xStrg, const OUString &rStrmName) const |
| Tries to open a new stream in the specified storage for reading or writing. More... | |
| tools::SvRef< SotStorageStream > | OpenStream (const OUString &rStrmName) const |
| Tries to open a new stream in the root storage for reading or writing. More... | |
| ScDocument & | GetDoc () const |
| Returns reference to the destination document (import) or source document (export). More... | |
| SfxObjectShell * | GetDocShell () const |
| Returns the object shell of the Calc document. More... | |
| ScModelObj * | GetDocModelObj () const |
| Returns the object model of the Calc document. More... | |
| OutputDevice * | GetPrinter () const |
| Returns pointer to the printer of the Calc document. More... | |
| ScStyleSheetPool & | GetStyleSheetPool () const |
| Returns the style sheet pool of the Calc document. More... | |
| ScRangeName & | GetNamedRanges () const |
| Returns the defined names container of the Calc document. More... | |
| SdrPage * | GetSdrPage (SCTAB nScTab) const |
| Returns the drawing layer page of the passed sheet, if present. More... | |
| SvNumberFormatter & | GetFormatter () const |
| Returns the number formatter of the Calc document. More... | |
| DateTime | GetNullDate () const |
| Returns the null date of the current number formatter. More... | |
| sal_uInt16 | GetBaseYear () const |
| Returns the base year depending on the current null date (1900 or 1904). More... | |
| double | GetDoubleFromDateTime (const DateTime &rDateTime) const |
| Converts a date/time value to a floating-point value. More... | |
| DateTime | GetDateTimeFromDouble (double fValue) const |
| Converts a floating-point value to a date/time value. More... | |
| ScEditEngineDefaulter & | GetEditEngine () const |
| Returns the edit engine for import/export of rich strings etc. More... | |
| ScHeaderEditEngine & | GetHFEditEngine () const |
| Returns the edit engine for import/export of headers/footers. More... | |
| EditEngine & | GetDrawEditEngine () const |
| Returns the edit engine for import/export of drawing text boxes. More... | |
| XclFontPropSetHelper & | GetFontPropSetHelper () const |
| Returns the property set helper for fonts. More... | |
| XclChPropSetHelper & | GetChartPropSetHelper () const |
| Returns the property set helper for the chart filters. More... | |
| ScExtDocOptions & | GetExtDocOptions () const |
| Returns the extended document options. More... | |
| XclTracer & | GetTracer () const |
| Returns the filter tracer. More... | |
| const ScAddress & | GetScMaxPos () const |
| Returns the highest possible cell address in a Calc document. More... | |
| const ScAddress & | GetXclMaxPos () const |
| Returns the highest possible cell address in an Excel document (using current BIFF version). More... | |
| const ScAddress & | GetMaxPos () const |
| Returns the highest possible cell address valid in Calc and Excel (using current BIFF version). More... | |
| void | SetDocLanguage (LanguageType eLang) |
| Sets the document language. More... | |
| void | SetUILanguage (LanguageType eLang) |
| Sets the UI language, i.e. More... | |
| void | SetTextEncoding (rtl_TextEncoding eTextEnc) |
| Sets the text encoding to import/export byte strings. More... | |
| void | SetCharWidth (const XclFontData &rFontData) |
| Sets the width of the '0' - '9' digit character as well as the ' ' space char (using the default font) for the current printer (twips). More... | |
| void | SetCurrScTab (SCTAB nScTab) |
| Sets the current Calc sheet index. More... | |
| void | IncCurrScTab () |
| Increases the current Calc sheet index by 1. More... | |
| Static Protected Member Functions inherited from XclImpRoot | |
| static OUString | GetScAddInName (const OUString &rXclName) |
| Returns the Calc add-in function name for an Excel function name. More... | |
| Static Protected Member Functions inherited from XclRoot | |
| static OUString | GetDefaultPassword () |
| Returns the default password used for stream encryption. More... | |
Detailed Description
The main class for pivot table import.
This class contains functions to read all records related to pivot tables and pivot caches.
Definition at line 371 of file xipivot.hxx.
Constructor & Destructor Documentation
◆ XclImpPivotTableManager()
|
explicit |
Definition at line 1611 of file xipivot.cxx.
◆ ~XclImpPivotTableManager()
|
overridevirtual |
Definition at line 1616 of file xipivot.cxx.
Member Function Documentation
◆ ConvertPivotTables()
| void XclImpPivotTableManager::ConvertPivotTables | ( | ) |
Inserts all pivot tables into the Calc document.
Definition at line 1724 of file xipivot.cxx.
References maPTables.
Referenced by ImportExcel8::Read().
◆ GetPivotCache()
| XclImpPivotCacheRef XclImpPivotTableManager::GetPivotCache | ( | sal_uInt16 | nCacheIdx | ) |
Returns the pivot cache with the specified 0-based index.
Definition at line 1622 of file xipivot.cxx.
References maPCaches.
Referenced by XclImpPivotTable::ReadSxview().
◆ MaybeRefreshPivotTables()
| void XclImpPivotTableManager::MaybeRefreshPivotTables | ( | ) |
Definition at line 1730 of file xipivot.cxx.
References maPTables.
Referenced by ImportExcel8::Read().
◆ ReadDConName()
| void XclImpPivotTableManager::ReadDConName | ( | XclImpStream & | rStrm | ) |
Definition at line 1649 of file xipivot.cxx.
References maPCaches, and rStrm.
Referenced by ImportExcel8::Read().
◆ ReadDconref()
| void XclImpPivotTableManager::ReadDconref | ( | XclImpStream & | rStrm | ) |
Reads a DCONREF record containing the source range of a pivot cache.
Definition at line 1643 of file xipivot.cxx.
References maPCaches, and rStrm.
Referenced by ImportExcel8::Read().
◆ ReadPivotCaches()
| void XclImpPivotTableManager::ReadPivotCaches | ( | const XclImpStream & | rStrm | ) |
Reads all used pivot caches and creates additional sheets for external data sources.
Definition at line 1718 of file xipivot.cxx.
References maPCaches, and rStrm.
Referenced by ImportExcel8::Read().
◆ ReadSxAddl()
| void XclImpPivotTableManager::ReadSxAddl | ( | XclImpStream & | rStrm | ) |
Reads an SXADDL record that specifies additional info for pivot table.
Definition at line 1712 of file xipivot.cxx.
References maPTables, and rStrm.
Referenced by ImportExcel8::Read().
◆ ReadSxdi()
| void XclImpPivotTableManager::ReadSxdi | ( | XclImpStream & | rStrm | ) |
Reads an SXDI record containing data field data.
Definition at line 1688 of file xipivot.cxx.
References maPTables, and rStrm.
Referenced by ImportExcel8::Read().
◆ ReadSxex()
| void XclImpPivotTableManager::ReadSxex | ( | XclImpStream & | rStrm | ) |
Reads an SXEX record containing additional settings for a pivot table.
Definition at line 1700 of file xipivot.cxx.
References maPTables, and rStrm.
Referenced by ImportExcel8::Read().
◆ ReadSxidstm()
| void XclImpPivotTableManager::ReadSxidstm | ( | XclImpStream & | rStrm | ) |
Reads an SXIDSTM record containing a pivot cache stream identifier and the pivot cache.
Definition at line 1630 of file xipivot.cxx.
References XclImpRoot::GetRoot(), maPCaches, and rStrm.
Referenced by ImportExcel8::Read().
◆ ReadSxivd()
| void XclImpPivotTableManager::ReadSxivd | ( | XclImpStream & | rStrm | ) |
Reads an SXIVD record containing the row field or column field order.
Definition at line 1676 of file xipivot.cxx.
References maPTables, and rStrm.
Referenced by ImportExcel8::Read().
◆ ReadSxpi()
| void XclImpPivotTableManager::ReadSxpi | ( | XclImpStream & | rStrm | ) |
Reads an SXPI record containing page field data.
Definition at line 1682 of file xipivot.cxx.
References maPTables, and rStrm.
Referenced by ImportExcel8::Read().
◆ ReadSxvd()
| void XclImpPivotTableManager::ReadSxvd | ( | XclImpStream & | rStrm | ) |
Reads an SXVD record describing a new field.
Definition at line 1664 of file xipivot.cxx.
References maPTables, and rStrm.
Referenced by ImportExcel8::Read().
◆ ReadSxvdex()
| void XclImpPivotTableManager::ReadSxvdex | ( | XclImpStream & | rStrm | ) |
Reads an SXVDEX record describing extended options of a field.
Definition at line 1670 of file xipivot.cxx.
References maPTables, and rStrm.
Referenced by ImportExcel8::Read().
◆ ReadSxvi()
| void XclImpPivotTableManager::ReadSxvi | ( | XclImpStream & | rStrm | ) |
Reads an SXVI record describing a new item of the current field.
Definition at line 1694 of file xipivot.cxx.
References maPTables, and rStrm.
Referenced by ImportExcel8::Read().
◆ ReadSxview()
| void XclImpPivotTableManager::ReadSxview | ( | XclImpStream & | rStrm | ) |
Reads an SXVIEW record describing a new pivot table.
Definition at line 1657 of file xipivot.cxx.
References XclImpRoot::GetRoot(), maPTables, and rStrm.
Referenced by ImportExcel8::Read().
◆ ReadSxViewEx9()
| void XclImpPivotTableManager::ReadSxViewEx9 | ( | XclImpStream & | rStrm | ) |
Reads an SXVIEWEX9 record that specifies the pivot tables autoformat.
Definition at line 1706 of file xipivot.cxx.
References maPTables, and rStrm.
Referenced by ImportExcel8::Read().
◆ ReadSxvs()
| void XclImpPivotTableManager::ReadSxvs | ( | XclImpStream & | rStrm | ) |
Reads an SXVS record containing the source type of a pivot cache.
Definition at line 1637 of file xipivot.cxx.
References maPCaches, and rStrm.
Referenced by ImportExcel8::Read().
Member Data Documentation
◆ maPCaches
|
private |
Definition at line 423 of file xipivot.hxx.
Referenced by GetPivotCache(), ReadDConName(), ReadDconref(), ReadPivotCaches(), ReadSxidstm(), and ReadSxvs().
◆ maPTables
|
private |
List of all pivot caches.
Definition at line 424 of file xipivot.hxx.
Referenced by ConvertPivotTables(), MaybeRefreshPivotTables(), ReadSxAddl(), ReadSxdi(), ReadSxex(), ReadSxivd(), ReadSxpi(), ReadSxvd(), ReadSxvdex(), ReadSxvi(), ReadSxview(), and ReadSxViewEx9().
The documentation for this class was generated from the following files:
