New answers tagged

0

I'm not sure I entirely understand the question, however there are a couple of points (assuming I'm understanding it a little). Firstly, if you are looking to be able to show the OOTB meta that is shown in the excel docs etc.... then just create the meta data columns in the Content Type (you need to make sure it's named exactly the same, and is also the ...


0

If the file is in a SharePoint library you can configure the library no default open in application and not online.


2

That is part of the Enterprise edition of SharePoint Server. This functionality will not be available to you with SharePoint Foundation. Office Web Apps is not a factor here.


-1

This is a simple issue of your site not added to trusted site in internet options of Internet explorer. Add it to trusted sites then try.


0

Try to Change the Stylesheets as described here: http://www.andrewjbillings.com/sharepoint-20102013-content-query-web-part-please-open-in-office-web-apps-ugh-i-loathe-you-right-now/


0

You upload each table as a separate list into SharePoint. However by the sounds of it this may not be the best solution as your excel document sounds quite complicated. You may have to do a bit of fiddling to get any connections and formulas right. To export a given table into SharePoint click on the table and go to the table tab (Design) and click export > ...


0

You can upload the spreadsheet in a document library and on the landing page of you SharePoint site, place the document library list view web part or you can just edit the page and insert a hyperlink and reference the Excel sheet.


-1

You will need to create two list: 1. the list that connected to the chart that contain the options and a column for counting 2. The list that contain the rest of the information This link will help you to create a dynamical chart http://www.nothingbutsharepoint.com/2011/08/04/sharepoint-2010-pie-chart-with-counts-aspx/


0

Macro enabled workbooks can be opened in the web viewer, but their contents are not executed. You may need to explore using or building an Office Add-In for this visualization. Workbook file formats that are supported in a browser window Workbooks in any of the following file formats can be viewed in a browser window: Excel workbook ...


0

Please see the below. For the full article click link. https://support.office.com/en-us/article/Export-an-Excel-table-to-a-SharePoint-list-d1c7a1e5-d9ee-4322-87ed-924323d0ac53 Works great. I have done this many times. Export a table to a SharePoint list In the worksheet, click anywhere in the table that you want to export. Tip: This displays the Table ...


1

This is because of security setting of SharePoint.Source All you've to do is: add the OnClientClick to the button's event, _spFormOnSubmitCalled = false;_spSuppressFormOnSubmitWrapper=true; <asp:Button ID="btnExportToExcel" runat="server" Text="Export to Excel" onclick="btnExportToExcel_Click" OnClientClick="_spFormOnSubmitCalled = ...


0

This is solution int j = 1; //Set alternate row color tableRef.HeaderRow.Style.Add("font-size", "15"); foreach (GridViewRow gvrow in tableRef.Rows) { //gvrow.BackColor = System.Drawing.Color.White; if (j <= tableRef.Rows.Count) { for (int ...


1

Default Functionality of export to excel for list is Awesome, but according to me the same cannot be call through any API. So I would suggest rather than Workflow, go with SharePoint Timer Job feature. This link would help you do the same and achieve your functionality http://bhatiaashish.blogspot.in/2012/09/export-to-excel-and-email-sharepoint.html ...


0

I had a similar requirement but decided to generate the Excel and later Word file using javascript. I don't have any examples for generating the excel file. What I do remember is that the basic plugins I used were transforming HTML into Excel which made Excel think that the file was a webpage (received html extension when saved without changing the file ...


0

Import from excel will solve one of your problem. But I really doubt if you modify in excel in real time it will affect? By any chance are you using any server side code? Probably you can write an event receiver in worst case.


0

In Excel, this is a real challenge. In the past this was possible, but MS removed that functionality from Excel in version 2010 (?). If you want to synchronize a sharepoint list outside of SharePoint I would suggest considering MS-Access. That's the preferred way.


0

There are two ways which I think you can use. First way is to use Import SpreadSheet app provided by the Sharepoint. http://3sharp.com/blog/load-excel-data-into-a-sharepoint-2013-list-fast-and-easy/ If you want to create new list from excel then you can use Export table command ...



Top 50 recent answers are included