26namespace oox {
class AttributeList; }
27namespace oox {
class SequenceInputStream; }
An external data connection (database, web query, etc.).
void importTables()
Imports web query table settings from the tables element.
sal_Int32 getConnectionId() const
Returns the unique connection identifier.
void importWebPr(const AttributeList &rAttribs)
Imports web query settings from the webPr element.
void importWebPrTable(SequenceInputStream &rStrm, sal_Int32 nRecId)
Imports a web query table identifier from the PCITEM_MISSING, PCITEM_STRING, or PCITEM_INDEX record.
void importTable(const AttributeList &rAttribs, sal_Int32 nElement)
Imports a web query table identifier from the m, s, or x element.
const ConnectionModel & getModel() const
Returns read-only access to the connection model data.
sal_Int32 getConnectionType() const
Returns the source data type of the connection.
Connection(const WorkbookHelper &rHelper)
void importConnection(const AttributeList &rAttribs)
Imports connection settings from the connection element.
void importWebPrTables(SequenceInputStream &rStrm)
Imports web query table settings from the WEBPRTABLES record.
ConnectionRef getConnection(sal_Int32 nConnId) const
Returns a data connection by its unique identifier.
ConnectionsBuffer(const WorkbookHelper &rHelper)
RefVector< Connection > ConnectionVector
void finalizeImport()
Maps all connections by their identifier.
RefMap< sal_Int32, Connection > ConnectionMap
Connection & createConnection()
Creates a new empty connection.
void insertConnectionToMap(const ConnectionRef &rxConnection)
Inserts the passed connection into the map according to its identifier.
ConnectionMap maConnectionsById
ConnectionVector maConnections
Helper class to provide access to global workbook data.
const sal_Int32 BIFF12_CONNECTION_TEXT
const sal_Int32 BIFF12_CONNECTION_DSP
const sal_Int32 BIFF12_CONNECTION_ADO
const sal_Int32 BIFF12_CONNECTION_OLEDB
const sal_Int32 BIFF12_CONNECTION_HTML
const sal_Int32 BIFF12_CONNECTION_FILE
const sal_Int32 BIFF12_CONNECTION_ODBC
const sal_Int32 BIFF12_CONNECTION_UNKNOWN
const sal_Int32 BIFF12_CONNECTION_DAO
std::shared_ptr< Connection > ConnectionRef
Common properties of an external data connection.
sal_Int32 mnId
Single sign-on identifier.
sal_Int32 mnInterval
Credentials method.
sal_Int32 mnReconnectMethod
Data source type.
OUString maName
Special settings for web queries.
::std::unique_ptr< WebPrModel > WebPrModelPtr
OUString maSsoId
URL of a source connection file.
bool mbSavePassword
True = save cached data with connection.
bool mbKeepAlive
Refresh interval in minutes.
bool mbSaveData
True = refresh connection on import.
bool mbBackground
True = use maSourceConnFile, ignore mnReconnectMethod.
bool mbNew
True = keep connection open after import.
ConnectionModel()
True = save password in connection string.
bool mbRefreshOnLoad
True = background refresh enabled.
OUString maDescription
Unique name of this connection.
WebPrModel & createWebPr()
sal_Int32 mnCredentials
Reconnection method.
OUString maSourceFile
User description of this connection.
bool mbDeleted
True = new connection, never updated.
sal_Int32 mnType
Unique connection identifier.
OUString maSourceConnFile
URL of a source data file.
bool mbOnlyUseConnFile
True = connection has been deleted.
Special properties for data connections representing web queries.
WebPrModel()
True = HTML tables, false = entire document.
OUString maPostMethod
Source URL to refresh the data.
OUString maEditPage
POST method to query data.
bool mbXl2000Refreshed
True = read date values as text, false = parse dates.
bool mbHtmlTables
True = refreshed with Excel 2000 or newer.
::std::vector< css::uno::Any > TablesVector
bool mbTextDates
True = web query created with Excel 97.
bool mbXl97Created
True = use column widths of first row for entire.
bool mbParsePre
True = import XML source data referred by HTML table.
bool mbConsecutive
True = parse preformatted sections (.
OUString maUrl
Names or indexes of the web query tables.
bool mbSourceData
True = XML query, false = HTML query.
bool mbFirstRow
True = join consecutive delimiters.
sal_Int32 mnHtmlFormat
Web page showing query data (for XML queries).
bool mbXml
Plain text, rich text, or HTML.