C# Xamarin サンプル色々

Xamarinを少し触り始めたので。サンプル色々。

ボタンでアラート

var button = new Button()
{
    Text = "BUTTON"
};
button.Clicked += async (sender, e) =>
{
    var result = await DisplayAlert("タイトル", "本文", "YES", "NO");
};
Content = button;

var button = new Button()

{

Text = "BUTTON"

};

button.Clicked += async (sender, e) =>

{

var result = await DisplayAlert("タイトル", "本文", "YES", "NO");

};

Content = button;

ピッカー(選択リスト)

var piker = new Picker
{
    Title = "選択",
    VerticalOptions = LayoutOptions.Start
};
var ar = Enumerable.Range(0, 100).Select(n => string.Format("item{00}", n));
foreach (var a in ar)
{
    piker.Items.Add(a);
}
Content = piker;

var piker = new Picker

{

Title = "選択",

VerticalOptions = LayoutOptions.Start

};

var ar = Enumerable.Range(0, 100).Select(n => string.Format("item{00}", n));

foreach (var a in ar)

{

piker.Items.Add(a);

}

Content = piker;

タイマーとプログレスバー

var pbar = new ProgressBar
{
    WidthRequest = 300,
    HorizontalOptions = LayoutOptions.Center,
    VerticalOptions = LayoutOptions.CenterAndExpand
};
Device.StartTimer(TimeSpan.FromSeconds(0.1), () =>
{
    pbar.Progress += 0.01;
    return pbar.Progress != 1;
});
Content = pbar;

var pbar = new ProgressBar

{

WidthRequest = 300,

HorizontalOptions = LayoutOptions.Center,

VerticalOptions = LayoutOptions.CenterAndExpand

};

Device.StartTimer(TimeSpan.FromSeconds(0.1), () =>

{

pbar.Progress += 0.01;

return pbar.Progress != 1;

});

Content = pbar;

サーチバー(インプットボックス)

var sbar = new SearchBar
{
    Placeholder = "input",
    VerticalOptions = LayoutOptions.Start
};

sbar.SearchButtonPressed += (s, e) =>
{
    DisplayAlert("入力!", sbar.Text, "ClickMe!");
};
Content = sbar;

var sbar = new SearchBar

{

Placeholder = "input",

VerticalOptions = LayoutOptions.Start

};

sbar.SearchButtonPressed += (s, e) =>

{

DisplayAlert("入力!", sbar.Text, "ClickMe!");

};

Content = sbar;

リストビュー

ListView listView = new ListView
{
    ItemsSource = Enumerable.Range(1, 10).Select(x => string.Format("No{00}", x)).ToList()
};
//アタッチ
listView.ItemSelected += new EventHandler<SelectedItemChangedEventArgs>((object sender, SelectedItemChangedEventArgs e) =>
{

});
//アタッチ簡略
listView.ItemSelected += (s, e) =>
{
    DisplayAlert("", ((ListView)s).SelectedItem.ToString(), "OK");
};
Content = listView;

ListView listView = new ListView

{

ItemsSource = Enumerable.Range(1, 10).Select(x => string.Format("No{00}", x)).ToList()

};

//アタッチ

listView.ItemSelected += new EventHandler<SelectedItemChangedEventArgs>((object sender, SelectedItemChangedEventArgs e) =>

{

});

//アタッチ簡略

listView.ItemSelected += (s, e) =>

{

DisplayAlert("", ((ListView)s).SelectedItem.ToString(), "OK");

};

Content = listView;

C# 定期的にコマンド実行

定期的にtracertを実行したかったので。

using System;
using System.Drawing;
using System.IO;
using System.Text.RegularExpressions;
using System.Diagnostics;
using System.Windows.Forms;

