Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Introducedin
7.1.0.1855

...

7.1.0.1855
Description

Excerpt

The SharePointIntegration class contains the extension methods that allow users to bind SharePoint data sources to Excel spreadsheets as well as open and save files in SharePoint lists and document libraries.

Signature
C#
C#
public static class SharePointIntegration
{signature}
{remarks}
The SharePointIntegration class is to be used on a SharePoint server to use the ExcelTemplate, ExcelApplication, Worksheet, and Area objects with SharePoint.  SharePointIntegration belongs to the 
Remarks

The SharePointIntegration class is to be used on a SharePoint server to use the ExcelTemplate, ExcelApplication, Worksheet, and Area objects with SharePoint. SharePointIntegration belongs to the SoftArtisans.OfficeWriter.ExcelWriter.SharePointIntegration

namespace,

which

has

the

Microsoft.SharePoint

class

as

a

dependency.

Additionally,

the

SharePointIntegration

class

belongs

in

a

separate

DLL,

SoftArtisans.OfficeWriter.ExcelWriter.SharePoinIntegration.dll,

which

must

be

added

to

the

bin

directory

of

your

project.

SharePointIntegration

is

a

static

class

which

cannot

directly

be

instantiated,

but

rather

contains

extension

methods

for

the

[

ExcelApplication

]

,

[

ExcelTemplate

]

,

[

Worksheet

]

,

and

[

Area

]

objects.

Use

SharePointIntegration

extensions

just

as

you

would

the

other

methods

of

each

object,

remembering

to

add

references

to

the

SoftArtisans.OfficeWriter.ExcelWriter

and

Microsoft.SharePoint

namespaces.

