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