No announcements
Found 3255416 threads
-
0 Votesperiodically wanting to import spreadsheet into SharePoint List
Hi frumpyDi, Do you want to import a spreadsheet with fresh content to the previous list?Answered | 1 Replies | 958 Views | Created by frumpyDi - Thursday, November 26, 2015 5:48 AM | Last reply by Chris yuri - Friday, November 27, 2015 5:57 AM
-
0 Votes
Calendar View of an Imported Excel Spreadsheet
Per my test, if I import excel with time and the time format is like 1/16/2016 06:00 AM, all items display time correctly.Answered | 1 Replies | 952 Views | Created by CindyD86 - Wednesday, January 13, 2016 8:51 PM | Last reply by Sara Fan - Thursday, January 14, 2016 7:50 AM -
7 Votes
How to Import items from a spreadsheet into a list in SP2013
I just went through the first article @ http://3sharp.com/blog/load-excel-data-into-a-sharepoint-2013-list-fast-and-easy/ According to this, I ...Answered | 2 Replies | 994 Views | Created by John.P.Smith - Wednesday, March 18, 2015 12:35 PM | Last reply by John.P.Smith - Thursday, March 19, 2015 5:59 AM -
2 Votes
Creating Excel spreadsheet using System.IO.Packaging
Here is a sample to create a workbook through OpenXML SDK: How to: Create a spreadsheet document by providing a file name ...Answered | 6 Replies | 5310 Views | Created by BravoC - Tuesday, August 5, 2014 8:13 PM | Last reply by KinaTina - Wednesday, November 25, 2015 10:17 AM -
0 Votes
Importing from spreadsheet into a maps.live.com collection ????
An idea would be to make a simple program that takes in a list of addresses from your spreadsheet.Answered | 1 Replies | 3531 Views | Created by Polarbear Paul - Wednesday, October 17, 2007 1:10 AM | Last reply by Ricky_Brundritt - Wednesday, October 17, 2007 3:08 AM -
0 Votes
Create new Excel spreadsheet
When I use interop libraries I tend to go for the lowest library that will handle the functionality I am using.Answered | 3 Replies | 3047 Views | Created by Benny F - Thursday, November 3, 2011 7:59 PM | Last reply by Calvin_Gao - Monday, November 7, 2011 5:31 AM -
5 Votes
An unexpected error has occurred (-2147467259) when Importing spreadsheet
Uninstall and re-install 64 Bit and try to import from Spreadsheet to the site.Answered | 6 Replies | 8919 Views | Created by Soupi - Thursday, March 12, 2015 6:34 PM | Last reply by IndulHassan - Wednesday, March 18, 2015 12:25 PM -
2 Votes
ExcelDataReader to import data from excel spreadsheet error
Interop is good when you need to manipulate Office data, not for bulk loading.Answered | 9 Replies | 18768 Views | Created by CSharp Enthusiast - Wednesday, July 19, 2017 6:25 PM | Last reply by Cavanman - Sunday, October 15, 2017 9:21 AM -
0 Votes
Using data from a spreadsheet to change the spreadsheet
999999999 Range("E" & r).EntireRow.Copy Range("E" & r).EntireRow.Insert Range("E" & (r + 1)).Value = ...Answered | 3 Replies | 1221 Views | Created by DaveCos - Sunday, February 3, 2013 8:17 PM | Last reply by DaveCos - Tuesday, February 5, 2013 12:35 PM -
0 Votes
Tables in Spreadsheet
In the code snippet, column headers are disaplyed as 'Column1', 'Column2' and 'Column3'.Answered | 11 Replies | 10404 Views | Created by Akshaya Sharma - Tuesday, December 28, 2010 12:23 PM | Last reply by New.Net Developer - Thursday, December 12, 2013 1:12 PM -
0 Votes
When importing a spreadsheet from Excel 2013 a large margin to the left
Hi Jackie, I have done a test in my SharePoint 2013 and I can reproduce your issue that there is a large margin on the left of the list after import a ...Answered | 6 Replies | 673 Views | Created by jackie.butler - Thursday, July 20, 2017 8:41 PM | Last reply by Lisa Chen1226 - Thursday, July 27, 2017 6:18 AM -
0 Votes
Import SpreadSheet in Claims enabled Web Application
I have fixed the issue, by creating a root site for that web application.Answered | 4 Replies | 1908 Views | Created by Senthu - Monday, November 19, 2012 11:12 AM | Last reply by Senthu - Thursday, November 22, 2012 2:31 PM -
0 Votes
Cannot import spreadsheet into SharePoint 2010 list
Hi zdhiu, According to your description,you are unable to use “Import Spreadsheet” and “Datasheet View” when using ...Answered | 1 Replies | 2120 Views | Created by zdhiu - Wednesday, October 7, 2015 8:09 PM | Last reply by Chris yuri - Thursday, October 8, 2015 10:12 AM -
0 Votes
Convert Xml Spreadsheet 2003 (*.xml) to XML spreadsheet into Xls or Xlsx File
Above Post of stack Overflow seems to be Simply Creating XLSX File using XML Data.Answered | 5 Replies | 8316 Views | Created by Anu_Dev - Sunday, January 19, 2014 4:15 PM | Last reply by ShriG - Thursday, May 5, 2016 6:25 PM -
0 Votes
Naming outlined columns on a spreadsheet
Hello ClarkTJ, I'm afraid outline groups cannot be named out of the box.Answered | 2 Replies | 4251 Views | Created by ClarkTJ - Friday, February 18, 2011 4:28 PM | Last reply by ClarkTJ - Tuesday, February 22, 2011 9:17 PM -
0 Votes
Match column from spreadsheet to SQL server and dump data to same spreadsheet
Hi Amol, How many records(jobnumber) in the spreadsheet?Answered | 4 Replies | 696 Views | Created by SSRS-Newbie - Sunday, April 3, 2016 6:34 PM | Last reply by Fei Xue - Friday, April 8, 2016 10:16 AM -
2 Votes
Embed an Excel Spreadsheet into a webpage
Any data you embed on your Web page can be viewed by all the major destkop and mobile browsers and when you update your spreadsheet the data on your web pages is automatically ...Answered | 25 Replies | 34027 Views | Created by TV01 - Tuesday, January 6, 2009 5:46 PM | Last reply by Bill Pearson - Friday, August 23, 2013 12:34 PM -
0 Votes
Is it possible to have a dynamic spreadsheet?
For example, when I select an employee, the tab would display charts for each department of production.Answered | 3 Replies | 1940 Views | Created by K1NJO - Monday, June 18, 2012 8:36 PM | Last reply by Ed Ferrero - Wednesday, June 20, 2012 12:26 PM -
0 Votes
how to add Import spreadsheet list to left navigation
Hi, According to your description, my understanding is that you want to make the list created using Import Spreadsheet template to display in the Quick ...Answered | 2 Replies | 893 Views | Created by coolsweety - Wednesday, May 14, 2014 5:07 AM | Last reply by Victoria Xia - Thursday, May 15, 2014 5:29 AM -
0 Votes
Sql 2008 SSIS, Importing Excel 2003 Spreadsheets, silent errors
Hi edm2, Yes, the Microsoft Access Database Engine 2010 Redistributable supports the Excel spreadsheets created by Excel 97-2003 or Excel 2013.Answered | 7 Replies | 5949 Views | Created by edm2 - Wednesday, September 11, 2013 12:03 AM | Last reply by Elisberg - Wednesday, October 9, 2013 7:59 AM
No announcements