{remarks} {methods} || Name || Description || | [

Methods

Name

Description

BindData(ExcelTemplate,

...

...

...

...

Excerpt Include
SharePointIntegration.BindData(ExcelTemplate,

...

Microsoft.SharePoint.SPList,

...

String,

...

DataBindingProperties)

...

SharePointIntegration.BindData(ExcelTemplate,

...

Microsoft.SharePoint.SPList,

...

String,

...

DataBindingProperties)

...

nopanel

...

...

...

...

...

...

Excerpt Include
SharePointIntegration.BindData(ExcelTemplate,

...

Microsoft.SharePoint.SPView,

...

Microsoft.SharePoint.SPList,

...

String,

...

DataBindingProperties)

...

SharePointIntegration.BindData(ExcelTemplate,

...

Microsoft.SharePoint.SPView,

...

Microsoft.SharePoint.SPList,

...

String,

...

DataBindingProperties)

...

nopanel

...

...

...

...

...

Excerpt Include
SharePointIntegration.BindRowData(ExcelTemplate,

...

Microsoft.SharePoint.SPList,

...

String,

...

DataBindingProperties)

...

SharePointIntegration.BindRowData(ExcelTemplate,

...

Microsoft.SharePoint.SPList,

...

String,

...

DataBindingProperties)

...

nopanel

...

...

...

...

...

...

Excerpt Include
SharePointIntegration.BindRowData(ExcelTemplate,

...

Microsoft.SharePoint.SPView,

...

Microsoft.SharePoint.SPList,

...

String,

...

DataBindingProperties)

...

SharePointIntegration.BindRowData(ExcelTemplate,

...

Microsoft.SharePoint.SPView,

...

Microsoft.SharePoint.SPList,

...

String,

...

DataBindingProperties)

...

nopanel

...

...

...

Excerpt Include
SharePointIntegration.ImportData(Area,

...

Microsoft.SharePoint.SPList)

...

SharePointIntegration.ImportData(Area,

...

Microsoft.SharePoint.SPList)

...

nopanel

...

...

...

...

Excerpt Include
SharePointIntegration.ImportData(Area,

...

Microsoft.SharePoint.SPList,

...

DataImportProperties)

...

SharePointIntegration.ImportData(Area,

...

Microsoft.SharePoint.SPList,

...

DataImportProperties)

...

nopanel

...

...

...

...

...

Excerpt Include
SharePointIntegration.ImportData(Area,

...

Microsoft.SharePoint.SPView,

...

Microsoft.SharePoint.SPList,

...

DataImportProperties)

...

SharePointIntegration.ImportData(Area,

...

Microsoft.SharePoint.SPView,

...

Microsoft.SharePoint.SPList,

...

DataImportProperties)

...

nopanel

...

...

...

...

Excerpt Include
SharePointIntegration.ImportData(Area,

...

Microsoft.SharePoint.SPView,

...

Microsoft.SharePoint.SPList)

...

SharePointIntegration.ImportData(Area,

...

Microsoft.SharePoint.SPView,

...

Microsoft.SharePoint.SPList)

...

nopanel

...

...

...

...

Excerpt Include
SharePointIntegration.ImportData(Worksheet,

...

Cell,

...

Microsoft.SharePoint.SPList)

...

SharePointIntegration.ImportData(Worksheet,

...

Cell,

...

Microsoft.SharePoint.SPList)

...

nopanel

...

...

...

...

...

Excerpt Include
SharePointIntegration.ImportData(Worksheet,

...

Cell,

...

Microsoft.SharePoint.SPList,

...

DataImportProperties)

...

SharePointIntegration.ImportData(Worksheet,

...

Cell,

...

Microsoft.SharePoint.SPList,

...

DataImportProperties)

...

nopanel

...

...

...

...

...

...

Excerpt Include
SharePointIntegration.ImportData(Worksheet,

...

Cell,

...

Microsoft.SharePoint.SPView,

...

Microsoft.SharePoint.SPList,

...

DataImportProperties)

...

SharePointIntegration.ImportData(Worksheet,

...

Cell,

...

Microsoft.SharePoint.SPView,

...

Microsoft.SharePoint.SPList,

...

DataImportProperties)

...

nopanel

...

...

...

...

...

Excerpt Include
SharePointIntegration.ImportData(Worksheet,

...

Cell,

...

Microsoft.SharePoint.SPView,

...

Microsoft.SharePoint.SPList)

...

SharePointIntegration.ImportData(Worksheet,

...

Cell,

...

Microsoft.SharePoint.SPView,

...

Microsoft.SharePoint.SPList)

...

nopanel

...

...

...

...

Excerpt Include
SharePointIntegration.Open(ExcelApplication,

...

Microsoft.SharePoint.SPDocumentLibrary,

...

String)

...

SharePointIntegration.Open(ExcelApplication,

...

Microsoft.SharePoint.SPDocumentLibrary,

...

String)

...

nopanel

...

...

...

...

Excerpt Include
SharePointIntegration.Open(ExcelApplication,

...

Microsoft.SharePoint.SPListItem,

...

String)

...

SharePointIntegration.Open(ExcelApplication,

...

Microsoft.SharePoint.SPListItem,

...

String)

...

nopanel

...

...

...

...

Excerpt Include
SharePointIntegration.Open(ExcelTemplate,

...

Microsoft.SharePoint.SPDocumentLibrary,

...

String)

...

SharePointIntegration.Open(ExcelTemplate,

...

Microsoft.SharePoint.SPDocumentLibrary,

...

String)

...

nopanel

...

...

...

...

Excerpt Include
SharePointIntegration.Open(ExcelTemplate,

...

Microsoft.SharePoint.SPListItem,

...

String)

...

SharePointIntegration.Open(ExcelTemplate,

...

Microsoft.SharePoint.SPListItem,

...

String)

...

nopanel

...

...

...

...

...

Excerpt Include
SharePointIntegration.Save(ExcelApplication,

...

Workbook,

...

Microsoft.SharePoint.SPListItem,

...

String)

...

SharePointIntegration.Save(ExcelApplication,

...

Workbook,

...

Microsoft.SharePoint.SPListItem,

...

String)

...

nopanel

...

...

...

...

...

...

Excerpt Include
SharePointIntegration.Save(ExcelApplication,

...

Workbook,

...

Microsoft.SharePoint.SPDocumentLibrary,

...

String,

...

Boolean)

...

SharePointIntegration.Save(ExcelApplication,

...

Workbook,

...

Microsoft.SharePoint.SPDocumentLibrary,

...

String,

...

Boolean)

...

nopanel

...

...

...

...

Excerpt Include
SharePointIntegration.Save(ExcelTemplate,

...

Microsoft.SharePoint.SPListItem,

...

String)

...

SharePointIntegration.Save(ExcelTemplate,

...

Microsoft.SharePoint.SPListItem,

...

String)

...

nopanel

...

...

...

...

...

Excerpt Include
SharePointIntegration.Save(ExcelTemplate,

...

Microsoft.SharePoint.SPDocumentLibrary,

...

String,

...

Boolean)

...

SharePointIntegration.Save(ExcelTemplate,

...

Microsoft.SharePoint.SPDocumentLibrary,

...

String,

...

Boolean)

...

nopanel

...

true

...