I want to keep daily stats of my Twitter Account

This functionality will require installation of the free Twitter Addon!

Problem:

I want to keep daily stats of my Twitter Account

Solution:

Discussion:

We start by specifying the folder and subfolders in which our excel file is located, and continue by getting the current date and time, so that we can append it to the excel file among with the figures we will retrieve.

Using the “Launch Excel” action, we specify the path for our excel file that holds our Twitter Stats, and continue building our job using the “Get Twitter User” action, whose output variable holds all the information we need to fill in our Daily Stats.

I want to get the text contained within a specific cell of my Excel Spreadsheet

Problem:

I want to get the text contained within a specific cell of my Excel Spreadsheet

Solution:

Discussion:

We need to launch the excel file, and get the first free row and column via data extraction, so that we can use it in Action 3 where we will retrieve the values of our excel table and store them in our data table. Since we do not know how many columns or rows are used in our excel spreadsheet, we shall use the %FirstFreeColumn% and %FirstFreeRow% variables to define the last used column and row, since the first free column and row are obviously empty, this means that the column and row prior to them are filled in with data.

I want to send an email to multiple recipients using the contacts’ information found in my Excel Spreadsheet

Problem:

I want to send an email to multiple recipients using the contacts’ information found in my Excel Spreadsheet

Solution:

The following job describes how one can use the information retrieved from a contact list, to be used to send an email to each member of the list, using their details, creating a more personalized email and sending it off to each recipient.

Discussion:

We start by launching our Excel file, and start the data extraction by getting the first free row and column. This will help us determine which is the last row and column used to set the margins of our data table in the next action.

I want to organize my Excel Contacts List

Problem:

I want to organize my Excel Contacts List (split Full Name column to Name and Surname columns, split Address column to Street Name, Street Number, Region and Postcode columns, etc)

Solution:

Parsing text using regular expressions will help you organize all your excel files in a format that suits your needs without having to manually going through each line and cutting-pasting the data.

Discussion:

Depending on the format your Excel file has, you can write your own Regular Expression that will parse the text from any column, and write it to the columns that you want. You can also use the “Split Text” action to split the contents of any column using either a regular expression or a delimiter that will split the contents and store them in a list type variable that contains 2 items only.

I want to separate the lines of a text file into categories and write them into an excel file

Problem:

I want to separate the lines of a Text File into categories and write them into an Excel file

Solution:

We can use the job displayed above to parse data fromĀ a text file appended into an Excel file, after they have been split into categories.

Discussion:

We start by launching the Excel to open a new blank document. We use the “Read Text from File” action to read the contents of the file that contains the text we want to categorize into our Excel spreadsheet.

In order to make sure that the right content is sent to the right column of our Excel Sheet, we need to make sure that all lines of our text file contain the same type of information.

Copyright 2016 - Softomotive Ltd