Skip to content

Instantly share code, notes, and snippets.

@naonao0001777
Last active February 19, 2021 05:13
Show Gist options
  • Save naonao0001777/d6893a25696f93b526daf26b19e4e702 to your computer and use it in GitHub Desktop.
Save naonao0001777/d6893a25696f93b526daf26b19e4e702 to your computer and use it in GitHub Desktop.
実験

入力した文字をASCIIに変換する

using System;

namespace CharConvertAscii
{
    class Program
    {
        static void Main(string[] args)
        {
            string castCharStr = string.Empty;

            string convertCharStr = string.Empty;

            // char型キャスト⇒ASCII 入力
            Console.WriteLine("(char)キャスト⇒ASCII");
            Console.Write("入力:");
            castCharStr = Console.ReadLine();

            // char型コンバート⇒ASCII 入力
            Console.WriteLine("Convert.ToChar()⇒ASCII");
            Console.Write("入力:");
            convertCharStr = Console.ReadLine();


            // char型キャスト⇒ASCII 変換
            castCharStr += ((char)64).ToString() + ((char)48).ToString() + ((char)64).ToString();

            // char型コンバート⇒ASCII 変換
            convertCharStr += Convert.ToChar(64).ToString() + Convert.ToChar(48).ToString() + Convert.ToChar(64).ToString();


            // char型キャスト⇒ASCII 出力
            Console.WriteLine("(char)キャスト⇒ASCII");
            Console.Write("出力:");
            Console.WriteLine(castCharStr);

            // char型コンバート⇒ASCII 出力
            Console.WriteLine("Convert.ToChar()⇒ASCII");
            Console.Write("出力:");
            Console.WriteLine(convertCharStr);

            Console.ReadKey();
        }
    }
}

Excelのバッチみたいなのを作ろうとした

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Microsoft.Office.Interop.Excel;
using System.IO;

namespace ExcelBatch
{
	class Program
	{
		static void Main(string[] args)
		{
			var xlApp = new Application();
			try
			{
				string directry = System.Configuration.ConfigurationManager.AppSettings["ExcelDirectry"];

				directry += "/";

				DirectoryInfo d = new DirectoryInfo(directry);

				FileInfo[] files = d.GetFiles("*.xlsx", SearchOption.TopDirectoryOnly);
				Console.WriteLine("【↓↓↓↓プログラム開始↓↓↓↓】");

				foreach (var file in files)
				{


					Workbooks xlBooks = null;
					Workbook xlBook = null;

					Sheets xlSheets = null;
					Worksheet xlSheet = null;
					Range xlCells = null;
					Range xlRange = null;

					xlBooks = xlApp.Workbooks;

					Console.WriteLine(file);
					xlBook = xlBooks.Open(Path.GetFullPath(Path.Combine(directry, file.ToString())));
					xlSheets = xlBook.Worksheets;
					
					for (int i = 1; i < xlSheets.Count; i++)
					{
						xlSheet = xlSheets[i];
						xlCells = xlSheet.Cells;
						xlRange = xlCells[1, 1];
						xlRange.Value = "";
					}

					// Sheetを解放
					System.Runtime.InteropServices.Marshal.ReleaseComObject(xlSheet);
					System.Runtime.InteropServices.Marshal.ReleaseComObject(xlSheets);

					// Bookを解放
					System.Runtime.InteropServices.Marshal.ReleaseComObject(xlBook);
					System.Runtime.InteropServices.Marshal.ReleaseComObject(xlBooks);

				}
			}
			catch (Exception e)
			{
				string errorMessage = e.Message;
				Console.WriteLine(errorMessage);
			}
			finally
			{
				// Excelアプリケーションを解放
				System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp);
				Console.WriteLine("【↑↑↑↑プログラム終了↑↑↑↑】");

				Console.ReadKey(true);
			}

		}
	}
}

PSをPDFに変換する系の処理を実験

using System;
using System.IO;
using System.Runtime.InteropServices;

namespace ps2pdf
{
    class Program
    {
        internal enum ErrorCodes
        {
            SUCCESS
        }

        [DllImport("ps2pdfsdk.dll")]
        internal static extern int VeryPDF_PSToPDF(string strCommandLine);

        static void Main(string[] args)
        {
            Console.WriteLine("PS⇒PDF");

            Console.ReadKey(true);

            PDF2PS("C:\\Users\\XXXXXX\\Downloads\\ps2pdfsdk\\test.pdf");

            Console.ReadKey(true);
        }
        /// <summary>
        /// Converts PDF File to PS
        /// </summary>
        /// <param name="pdfFile">PDF File Name</param>
        /// <param name="psFile">PS File Name</param>
        public static void PDF2PS(string pdfFile, string psFile)
        //public static void PDF2PS(string pdfFile, string psFile, int pagecount)
        {
            if (!File.Exists(pdfFile))
                throw new Exception("PDF File: " + pdfFile + " not found");

            string strCmd = string.Empty;
            int nRet;

            //strCmd = "C:\\Users\\XXXXXX\\Downloads\\ps2pdfsdk\\bin";

            strCmd = "ps2pdf -$ merge -pdf2ps " +
                    "\"" + pdfFile + "\" " +
                    "\"" + psFile + "\" ";


            nRet = VeryPDF_PSToPDF(strCmd);

            if ((ErrorCodes)nRet != ErrorCodes.SUCCESS)
                throw new Exception("Unable to convert File: " + pdfFile);
        }

        /// <summary>
        /// Converts PDF File to PS
        /// </summary>
        /// <param name="pdfFile">PDF File Name</param>
        public static void PDF2PS(string pdfFile)
        //public static void PDF2PS(string pdfFile, int pagecount)
        {
            string path = Path.GetDirectoryName(pdfFile);
            string psFile = Path.Combine(path, Path.GetFileNameWithoutExtension(pdfFile) + ".ps");
            PDF2PS(pdfFile, psFile);
        }
    }
}

StringBuilder型をString型に変換する際の制約を調べる

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace StringBuilderConverseToString
{
    class Program
    {
        static void Main(string[] args)
        {
            StringBuilder sb = new StringBuilder(5);

            string st = sb.ToString();

            string input = Console.ReadLine();

            sb.Append(input);
            
            Console.WriteLine(sb);
            Console.ReadKey(true);
        }
    }
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment