Name: Excel-Add-in-Generate-CSV
Owner: Office Developer
Description: This sample shows how to add worksheets, ranges, and tables to an Excel workbook.
Created: 2015-10-15 20:50:50.0
Updated: 2017-05-11 21:22:56.0
Pushed: 2018-01-31 20:32:25.0
Homepage: null
Size: 3137
Language: JavaScript
GitHub Committers
| User | Most Recent Commit | # Commits |
|---|
Other Committers
| User | Most Recent Commit | # Commits |
|---|
Applies to: Excel 2016
This task pane add-in shows how to create a table from a list of column names by using the JavaScript APIs in Excel 2016. It comes in two flavors: code editor and Visual Studio.
The simplest way to deploy and test your add-in is to copy the files to a network share.
Host the files in the Code Editor project folder by using a server of your choice.
Edit the
Copy the manifest (TeacherCSVGenerator.xml) to a network share (for example, \\MyShare\MyManifests).
Add the share location that contains the manifest as a trusted app catalog in Excel.
a. Launch Excel and open a blank spreadsheet.
b. Choose the File tab, and then choose Options.
c. Choose Trust Center, and then choose the Trust Center Settings button.
d. Choose Trusted Add-in Catalogs.
e. In the Catalog Url box, enter the path to the network share you created in step 3, and then choose Add Catalog.
f. Select the Show in Menu check box, and then choose OK. A message appears to inform you that your settings will be applied the next time you start Office.
Test and run the add-in.
a. On the Insert tab in Excel 2016, choose My Add-ins.
b. In the Office Add-ins dialog box, choose Shared Folder.
c. Choose Teacher CSV Class Roster sample>Insert. The add-in opens in a task pane and creates the CSV class roster in the active sheet as shown in this screenshot.
d. Choose a classroom management service.
e. Click the Make Roster button to insert an empty roster in the active worksheet
f. Click the Excel Export Help button to learn how to export the worksheet as a .csv file.
Copy the project to a local folder and open the TeacherCSVGenerator.sln in Visual Studio.
Press F5 to build and deploy the sample add-in. Excel launches and the add-in opens in a task pane to the right of a blank worksheet, as shown in the following screenshot.
Select an online classroom management service from the drop-down list
Add a student roster table by using the Make roster button and look at the table created in the active worksheet.
Add students to the roster by filling in the cells in rows below the table header.
Use the export feature in Excel to save the worksheet as a .csv file. This file is in the right format to be imported into the service of your choice.
The Excel JavaScript APIs have much more to offer you as you develop add-ins. The following are just a few of the available resources.
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.