namespace Tracert
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();

            WindowState = FormWindowState.Minimized;
            ShowInTaskbar = false;

            Bitmap bitmap = new Bitmap(32, 32);
            Graphics graphics = Graphics.FromImage(bitmap);
            graphics.FillRectangle(Brushes.Green, graphics.VisibleClipBounds);

            NotifyIcon notifyIcon = new NotifyIcon();
            notifyIcon.Icon = Icon.FromHandle(bitmap.GetHicon());
            notifyIcon.Visible = true;
            notifyIcon.Click += new EventHandler((object sender, EventArgs e) => {
                MessageBox.Show("終了します。");
                Application.Exit();
            });

            Timer timer = new Timer();
            timer.Interval = 3600000;

            timer.Tick += new EventHandler((object sender, EventArgs e)=> {
                Execute();
            });
            timer.Start();
        }

        private void Execute()
        {
            using (Process process = new Process())
            {
                process.StartInfo.RedirectStandardOutput = true;
                process.StartInfo.CreateNoWindow = true;
                process.StartInfo.UseShellExecute = false;
                process.StartInfo.FileName = "tracert";
                process.StartInfo.Arguments = "192.168.5.1";
                process.Start();

                string result = "";
                using (StringReader sr = new StringReader(process.StandardOutput.ReadToEnd()))
                {
                    Regex regex = new Regex(@"ms");
                    while (sr.Peek() > -1)
                    {
                        string ln = sr.ReadLine();
                        if (regex.IsMatch(ln)) result += ln;
                    }
                }
                process.WaitForExit();
                result = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + " " + result;

                using (StreamWriter sw = new StreamWriter(Application.StartupPath + @"\dat.txt", true, System.Text.Encoding.UTF8))
                {
                    sw.Write(result + "\r\n");
                }
            }
        }
    }
}

using System;

using System.Drawing;

using System.IO;

using System.Text.RegularExpressions;

using System.Diagnostics;

using System.Windows.Forms;

namespace Tracert

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

WindowState = FormWindowState.Minimized;

ShowInTaskbar = false;

Bitmap bitmap = new Bitmap(32, 32);

Graphics graphics = Graphics.FromImage(bitmap);

graphics.FillRectangle(Brushes.Green, graphics.VisibleClipBounds);

NotifyIcon notifyIcon = new NotifyIcon();

notifyIcon.Icon = Icon.FromHandle(bitmap.GetHicon());

notifyIcon.Visible = true;

notifyIcon.Click += new EventHandler((object sender, EventArgs e) => {

MessageBox.Show("終了します。");

Application.Exit();

});

Timer timer = new Timer();

timer.Interval = 3600000;

timer.Tick += new EventHandler((object sender, EventArgs e)=> {

Execute();

});

timer.Start();

}

private void Execute()

{

using (Process process = new Process())

{

process.StartInfo.RedirectStandardOutput = true;

process.StartInfo.CreateNoWindow = true;

process.StartInfo.UseShellExecute = false;

process.StartInfo.FileName = "tracert";

process.StartInfo.Arguments = "192.168.5.1";

process.Start();

string result = "";

using (StringReader sr = new StringReader(process.StandardOutput.ReadToEnd()))

{

Regex regex = new Regex(@"ms");

while (sr.Peek() > -1)

{

string ln = sr.ReadLine();

if (regex.IsMatch(ln)) result += ln;

}

process.WaitForExit();

result = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + " " + result;

using (StreamWriter sw = new StreamWriter(Application.StartupPath + @"\dat.txt", true, System.Text.Encoding.UTF8))

{

sw.Write(result + "\r\n");

}

C# TCPを使ったサンプル

using System;
using System.Text;
using System.Net;
using System.Net.Sockets;
using System.Windows.Forms;

namespace TestChat
{
    public partial class Form2 : Form
    {
        public Form2()
        {
            InitializeComponent();

            new Server().Go(textBox1);

            button2.Click += new EventHandler((object sender, EventArgs e) => {
                button2.Enabled = false;
                new Client().Go(textBox3,textBox2,button2);
            });

        }
    }

    //public class Client
    //{
    //    public async void Go(TextBox address, TextBox message, Button button)
    //    {
    //        await Task.Run(()=> {
    //            try
    //            {
    //                using (var tcpClient = new TcpClient(address.Text, 2001))
    //                {
    //                    tcpClient.ReceiveTimeout = 100;
    //                    using (NetworkStream networkStream = tcpClient.GetStream())
    //                    {
    //                        byte[] buffer = Encoding.UTF8.GetBytes(message.Text);
    //                        networkStream.Write(buffer, 0, buffer.Length);
    //                    }
    //                }
    //            }
    //            catch(Exception e)
    //            {
    //                MessageBox.Show(e.Message);
    //            }
    //            button.BeginInvoke(new Action(()=> { button.Enabled = true; }));
    //        });
    //    }
    //}

    public class Client
    {
        public async void Go(TextBox address, TextBox message, Button button)
        {
            using (var tcpClient = new TcpClient())
            {
                await tcpClient.ConnectAsync(address.Text, 2001);

                using (NetworkStream networkStream = tcpClient.GetStream())
                {
                    byte[] buffer = Encoding.UTF8.GetBytes(message.Text);
                    networkStream.Write(buffer, 0, buffer.Length);
                }
            }
            button.Enabled = true;
        }
    }

    public class Server
    {
        public async void Go(TextBox textBox)
        {
            TcpListener tcpListener = new TcpListener(IPAddress.Any, 2001);
            tcpListener.Start();

            using (var tcpClient = await tcpListener.AcceptTcpClientAsync())
            {
                tcpListener.Stop();

                using (NetworkStream networkStream = tcpClient.GetStream())
                {
                    byte[] buffer = new byte[1024];
                    string message = "";

                    do
                    {
                        int byteSize = networkStream.Read(buffer, 0, buffer.Length);
                        message += Encoding.UTF8.GetString(buffer, 0, byteSize);

                    } while (networkStream.DataAvailable);
                    textBox.Text += message + "\r\n";
                }
            }
            Go(textBox);
        }
    }
}

using System;

using System.Text;

using System.Net;

using System.Net.Sockets;

using System.Windows.Forms;

namespace TestChat

{

public partial class Form2 : Form

{

public Form2()

{

InitializeComponent();

new Server().Go(textBox1);

button2.Click += new EventHandler((object sender, EventArgs e) => {

button2.Enabled = false;

new Client().Go(textBox3,textBox2,button2);

});

}

//public class Client

//{

// public async void Go(TextBox address, TextBox message, Button button)

// {

// await Task.Run(()=> {

// try

// {

// using (var tcpClient = new TcpClient(address.Text, 2001))

// {

// tcpClient.ReceiveTimeout = 100;

// using (NetworkStream networkStream = tcpClient.GetStream())

// {

// byte[] buffer = Encoding.UTF8.GetBytes(message.Text);

// networkStream.Write(buffer, 0, buffer.Length);

// }

// catch(Exception e)

// {

// MessageBox.Show(e.Message);

// }

// button.BeginInvoke(new Action(()=> { button.Enabled = true; }));

// });

// }

//}

public class Client

{

public async void Go(TextBox address, TextBox message, Button button)

{

using (var tcpClient = new TcpClient())

{

await tcpClient.ConnectAsync(address.Text, 2001);

using (NetworkStream networkStream = tcpClient.GetStream())

{

byte[] buffer = Encoding.UTF8.GetBytes(message.Text);

networkStream.Write(buffer, 0, buffer.Length);

}

button.Enabled = true;

}

public class Server

{

public async void Go(TextBox textBox)

{

TcpListener tcpListener = new TcpListener(IPAddress.Any, 2001);

tcpListener.Start();

using (var tcpClient = await tcpListener.AcceptTcpClientAsync())

{

tcpListener.Stop();

using (NetworkStream networkStream = tcpClient.GetStream())

{

byte[] buffer = new byte[1024];

string message = "";

{

int byteSize = networkStream.Read(buffer, 0, buffer.Length);

message += Encoding.UTF8.GetString(buffer, 0, byteSize);

} while (networkStream.DataAvailable);

textBox.Text += message + "\r\n";

}

Go(textBox);

}

C# UDPを使ったメッセージ交換

UDPを使ったテストプログラム。

using System;
using System.Text;
using System.Linq;
using System.Collections.Generic;
using System.Windows.Forms;
using System.Net;
using System.Net.Sockets;

namespace TestChat
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();

            StartReceive();
            button1.Click += new EventHandler(SendMessage);
        }

        public class UdpState
        {
            public UdpClient UdpClient;
            public IPEndPoint IPEndPoint;
            public UdpState(UdpClient udpClient, IPEndPoint endPoint)
            {
                UdpClient = udpClient;
                IPEndPoint = endPoint;
            }
        }

        public class Message
        {
            private List<string> TextList = new List<string>();
            private static Message Instance = null;

            public static Message GetInstance()
            {
                if(Instance == null)
                {
                    Instance = new Message();
                }
                return Instance;
            }

            public void SetMessage(string text)
            {
                TextList.Add(text);
            }

            public string GetMessage()
            {
                return string.Join("\r\n", TextList.ToArray().Reverse());
            }

        }

        private void StartReceive()
        {
            IPEndPoint endPoint = new IPEndPoint(IPAddress.Any, 2002);
            UdpClient udpClient = new UdpClient(endPoint);
            udpClient.BeginReceive(ReceiveCallback, new UdpState(udpClient, endPoint));
        }

        private void ReceiveCallback(IAsyncResult ar)
        {
            UdpClient udpClient = ((UdpState)ar.AsyncState).UdpClient;
            IPEndPoint endPoint = ((UdpState)ar.AsyncState).IPEndPoint;

            byte[] receiveByte = udpClient.EndReceive(ar,ref endPoint);
            string receiveString = Encoding.UTF8.GetString(receiveByte);
            textBox1.BeginInvoke(new Action<string>(ShowReceive), receiveString);

            udpClient.BeginReceive(ReceiveCallback, new UdpState(udpClient, endPoint));
        }

        private void ShowReceive(string s)
        {
            Message message = Message.GetInstance();
            message.SetMessage(s);
            textBox1.Text = message.GetMessage();
        }

        private async void SendMessage(object sender, EventArgs e)
        {
            UdpClient udpClient = new UdpClient();
            udpClient.Connect(new IPEndPoint(IPAddress.Parse("192.168.11.18"), 2002));

            byte[] sendByte = Encoding.UTF8.GetBytes(textBox2.Text);
            await udpClient.SendAsync(sendByte, sendByte.Length);
            udpClient.Close();
        }
    }
}

using System;

using System.Text;

using System.Linq;

using System.Collections.Generic;

using System.Windows.Forms;

using System.Net;

using System.Net.Sockets;

namespace TestChat

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

StartReceive();

button1.Click += new EventHandler(SendMessage);

}

public class UdpState

{

public UdpClient UdpClient;

public IPEndPoint IPEndPoint;

public UdpState(UdpClient udpClient, IPEndPoint endPoint)

{

UdpClient = udpClient;

IPEndPoint = endPoint;

}

public class Message

{

private List<string> TextList = new List<string>();

private static Message Instance = null;

public static Message GetInstance()

{

if(Instance == null)

{

Instance = new Message();

}

return Instance;

}

public void SetMessage(string text)

{

TextList.Add(text);

}

public string GetMessage()

{

return string.Join("\r\n", TextList.ToArray().Reverse());

}

private void StartReceive()

{

IPEndPoint endPoint = new IPEndPoint(IPAddress.Any, 2002);

UdpClient udpClient = new UdpClient(endPoint);

udpClient.BeginReceive(ReceiveCallback, new UdpState(udpClient, endPoint));

}

private void ReceiveCallback(IAsyncResult ar)

{

UdpClient udpClient = ((UdpState)ar.AsyncState).UdpClient;

IPEndPoint endPoint = ((UdpState)ar.AsyncState).IPEndPoint;

byte[] receiveByte = udpClient.EndReceive(ar,ref endPoint);

string receiveString = Encoding.UTF8.GetString(receiveByte);

textBox1.BeginInvoke(new Action<string>(ShowReceive), receiveString);

udpClient.BeginReceive(ReceiveCallback, new UdpState(udpClient, endPoint));

}

private void ShowReceive(string s)

{

Message message = Message.GetInstance();

message.SetMessage(s);

textBox1.Text = message.GetMessage();

}

private async void SendMessage(object sender, EventArgs e)

{

UdpClient udpClient = new UdpClient();

udpClient.Connect(new IPEndPoint(IPAddress.Parse("192.168.11.18"), 2002));

byte[] sendByte = Encoding.UTF8.GetBytes(textBox2.Text);

await udpClient.SendAsync(sendByte, sendByte.Length);

udpClient.Close();

}

C# PC情報取得

PC名、ユーザー名、インストール済みアプリ、ネットワーク情報を取得

using System;
using System.Collections.Generic;
using System.Windows.Forms;

using System.Net.NetworkInformation;

namespace PC情報
{
    static class Program
    {
        /// <summary>
        /// アプリケーションのメイン エントリ ポイントです。
        /// </summary>
        [STAThread]
        static void Main()
        {
            //Application.EnableVisualStyles();
            //Application.SetCompatibleTextRenderingDefault(false);
            //Application.Run(new Form1());

            using (System.IO.StreamWriter sw = new System.IO.StreamWriter(Application.StartupPath + @"\info.txt",false,System.Text.Encoding.GetEncoding("sjis")))
            {
                sw.Write(GetRegDisplayName(@"SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall") + "\n\n");
                sw.Write(GetRegDisplayName(@"SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall") + "\n\n");
                sw.Write(GetNicInfo());
                sw.Write("OS Name: " + GetOsType() + "\n\n");
                sw.Write("OS Version: " + Environment.OSVersion.ToString() + "\n\n");
                sw.Write("OS Bit: " + (Environment.Is64BitOperatingSystem ? "64bit" : "32bit") + "\n\n");
                sw.Write("PC Name: " + Environment.MachineName + "\n\n");
                sw.Write("User Name: " + Environment.UserName);
            }
            MessageBox.Show("終了しました。");
        }

        static string GetOsType()
        {
            const string Path = @"SOFTWARE\Microsoft\Windows NT\CurrentVersion";
            var key = Microsoft.Win32.Registry.LocalMachine.OpenSubKey(Path, false);
            return (string)key.GetValue("ProductName", "", Microsoft.Win32.RegistryValueOptions.DoNotExpandEnvironmentNames);
        }

        static string GetNicInfo()
        {
            string infoString = "";
            foreach (NetworkInterface interfaces in NetworkInterface.GetAllNetworkInterfaces())
            {
                if (interfaces.OperationalStatus != OperationalStatus.Up) continue;

                foreach(var unicast in interfaces.GetIPProperties().UnicastAddresses)
                {
                    if(unicast.Address.AddressFamily == System.Net.Sockets.AddressFamily.InterNetwork)
                    {
                        infoString += "NIC Name: " + interfaces.Name + "\n" +
                        "MAC Address: " + interfaces.GetPhysicalAddress() + "\n" +
                        "IP Address: " + unicast.Address + "\n\n";
                    }
                }

            }
            return infoString;
        }

        static string GetRegDisplayName(string regPath)
        {
            Microsoft.Win32.RegistryKey targetReg = Microsoft.Win32.Registry.LocalMachine.OpenSubKey(regPath, false);
            if (targetReg == null) return "";

            List<string> displayNameList = new List<string>();
            foreach (string subKey in targetReg.GetSubKeyNames())
            {
                Microsoft.Win32.RegistryKey appkey = Microsoft.Win32.Registry.LocalMachine.OpenSubKey(regPath + "\\" + subKey, false);
                if (appkey.GetValue("DisplayName") == null) continue;

                displayNameList.Add(appkey.GetValue("DisplayName").ToString());
            }
            return string.Join("\n", displayNameList.ToArray());
        }
    }
}

using System;

using System.Collections.Generic;

using System.Windows.Forms;

using System.Net.NetworkInformation;

namespace PC情報

{

static class Program

{

/// <summary>

/// アプリケーションのメインエントリポイントです。

/// </summary>

[STAThread]

static void Main()

{

//Application.EnableVisualStyles();

//Application.SetCompatibleTextRenderingDefault(false);

//Application.Run(new Form1());

using (System.IO.StreamWriter sw = new System.IO.StreamWriter(Application.StartupPath + @"\info.txt",false,System.Text.Encoding.GetEncoding("sjis")))

{

sw.Write(GetRegDisplayName(@"SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall") + "\n\n");

sw.Write(GetRegDisplayName(@"SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall") + "\n\n");

sw.Write(GetNicInfo());

sw.Write("OS Name: " + GetOsType() + "\n\n");

sw.Write("OS Version: " + Environment.OSVersion.ToString() + "\n\n");

sw.Write("OS Bit: " + (Environment.Is64BitOperatingSystem ? "64bit" : "32bit") + "\n\n");

sw.Write("PC Name: " + Environment.MachineName + "\n\n");

sw.Write("User Name: " + Environment.UserName);

}

MessageBox.Show("終了しました。");

}

static string GetOsType()

{

const string Path = @"SOFTWARE\Microsoft\Windows NT\CurrentVersion";

var key = Microsoft.Win32.Registry.LocalMachine.OpenSubKey(Path, false);

return (string)key.GetValue("ProductName", "", Microsoft.Win32.RegistryValueOptions.DoNotExpandEnvironmentNames);

}

static string GetNicInfo()

{

string infoString = "";

foreach (NetworkInterface interfaces in NetworkInterface.GetAllNetworkInterfaces())

{

if (interfaces.OperationalStatus != OperationalStatus.Up) continue;

foreach(var unicast in interfaces.GetIPProperties().UnicastAddresses)

{

if(unicast.Address.AddressFamily == System.Net.Sockets.AddressFamily.InterNetwork)

{

infoString += "NIC Name: " + interfaces.Name + "\n" +

"MAC Address: " + interfaces.GetPhysicalAddress() + "\n" +

"IP Address: " + unicast.Address + "\n\n";

}

return infoString;

}

static string GetRegDisplayName(string regPath)

{

Microsoft.Win32.RegistryKey targetReg = Microsoft.Win32.Registry.LocalMachine.OpenSubKey(regPath, false);

if (targetReg == null) return "";

List<string> displayNameList = new List<string>();

foreach (string subKey in targetReg.GetSubKeyNames())

{

Microsoft.Win32.RegistryKey appkey = Microsoft.Win32.Registry.LocalMachine.OpenSubKey(regPath + "\\" + subKey, false);

if (appkey.GetValue("DisplayName") == null) continue;

displayNameList.Add(appkey.GetValue("DisplayName").ToString());

}

return string.Join("\n", displayNameList.ToArray());

}

WSLと.NET Coreの環境

WSLのインストール

optionalfeaturesにて、Windows Subsystem for Linuxを有効化。

設定＞更新とセキュリティ＞開発者向けにて、開発モードを選択。

Microsoft Storeアプリでディストリビューションをインストール。

最初の起動でユーザー名とパスワードを決める。

sudo apt-get update
sudo apt-get install gcc

起動用ショートカット
SET HOME=%~dp0
bash.exe

WSLに.NET Coreをインストール

https://www.microsoft.com/net/learn/get-started/linux/ubuntu16-04
を参考にする。

wget https://packages.microsoft.com/config/ubuntu/16.04/packages-microsoft-prod.deb

sudo dpkg -i packages-microsoft-prod.deb

インストール有無の確認
sudo apt-cache policy apt-transport-https
必要なら、
sudo apt-get install apt-transport-https

sudo apt-get install dotnet-sdk-2.1

通常の使い方

アプリ作成
dotnet new console -o myapp

実行
dotnet run
(myappの中で実行)

Visual Studioでプロジェクト作成

Visual Studioから、
ASP.NET Core Webのプロジェクトを作成する。

プロジェクトの右クリックから発行をして、WSL側のフォルダに保存。

転送フォルダにて、
dotnet WebApplication1.dll
を実行

an assembly specified in the application dependencies manifest…
とエラーがでた。

プロジェクトの右クリックから、
csprojを編集する。

以下の部分のVersionをubuntu側に合わせる。
<PackageReference Include=”Microsoft.AspNetCore.All” Version=”2.1.2″ />

dotnet –info
でバージョン確認できる。

.NET Core runtimes installed
の部分のバージョンを見る。

dotnet WebApplication1.dll
で実行。

自動起動

WSLなので.profileに入れてプロセスと同時に立ち上げる。

/usr/bin/dotnet /mnt/g/Dropbox/Workspace/Bash/html/WebApplication1.dll > /dev/null 2>&1 &

VBA 行数確認

全シート力技でループしていて随分時間がかかるなってとき。

Sub test()

For Each w In Sheets

Debug.Print w.Name, w.UsedRange.Rows.Count

Next w

End Sub

Sub test()

For Each w In Sheets

Debug.Print w.Name, w.UsedRange.Rows.Count

Next w

End Sub

C# エンコードオブジェクト取得

メソッド
System.Text.Encoding.GetEncoding(“utf-8”)

静的プロパティ
System.Text.Encoding.UTF8

コンストラクタ
new System.Text.UTF8Encoding(false)
ASCIIとUnicodeは、Encodingクラスから派生した専用クラスがあり、falseにするとBOM無しにすることができる。

UbuntuをLiveCDから起動

もしsshがなければ、
sudo apt-get install openssh-server

起動する。
/etc/init.d/ssh start

パスワードが空なので、
passwd

パスワードを指定したらTeraTermなどでログインする。
ユーザー名はubuntuとなっている。

Docker基礎

ちょっとだけ触ってみた。

Docker for Windowsをインストールする。

ダウンロード
docker pull ubuntu:latest

一覧
docker images

実行
docker run -it –name ubunt1 ubuntu /bin/bash
※ubuntu1はコンテナ、ubuntuはイメージ

ポートをマッピングできる
docker run -it -p 81:80 aaa /bin/bash

何かインストール
apt-get update
apt-get install vim
apt-get install apache2

コンテナ停止
docker stop
※Ctrl+Dでbashプロセスを止めると、コンテナも停止する。

コンテナ一覧
docker ps -a

新しいイメージの作成
docker commit ubuntu1 ubuntu2

コンテナ再実行(イメージではない)
docker start -i ubuntu1

コンテナ削除
docker rm

イメージ削除
docker rmi

テックメモ

当ブログは自分用のメモです。昔のメモをそのまま移行しただけの記事もあり一部不正確な記述もあります。

C# Xamarin サンプル色々

C# 定期的にコマンド実行

C# TCPを使ったサンプル

C# UDPを使ったメッセージ交換

C# PC情報取得

WSLと.NET Coreの環境

WSLのインストール

WSLに.NET Coreをインストール

通常の使い方

Visual Studioでプロジェクト作成

自動起動

VBA 行数確認

C# エンコードオブジェクト取得

UbuntuをLiveCDから起動

Docker基礎