a6e5b969-be6e-4756-ae53-47d3cb899ca4.png

b186119e-f163-40c3-a8f1-31054e9583fb.JPG

**About COWIN Help bot**

COWIN help bot is designed to find available vaccinations in India from COWIN Portal. COWIN help bot makes use of COWIN API from API SETU.This bot has been created with minimal external apps dependency to help replicate easily.

  

**Components:**

Input Form  - Input form is used to collect data from users (Name, Age group(18+/45+), email, district). A summary sheet is downloaded from the forms page and taken as input. 

Link for duplicating and creating your own forms from the below links : 

  

**COWIN registration replicable link:** 

https://forms.office.com/Pages/ShareFormPage.aspx?id=Kj012FOxF02IJ5AsUfcjVx8AuLFwVI9KmHAZAvk068RUNDZKTjA4RFYxSjNYVFFONFRQRjZKVVNSQi4u&sharetoken=BZfrgFhi1ZbgfvtOKc83&wdLOR=cB0C50184-AFD0-4003-B8C2-3CEA489C0064

  

**COWIN Unsubscribe replicable link :** 

https://forms.office.com/Pages/ShareFormPage.aspx?id=Kj012FOxF02IJ5AsUfcjVwFOE2DnTQxIvdjyjM4ZWVRUQjk2U0VNNldVSjg2VzJRN0FBQjk4MjVJNy4u&sharetoken=JNivpCFMYipjsxnW5BCx&wdLOR=c56897BCD-7FB7-4C94-840E-AB7F74322C8F

  

Bot Process - Bot process takes the file downloaded from input form – for each district and for each age group - derives district code (API takes district code as input) and captures results and sends emails to relevant people.

COWIN help bot is designed to find available vaccinations in India from COWIN Portal. COWIN help bot makes use of COWIN API from API SETU.

This package has been created with the purpose to extract all the charts as images from a particular Excel sheet in the preferred format (Image Extension can be png/jpg/bmp/gif).

The user has to provide the Excel file path and sheet name from which the charts needs to extracted. Also, to provide the folder path where all the images need to be stored.

Image extension argument is optional and by default the value will be "png".

Image name will be the same as chart/graph name.

Extracts charts or graphs as images from an Excel file.

This package has been created with the purpose to extract all the charts as images from a particular Excel sheet in the preferred format (image extension can be png/jpg/bmp/gif).

  

The user has to provide the Excel file path and sheet name from which the charts need to be extracted. Also, to provide the folder path where all the images need to be stored.

  

Image extension argument is optional and by default the value will be "png".

  

The name of the image will be the same as chart/graph name.

b0a686df-1960-43a9-a7b1-f2e9f9fb5bf2.png

This package has been created to create pivot table with specific pivot fields from the data source.

  

Mandatory input fields :

*   Workbook File Path - This activity works on a single file and it must contain your data source for pivot in the same file.
*   Data Source Sheet Name (where data source is available) & Input Data Source Range.
*   Destination Sheet Name (where pivot table will be created).

Optional Fields

*   Destination Data Source Range, Row Pivot Fields, Column Pivot Fields & Data Pivot Fields. Multiple pivot fields can be added as comma ',' separated values.

Notes:

*   At least one of the pivot field argument must be filled.
*   If the destination sheet name does not exist in the Excel, it will create it.
*   If destination data source range is not provided, it will consider the range as "A1".
*   Before using the activity, the Excel file should be closed.
*   The activity will load the file and process the activity in the background.
*   Excel file name must be mentioned in absolute path.

Creates pivot table with specific pivot fields.

This package has been created to create pivot table with specific pivot fields from the data source.

  

Mandatory input fields :

*   Workbook File Path - This activity works on a single file and it must contain your data source for pivot in the same file.
*   Data Source Sheet Name (where data source is available) & Input Data Source Range.
*   Destination Sheet Name (where pivot table will be created).

Optional Fields

*   Destination Data Source Range, Row Pivot Fields, Column Pivot Fields & Data Pivot Fields. Multiple pivot fields can be added as comma ',' separated values.

Notes:

*   At least one of the pivot field argument must be filled.
*   If the destination sheet name does not exist in Excel, it will create it.
*   If destination data source range is not provided, it will consider the range as "A1".
*   Before using the activity, the Excel file should be closed.
*   The activity will load the file and process the activity in the background.
*   Excel file name must be mentioned in absolute path.

This package is comprised of the following 3 activities:

*   Extract All Tables
*   Extract Single Table
*   Update Word Table

For more detailed information regarding each activity, please check the user guide attached in the documentation section.

This activity can be utilized to format a DataTable which is not correctly arranged/aligned and needs to be rearranged. You can effectively rectify formatting discrepancies, thereby streamlining the presentation of information for improved accessibility and analysis.

Activity to format a DataTable which is not correctly arranged/aligned and needs to be rearranged.

161345d9-c16a-454e-a48e-f74262d1e21a.png

This package is useful for:

*   creating a pivot table with specific pivot fields and filters from the data source.
*   updating data source range and refresh existing pivot tables.

**Create Pivot Table**

  

This package helps to create pivot table with specific pivot fields from the data source and you can also perform actions like 'add filters'.  

**Mandatory input fields**:

*   Workbook File Path - This activity works on a single file and it must contain your data source for the pivot in the same file.
*   Input Sheet Name - The name of the sheet where source data is present.
*   Input Data Range - Range of Input data.
*   Destination Data Range - Start range in destination sheet where the pivot table needs to be created, e.g. 'A1'.
*   Destination Sheet Name - Sheet name where the pivot table needs to be created. If the sheet is not available it will create a new sheet.  
    

**Optional Fields**

*   Row Pivot Fields - Pivot fields in Row section. For multiple fields use "," as a separator.
*   Column Pivot Fields - Pivot fields in Column section. For multiple fields use "," as a separator.
*   Data Pivot Fields - Pivot fields in Value section. For multiple fields use "," as a separator.
*   Data Pivot Filter - Choose the type of calculation that you want to use to summarize data from the selected field under Value section. The options available are Sum, Count, Avg, Min, Product, CountNum, stDev, stDevP, Var, VarP.
*   Filter Pivot Field - Pivot field in Filter section.  
    

**Notes**  
\- At least one of the pivot field arguments must be provided.  
\- If the destination sheet name does not exists in Excel, it will be created.

\- If destination data source range is not provided, it will consider the range as "A1".  
\- Before using the activity, the Excel file should be closed.  
\- The activity will load the file and process the activity in the background, it uses Excel Interops.  
\- Excel file name must be mentioned in absolute path.

  

**Update Pivot Table**

  

This activity will update the data source range if needed and refresh the existing pivot table in Excel.

  

**Mandatory input fields:**

*   Workbook File Path - This activity works on a single file and it must contain your data source for the pivot in the same file.
*   Pivot Sheet Name - The name of the sheet where the pivot is available.  
    

Optional Fields:

*   Pivot Table Source Range - Source range of the pivot table e.g. "A1:C4".
*   Pivot Table Name - Pivot table name to be updated/refreshed.
*   Pivot Data Source Range - Data source range. Format : R + Rowstartingnumber + C + Column StartingNumber : R + Rowendnumber + C + Column Endnumber. E.g. A1:C4 will be R1C1:R4C3.
*   Pivot Data Source Sheet Name - Data source sheet name.  
    

**Notes**  
\- Either Pivot Table Name or Pivot Table Source Range should be provided.  
\- If any change takes place in the data source range, then Pivot Data Source Range and Pivot Data Source Sheet Name should be provided.  
\- Before using the activity, the Excel file should be closed.  
\- The activity will load the file and process the activity in the background, it uses Excel Interops.  
\- Excel file name must be mentioned in absolute path.

Creates a pivot table with specific pivot fields or updates an existing pivot table in Excel.

About me