Name: Excel-Add-in-SalesLeads
Owner: Office Developer
Description: Shows how to create worksheets and tables, hide worksheets, sort tables, use conditional table formatting, create charts, add trendlines to charts, hide gridlines, include hyperlinks from one table to another, and convert the workbook to a byte array.
Created: 2018-01-10 21:16:05.0
Updated: 2018-03-01 07:52:14.0
Pushed: 2018-02-14 23:37:50.0
Homepage: null
Size: 2406
Language: JavaScript
GitHub Committers
User | Most Recent Commit | # Commits |
---|
Other Committers
User | Most Recent Commit | # Commits |
---|
Shows how to create worksheets and tables, hide worksheets, color worksheet tabs, freeze table headers, sort tables, use conditional table formatting, create charts, add trendlines to charts, hide gridlines, include hyperlinks from one table to another, and convert the workbook to a byte array.
npm install
. This will install babel and WebPack.
- Its gridlines are hidden.
- The table at the top contains the sales leads for the salesperson “Sally Jump” taken from the Opportunities worksheet.
- The column of customers in the table are hyperlinks to the customer's contact info in the Customers worksheet.
- The Expected Value column is conditionally formatted with a color scale, so that the lead with the highest potential value is red, the lead with the lowest is blue, and other leads other leads are mixtures of red, blue, and yellow depending on how close they are to the highest and lowest potential values.
- The chart shows the sales in 2016 of the salesperson “Sally Jump”.
- The chart has a trendline showing the trend of the salesperson's sales in 2016.
Note: The Download Report button is intended only to illustrate a possible enhancement. It is not implemented.
We'd love to get your feedback about this sample. You can send your feedback to us in the Issues section of this repository.
Questions about Microsoft Office 365 development in general should be posted to Stack Overflow. If your question is about the Office JavaScript APIs, make sure that your questions are tagged with [office-js] and [API].
This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.
Copyright (c) 2018 Microsoft Corporation. All rights reserved.