Export an Excel table to a SharePoint 2013 list

You can export data from an Excel table to a SharePoint list. When you export the list, Excel will create a new SharePoint list on the site. You can then work with the data on the site, just like you would for any other SharePoint list.

Create Excel table.

Export table to SharePoint list.

In Address field type SharePoint url.
In Name field type name of new list.

List in SharePoint.

Hide the Timeline in task list - SharePoint 2013

When adding the Task List app in SP2013 it automatically displays a timeline.
The functionality of the Task List allows for the display of the tasks only.

In Web Part

Edit page.

Edit Web Part.

“Show timeline”, uncheck, OK.

In List

 

Modify View

On Style, uncheck “Show timeline abobe the view”, OK.

Instal and Configure Office Web Apps Serverfor SharePoint 2013 (http and https)

Create user account

On Active Directory create user account for installation OWA Server. E.g. sp_owa.

On OWA Server add user to Local Administartors group.

Install prerequisites for Office Web App 

On OWA Server open the Windows PowerShell prompt as an administrator and run this command to install the required roles and services (for Windows Server 2012):

Add-WindowsFeature Web-Server,Web-Mgmt-Tools,Web-Mgmt-Console,Web-WebServer,Web-Common-Http,Web-Default-Doc,Web-Static-Content,Web-Performance,Web-Stat-Compression,Web-Dyn-Compression,Web-Security,Web-Filtering,Web-Windows-Auth,Web-App-Dev,Web-Net-Ext45,Web-Asp-Net45,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Includes,InkandHandwritingServices,NET-Framework-Features,NET-Framework-Core -Source D:\Sources\sxs

NOTE: “D:\Sources\sxs”- source of Windows Server instalation, necessary in some cases.

After successfully executed command restart server to finish instalation process.

Download Microsoft Office Web App instalation from Microsoft Download Center

Run setup.exe

Create the Office Web Apps Server farm 

Open the Windows PowerShell prompt as an administrator and run this command:

For HTTP:  New-OfficeWebAppsFarm -InternalURL "http://sp2013owa" -AllowHttp –EditingEnabled

For HTTPS: New-OfficeWebAppsFarm -InternalUrl "https://sp2013owa" -ExternalUrl "https://sp2013owa" -CertificateName "officewebapp" –EditingEnabled

For HTTPS before create SAN Certificate

–InternalURL is domain name of the server that runs Office Web Apps Server.

–ExternalURL is the FQDN that can be accessed on the Internet.

–CertificateName is the friendly name of the certificate.

–EditingEnabled is optional and enables editing in Office Web Apps when used with SharePoint 2013. This parameter isn't used by Lync Server 2013 or Exchange Server 2013 because those hosts don't support editing.

Confirm with Y.

Create DNS record for URL in PowerShell command (sp2013owa).

On APP Server in Internet Explorer open next URL:

 http://sp2013owa/hosting/discovery/  or  https://sp2013owa/hosting/discovery/

You should see the following window

Create the binding between SharePoint 2013 and Office Web Apps Server 

Log in on APP Server as SharePoint Administrator

Open the SharePoint Management Shell as an administrator and run this command:

For HTTP: New-SPWOPIBinding -ServerName sp2013owa –AllowHTTP

For HTTPS: New-SPWOPIBinding -ServerName sp2013owa
 

View the WOPI zone of SharePoint 2013: Get-SPWOPIZone

Change the WOPI zone if necessary.

For HTTP: Set-SPWOPIZone -zone "internal-http"

For HTTPS: Set-SPWOPIZone -zone "external-https"

NOTE: For HTTPS, open IIS manager on APP Server, choose previously created certificate for Web Applications that will use Office Web Apps Server.

Create and Import SAN Certificate Office Web Apps (OWA)

Log in on Domain Controller. Open MMC, add certificate template. Duplicate Web Server template.

On Request Handing tab, check “Allow private key to be exported”

On the security tab, ensure the account that wants to request the cert has the right to enroll.
And “Authenticades Users” group has the right to enroll.

 

Open Certification Authority.

Select Certificate Template to issue.

On APP Server open MMC, add Snap-in Certificates.

Request New Certificate.

Check previously created Certificate Template (Test1), click More information….

Subject name> Type> choose Common name. In the Value field type name of APP Server, Add.

Alternative name> Type choose DNS. In the Value field type name of OWA Server, Add.
Alternative name> Type choose DNS,  name of Web Application on SharePoint e.g. portal
Last row repeat for all Web Application.

ON General tab type Friendly name.

Note: Later in PowerShell command New-OfficeWebAppsFarm in Certificate name type friendly name.

On Private key tab check “Make private key exportable”. Click OK, Enroll.

Export Certificate to OWA Server

Type new password.

Install Certificate.

When execute PowerShell command New-OfficeWebAppsFarm, certificate automatically import in Owa Web Application on IIS.

On APP Server manuel choose certificate for Web Application on IIS.