Category Archives: Programming

programming

C# – First steps with C# and .NET – part 023 .

In this tutorial, I will show you how to use C # with Google A.P.I. on Linux. You will need to set an authentication key in your google account, see the credentials page. I used Fedora Linux to install the NuGet command:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
[root@desk mythcat]# dnf install nuget
Last metadata expiration check: 1:18:10 ago on Sat 06 Feb 2021 10:32:19 PM EET.
Dependencies resolved.
================================================================================
Package        Architecture    Version                   Repository       Size
================================================================================
Installing:
nuget          x86_64          2.8.7-11.fc33             fedora          419 k
 
Transaction Summary
================================================================================
Install  1 Package
 
Total download size: 419 k
Installed size: 1.6 M
Is this ok [y/N]: y
...
Installed:
  nuget-2.8.7-11.fc33.x86_64                                                    
 
Complete!

Use this command to install it:

1
2
3
4
5
6
7
8
9
10
11
12
13
[mythcat@desk CSharpProjects]$ nuget install Google.Apis.Discovery.v1
Attempting to resolve dependency 'Google.Apis (= 1.10.0)'.
Attempting to resolve dependency 'Google.Apis.Core (≥ 1.10.0)'.
Attempting to resolve dependency 'Microsoft.Bcl (≥ 1.1.10)'.
Attempting to resolve dependency 'Microsoft.Bcl.Build (≥ 1.0.14)'.
Attempting to resolve dependency 'Microsoft.Bcl.Async (≥ 1.0.168)'.
Attempting to resolve dependency 'Microsoft.Bcl.Build (≥ 1.0.21)'.
Attempting to resolve dependency 'Microsoft.Net.Http (≥ 2.2.29)'.
Attempting to resolve dependency 'Newtonsoft.Json (≥ 7.0.1)'.
Attempting to resolve dependency 'Zlib.Portable.Signed (≥ 1.11.0)'.
Attempting to resolve dependency 'log4net (≥ 2.0.3)'.
Attempting to resolve dependency 'Google.Apis (≥ 1.49.0)'.
'Google.Apis' already has a dependency defined for 'Google.Apis.Core'.

Create a basic C# project… Read More »

Web – Google Book A.P.I. and codepen.

The tool website called codepen.io is a very useful tool in which you can test HTML, CSS, and JavaScript source code with the related libraries. In this short tutorial, I show you I translated a simple example from Google Books A.P.I. in the codepen.io web interface. The basic example of the source code from the… Read More »

C# – First steps with C# and .NET – part 022 .

Today I will show a simple example with the multidimensional array in C#. You can read the documentation from Microsoft. It is easier for a beginner to understand from a simple example.

C#
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
using System;
 
class MainClass {
  public static void Main (string[] args) {
    Console.WriteLine ("This is a multidimensional array with two dimension D1 and D2!");
    int D1 = 5;
    int D2 = 3;
    // two dimensional array
    int[,] array_ex_001 = new int[D1, D2];
    array_ex_001[1, 2] = 76;
    Console.WriteLine("array at 0,0 is " + array_ex_001[0,0]);
    Console.WriteLine("array at 1,2 is " + array_ex_001[1,2]);
 
    // two dimensional array
    int[,] array_ex_002 = {{1,2},{3,4}};
 
    for (int i = 0; i < array_ex_002.GetLength(0); i++)
    {
      for (int j = 0; j < array_ex_002.GetLength(1); j++)
      {
        Console.WriteLine (array_ex_002[i,j]);
      }    
    }
    // three dimensional array with sized 4,2,3
    
    int[,,] array_ex_003 = new int[4, 2, 3];
    array_ex_003[2, 1, 1] = 76;
    // use for to show values , default is 0
    for (int a = 0; a < array_ex_003.GetLength(2); a++)
    {
      for (int b = 0; b < array_ex_003.GetLength(1); b++)
      {
        for (int c = 0; c < array_ex_003.GetLength(0); c++)
        {
          Console.Write(array_ex_003[c, b, a]);
        }
        Console.WriteLine();
      }
      Console.WriteLine();
    }      
  }
}

You can see it on this website:

C# – First steps with C# and .NET – part 021 .

This tutorial is about another subject for beginners named:

1
[STAThread]

I saw many questions on the web about this subject and this is the reason for this tutorial. The [STAThread] is a carry-over from Microsoft’s “Component Object Model”, known as COM. Because COM provided both single-threaded apartment (STA), and multi-threaded (MTA) programming models then that… Read More »

Google Apps Script – getValue or getDisplayValue – part 032.

In this tutorial, I will show you the differences between getValue and getDisplayValue in Google Apps Script. I used a default project with a default spreadsheet document with my birthday 1976-03-07 into A1 cell and format text as year-month-day. I add Apps Script API to my project. On the spreadsheet, I used Tools – Script… Read More »

Google Apps Script – shows a popup window – part 031.

The tutorial for today is about toast message into a spreadsheet. Use script editor, run the next code source it with authorization:

JavaScript
1
2
3
4
5
function myFunction() {
  var ss = SpreadsheetApp.getActive();
  ws = ss.getSheetByName("Sheet1");
  ss.toast("This is a toast message!");
}

You will see a message toast in the bottom right area of the spreadsheet with this text: This is a toast message!

Google Apps Script – about Class GmailThread – part 030.

Today I will present briefly Class GmailThread. It can be used to retrieve data from incoming electronic mail received by Gmail. Let’s see a simple example. First, open a spreadsheet, and from Tools open the Script editor to run this source code:

1
2
3
4
5
6
7
function getGmailData() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var threads = GmailApp.search("is:unread in:inbox", 0, 7);
  for (var t=0; t<threads.length; t++) {
    sheet.appendRow([threads[t], threads[t].getId(), threads[t].getLabels(),threads[t].getFirstMessageSubject()])
  }
}

. Add and run with authorization for Gmail A.P.I. and you will see… Read More »