10
votes
Exporting SharePoint Members into Excel
Below worked for me:
Steps:
1) Open Excel File.
2) Go to ribbon, select DATA and select From Other Sources, and click on From OData Data Feed.
3) In ‘Data Connection Wizard’ form, provide ...
- 631
6
votes
Generating excel file from SharePoint list
Use export to excel option.
The list will be downloaded as an excel file.
Open the file and provide your sharepoint credentials.
You are good to go.
- 847
5
votes
Accepted
How to Export a Document Library to Excel from SharePoint 2010 using a custom button?
You mean like using a link? Such as this one: {Site URL}/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={List GUID}&View={View GUID}&CacheControl=1 from the post Create Link ...
- 25.5k
5
votes
Ping from SharePoint list
I don't think this is a good use case for SharePoint. You're talking about running a "ping" from a web page but JavaScript running in a web page cannot do this - it only speaks HTTP. So you can issue ...
- 7,963
5
votes
Accepted
SharePoint 2013 list does not export all data to Excel
Can you check if there is filter applied on the view from where you are exporting the excel?
Try opening allitems.aspx (hope this view is not filtered) else you can create brand new view (without any ...
- 1,051
5
votes
Accepted
Is there a shorthand way to save a sharepoint list as csv
As a short answer: No.
There is no such parameter to export a list or Library to Excel / CSV from URL.
Behind clicking on Export List to Excel from the above ribbon, you will get a URL like
http://...
- 45.4k
4
votes
Accepted
How to save a list in a csv file via Powershell
PowerShell for SharePoint Online has really limited capabilities at the moment. There is no one liner to automate this task. But you can use CSOM inside your scripts.
[System.Reflection.Assembly]::...
- 1,932
4
votes
Programmatically read Excel file in SharePoint 2013 sandbox solution gives permission error
APPROACH 1
First add reference of two COM components.
Microsoft Office Object Library
Microsoft Excel Object Library
excel = new ApplicationClass();
excel.Visible = false;
string workbookPath = url;...
- 7,838
4
votes
Accepted
Excel file corrupted after uploading to Sharepoint with Python
Figured out the problem with my original code:
needed to provide data kwarg and NOT files kwarg:
import requests
from requests_ntlm import HttpNtlmAuth
session = requests.Session()
session.auth = ...
- 181
4
votes
Accepted
Import/Copy/Paste Data from Excel into Existing SharePoint List
The key points are recognizing the column types and formatting the data appropriately in Excel before the attempting the import. Certain column types are not able to be imported in this way, such as ...
- 243
4
votes
Accepted
Browser freezing when pasting large data?
I tried to do the same as you (1000+ rows) and the behavior of the browser was exactly the same. After reading more carefully the documentation Software boundaries and limits for SharePoint 2013 I ...
- 196
4
votes
Choice field data contains # when exported to excel
I am not 100% sure if this should be posted as an answer or a comment (but the question doesn't include a question).
You can't get it without the #. The separator is actually ",#": a comma followed ...
- 355
3
votes
Error when copying an empty choice field from Excel into a SharePoint 2013 Datasheet View
In this kind of situations, I modify the column and make it allow fill in choices. Then I upload the data, which will not fail, and then change the allow fill in choices option back to No.
- 399
3
votes
how to export BI report to excel
I’m not sure an Anonymous user have the permission to actually read the data that generates the dashboard. Viewing the dashboard is different than accessing the raw data, and the little SharePoint ...
- 25.5k
3
votes
Accepted
Import Spreadsheet with field name listed vertically/per row
SharePoint won't be able to create a list from a spreadsheet in that format. Nor will you be able to copy and paste it into quick edit mode. (Theoretically you would be able to copy and paste it, but ...
- 9,721
3
votes
Unable to refresh data in Excel Online connected using Power Query
Clearest answer I've found to this is here:
SharePoint doesn't support refreshing Power Query data sources at the
present time. Although it's true that SharePoint and SharePoint
Online don't ...
- 235
3
votes
Not clickable cells with excel web part
Yes there is.
Open your spreadsheet in Excel client application. Select the cells you want to disable from clicking. Go to the review tab, and select protect sheet. Uncheck the "Select locked cells" ...
- 25.5k
3
votes
Prevent user from saving file on local hard drive
If a user has Read permissions to a file, then they will be able to download it. You can specify 'View Only' permissions, which will prevent a report (rdl) from being downloaded, but won't stop a ...
- 261
3
votes
Open a specific Workbook in Excel online using the URL in SharePoint online Excel Workbook
/_layouts/15/WopiFrame.aspx?sourcedoc=ID&file=filename.xlsx&action=default
replace "action=default" with "activeCell=%27sheetname%27!A1" set active cell in the link, and specify sheet and ...
- 337
3
votes
Ping from SharePoint list
If I'm sure, you're using SharePoint Online, so your only possibility is to use a client-side option. I think that you can actually do this using Client-Side Rendering (JSLink) in your list, or just ...
- 608
3
votes
open excel file from spfx onclick
You should append the query string ?web=1 to the ServerRelativeUrl.
It will open the file in the browser instead of downloading the file.
Modify your method as below:
window.open(d....
- 30.8k
3
votes
Accepted
Exporting item version check in comments
You can use this parameter$($version['Check In Comment']) in the PowerShell script to get the 'Check In Comment'. but unfortunately, it gets only the comment of the current item (last version).
So to ...
- 45.4k
3
votes
unable to refresh data in excel from sharepoint
Please go to excel > data > connections > connections to see if there is your connection (its name should be same with your file name) in this windows. If yes, please double click it and select ...
- 107
2
votes
Exporting SharePoint Members into Excel
I was able to pull the membership of a 2013 SharePoint permission group that had 2035 members using the following steps. Note that I wanted the account name only. You may need to modify this process ...
- 387
2
votes
Cannot edit column type or delete it in Sharepoint 2013
Try following PowerShell script to delete it forcefully and be aware of after effect!
$web = Get-SPWeb -identity http://YourSiteUrl
$list = $web.Lists["Your List Name"]
$column = $list.Fields["Name ...
- 13.4k
2
votes
Can you prevent Excel for adjusting column widths when doing an export from sharepoint?
In Excel, click into the table, then on the Data ribbon in the Connections group click Properties. That will open a dialog where you can untick the option "Adjust column width".
- 8,867
2
votes
how to export to Excel from a webpart
Just add one link and pass the below URL to that link, no need to write the code. Just prepare the view of the respective list and export it to excel.
http://servername:port/sitename/_vti_bin/owssvr....
- 1,027
2
votes
Export mulltiple lists onto same sheet in Excel?
Once you have an Excel workbook open, any time you Export a list to Excel it will prompt you asking where to put it. So if you want it in the same sheet or the same workbook, you can just select that ...
- 4,038
2
votes
Export mulltiple lists onto same sheet in Excel?
there is no OOT functionality which support this but here is workaround, which may solve you problem.
Go to SharePoint List A and then click on List tab on Ribbon control
Then click on ‘Export to ...
- 57k
2
votes
From Excel 2010 is it possible to attach a PDF file to a list item.
Try working with this code snippet. This assumes you have an SPWeb and SPList open:
var item = list.GetItemById("your_item_ID");
var file = web.GetFile("URL_of_your_file");
var bin = file.OpenBinary()...
- 3,808
Only top scored, non community-wiki answers of a minimum length are eligible