# Creating a Basic Library

> Create a reusable workflow library in Studio, publish it as a NuGet package, and add it as a dependency in other projects.

The following tutorial walks you through the steps of creating a [library](https://docs.uipath.com/studio/standalone/latest/user-guide/about-libraries#about-libraries) in Studio, publishing and using it in other automation projects.

Creating a library is similar to [Creating a Basic Process](https://docs.uipath.com/studio/standalone/latest/user-guide/creating-basic-process). The difference is that a library is a package containing reusable components which can be used in the context of other projects.

This example gets data from an Excel spreadsheet and appends it to another Excel file. Next, it walks you through the steps for packaging and publishing the project to a custom feed, installing the package to another project, and using the activity it contains.

This example uses [Excel](https://docs.uipath.com/activities/docs/about-the-excel-activities-pack) activities that do not require Microsoft Excel to be installed on your machine.

Let’s begin.

## Creating a Library

1. Launch Studio. In the HOME Backstage view, click **Library** to create a new library project. The **New Blank Library** window is displayed.

   ![docs image](https://dev-assets.cms.uipath.com/assets/images/studio/studio-docs-image-325607-aa6de401.webp)
2. In the New Blank Library window:
   * Enter a name for the new project and a description that summaries what you are aiming to do with this automation. For this example, you can use the name **QuickLibrary**.
     :::note
     The project name cannot exceed 128 characters, and the description cannot exceed 500 characters.
     :::
   * Select **Show advanced options** and choose the location where to create the project.
   * Select **Windows** for the **Compatibility** option and **VB** for **Language**.
3. Click **Create**. The new library is opened in Studio.

## Adding Excel Activities

1. In the **Activities** panel, search for the [Excel Process Scope](https://docs.uipath.com/activities/docs/excel-process-scope-x) activity and drop it to the **Designer** panel.
2. Add a [Use Excel File](https://docs.uipath.com/activities/docs/excel-application-card) activity to the sequence. This activity is required for most of the Excel-related activities.
3. In the **Excel file** field, browse to the Excel file from which you want to get the data. Optionally, you can use the **Reference as** field to change the way this file is referenced throughout the workflow (`Excel1` in this case).
4. Add a second [Use Excel File](https://docs.uipath.com/activities/docs/excel-application-card) activity inside the first **Use Excel File** activity and browse to the Excel file where you want to copy the data. Add an optional reference to this second file (`Excel2` in this case).
5. Add a [Copy/Paste Range](https://docs.uipath.com/activities/docs/copy-paste-range-x) activity.
6. In the **Source** field, select the **Plus**![docs image](https://dev-assets.cms.uipath.com/assets/images/studio/studio-docs-image-plus_menu-8a20ac7d.png) button to indicate the name of the sheet in the first workbook. For this example, the field should read `Excel1.Sheet("Sheet1")`.
7. In the "Destination" field, select **Plus**![docs image](https://dev-assets.cms.uipath.com/assets/images/studio/studio-docs-image-plus_menu-8a20ac7d.png) to indicate the name of the sheet in the second workbook (`Excel2.Sheet("Sheet1")` in our case). Your project should look like in the image below.

   ![docs image](https://dev-assets.cms.uipath.com/assets/images/studio/studio-docs-image-167077-7edec769.webp)
8. In the ribbon, click **Run File** or use **Ctrl + F6** to execute the workflow. The data gathered from the first Excel spreadsheet is copied to another.

## Packaging a Library

To add this library as a reusable component to other automation projects, you need to package it as a `.nupkg` file by [publishing the project](https://docs.uipath.com/studio/standalone/latest/user-guide/about-publishing-automation-projects#about-publishing-automation-projects).

1. Open the library project in Studio.
2. From the ribbon, click the **Publish** button. The **Publish Library** window opens.
   * In the **Package properties** tab, enter a package name. In the **Release Notes** field, add a few details about the library. This is useful for tracking the changes made to the library in each new published version.
   * In the **Publish options** tab, select **Publish to** > **Custom**, and then, in the **Custom URL** field, add the path to a local folder. For example, you can create a `myfeed` folder on your Desktop.
3. Click **Publish**. The package is now available in the local folder as a `.nupkg` file.

   ![docs image](https://dev-assets.cms.uipath.com/assets/images/studio/studio-docs-image-171475-4e0d8629.webp)

## Installing Reusable Components

To use the package in another project, you first need to add it as a project dependency. To get started, create a new **Process** in Studio, as explained in the [Creating a Basic Process](https://docs.uipath.com/studio/standalone/latest/user-guide/creating-basic-process) page.

Read more about project dependencies in the [About Dependencies](https://docs.uipath.com/studio/standalone/latest/user-guide/about-dependencies) page.

### Adding a Custom Feed

1. In the Studio ribbon, click **Manage Packages > Settings**. The default and user-defined feeds are displayed.
2. In the **User defined packages sources** container, add a name for your feed in the **Name** field. In the **Source** field, add the path to the folder where you published your library to.
3. Click **Add**. Your new feed is added to the section.

   ![docs image](https://dev-assets.cms.uipath.com/assets/images/studio/studio-docs-image-168361-0e90a204.webp)

You need to follow the above steps whenever you want to add or remove a user-defined feed in Studio. Check out the [About Activities Packages](https://docs.uipath.com/studio/standalone/latest/user-guide/managing-activities-packages#managing-activity-packages) to read more information about activities feeds.

### Installing the Package

1. In the **Manage Packages** window, go to the previously added feed under the **All Packages** tab on the left. The list of packages available on the feed is displayed.
2. Search for the package and select it. In our example, the package name is **QuickLibrary**.
3. Click **Install**, then **Save**. The package is now installed in your project, and visible in the **Explorer** panel, under **Dependencies**.

   ![docs image](https://dev-assets.cms.uipath.com/assets/images/studio/studio-docs-image-610022-f6c8dc0c.webp)

### Adding Activities From the Library

1. In the **Activities** panel, search for the name of the package, in our case `Quick Library`.
2. Drop the activity in the **Designer** panel.
3. In the Studio ribbon, click **Run File** or use **Ctrl + F6** to execute the activity.

   ![docs image](https://dev-assets.cms.uipath.com/assets/images/studio/studio-docs-image-168941-2eee2449.webp)

You can add other activities like [Copy Sheet](https://docs.uipath.com/activities/lang-en/docs/excel-copy-sheet) or [Auto Fill Range](https://docs.uipath.com/activities/lang-en/docs/excel-auto-fill-range), but these require Microsoft Excel to be installed on your machine.

The advantage of reusable components is that they reduce repetition. You create them once and reuse them in other projects.

To download the library we created above, click the button below:

[Download example](https://documentationexamplerepo.blob.core.windows.net/examples/Studio_v2022.10/QuickLibrary.zip)