Can’t Import SpreadSheet to SharePoint List: The specified file is not a valid spreadsheet or contains no data to import

In this blog, I will show How to solve the below import Excel sheet issue in SharePoint

The specified file is not a valid spreadsheet or contains no data to import


Scenario

I have an Excel file as shown below,

The specified file is not a valid spreadsheet or contains no data to import

I have tried to import this Excel file to SharePoint using Import spreadsheet feature

The specified file is not a valid spreadsheet or contains no data to import

But unfortunately, I got this error

The specified file is not a valid spreadsheet or contains no data to import

The specified file is not a valid spreadsheet or contains no data to import


Cause

Continue reading “Can’t Import SpreadSheet to SharePoint List: The specified file is not a valid spreadsheet or contains no data to import”

Advertisements

Show SharePoint Document Library files with folders and subfolders in SSRS

In this article, I will explain

How to show a SharePoint Document Library files with folders and subfolders in SSRS recursively

 

Show Recursive Document Library files with folders and subfolders in SSRS


Scenario

I have a SharePoint Document Library with multiple folders and subfolders as shown below:

Show Recursive SharePoint Document Library files with folders and subfolders in SSRS.gif

I have tried to retrieve all files, folders, and subfolders from this Document Library in Reporting Service (SSRS) report, but unfortunately, it doesn’t recursively read all the subfolders and files, it only read the root folder and files as shown below:

Document Library

Show Recursive Document Library files with folders and subfolders in Reporting Service

SSRS report

Show Recursive Document Library files with folders and subfolders in SSRS Continue reading “Show SharePoint Document Library files with folders and subfolders in SSRS”

SharePoint 2016: Show a List From Parent Site In Sub Site

In this article, I will Show

How to display a SharePoint list from Parent site in Sub Site?

Scenario

In SharePoint 2016, I have a list in the parent site, I would like to show this list inside a page in the subsite.

So that when adding a new item to this list from the subsite, it should also be listed in the same original list in the parent site and vice versa.

Note: You can use the same steps to display a SharePoint list from subsite in parent site.

Continue reading “SharePoint 2016: Show a List From Parent Site In Sub Site”

SharePoint 2013 setup unable to proceed : This Product Requires Microsoft .Net Framework 4.5

In this article, I will be fixing this error

SharePoint 2013 setup unable to proceed due to the following errors: This Product Requires Microsoft .Net Framework 4.5

This Product Requires Microsoft .Net Framework 4.5 Continue reading “SharePoint 2013 setup unable to proceed : This Product Requires Microsoft .Net Framework 4.5”

SharePoint Lookup Field Multiple Values Via C#

In this article, we will explain How to programmatically

  • Set a SharePoint Lookup Field (Single Value) via SSOM C#.
  • Set a SharePoint Lookup Field (Multiple Values) via SSOM C#.
  • Get a SharePoint SharePoint Lookup Field (Single Value) via SSOM C#.
  • Get a SharePoint SharePoint Lookup Field (Multiple Values) via SSOM C#.

 Continue reading “SharePoint Lookup Field Multiple Values Via C#”

Detect the Installed SharePoint Edition Using PowerShell

In this article, I will explain

How to detect the installed SharePoint Edition Using PowerShell?


Prerequisites

Before you getting started, you should make sure that the current user has sufficient privilege to run PowerShell Script in SharePoint, Read more at Add-SPShellAdmin

Note: You can directly use the farm account to run this script.


Script Functions

There is a lot of articles talk about this topic, but the new here is detecting the SharePoint 2016 Edition based on the SKU ID. Continue reading “Detect the Installed SharePoint Edition Using PowerShell”

Export Data View To Excel In SharePoint 2016 / 2013

In this article, I will show How to

Export Data View Web Part To Excel In SharePoint 2013 / 2016

Scenario

In SharePoint 2013, I created a Data View Web Part with an external database connection as a data source via SharePoint designer.

Export Data View to Excel In SharePoint Continue reading “Export Data View To Excel In SharePoint 2016 / 2013”