excel에 첨부된 이미지 추출.

# -*-coding:utf-8-*-

from openpyxl import load_workbook
from openpyxl_image_loader import SheetImageLoader


def main():
    filepath = './excel/sample.xlsx'
    load_wb = load_workbook(filepath, data_only=True)
    for sheet_name in load_wb.sheetnames:
        sheet = load_wb[sheet_name]

        image_loader = SheetImageLoader(sheet)
        # image = image_loader.get('C3')
        # image.show()
        print(sheet.max_row, sheet.max_column)
        for column in range(sheet.max_column):
            column = chr(ord('A') + column)
            for row in range(sheet.max_row):
                cell_id = '{0}{1}'.format(column, row)
                print(cell_id)
                if image_loader.image_in(cell_id):
                    print(cell_id, '->', image_loader.image_in(cell_id))


if __name__ == '__main__':
    main()

Ubuntu 에 python3 설치

sudo apt install software-properties-common
sudo add-apt-repository ppa:deadsnakes/ppa
sudo apt install python3.7
sudo apt install python3-pip
sudo apt install python3-venv
sudo apt install python3-dev

sudo apt install software-properties-common
sudo add-apt-repository ppa:deadsnakes/ppa
sudo apt install python3.7
sudo apt install python3-pip
sudo apt install python3-venv
sudo apt install python3-dev



pip3 install --upgrade tensorflow requests


python3

import tensorflow as tf
hello = tf.constant('Hello, TensorFlow!')
sess = tf.Session()
print(sess.run(hello))


mkdir tensorflow
cd tensorflow
git clone https://github.com/tensorflow/models.git
export PYTHONPATH="$PYTHONPATH:$(pwd)/models"
cd models/official/r1/mnist
python3 mnist.py

pip3 show tensorflow
Name: tensorflow
Version: 1.14.0
Summary: TensorFlow is an open source machine learning framework for everyone.
Home-page: https://www.tensorflow.org/
Author: Google Inc.
Author-email: packages@tensorflow.org
License: Apache 2.0
Location: /home/xxx/.local/lib/python3.6/site-packages
Requires: astor, protobuf, termcolor, gast, numpy, google-pasta, absl-py, six, tensorflow-estimator, tensorboard, keras-applications, wrapt, wheel, grpcio, keras-preprocessing

cd /home/xxx/.local/lib/python3.6/site-packages/tensorboard


python3 main.py --logdir=/tmp/log_file

ufw allow 6006

http://x.x.x.x:6006

[C#] 압축 해제

class Program
{
    static void Main(String[] args)
    {
        string zipPath = "...";
        string extractPath = Path.GetFullPath("...");

        System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);
        System.Text.Encoding euckr = System.Text.Encoding.GetEncoding(949);

        ZipFile.ExtractToDirectory(zipPath, extractPath, euckr);
    }
}

[PyQt5] QTableWidget 에서 row 구하기

for model_index in self.tableWidget.selectionModel().selectedRows():
row = model_index.row()

[Python] python 으로 프로그램 목록 구하기

import win32com.client 
strComputer = "." 
objWMIService = win32com.client.Dispatch("WbemScripting.SWbemLocator") 
objSWbemServices = objWMIService.ConnectServer(strComputer,"root\cimv2") 
colItems = objSWbemServices.ExecQuery("Select * from Win32_Product") 
for objItem in colItems: 
    print "Caption: ", objItem.Caption 
    print "Description: ", objItem.Description 
    print "Identifying Number: ", objItem.IdentifyingNumber 
    print "Install Date: ", objItem.InstallDate 
    print "Install Date 2: ", objItem.InstallDate2 
    print "Install Location: ", objItem.InstallLocation 
    print "Install State: ", objItem.InstallState 
    print "Name: ", objItem.Name 
    print "Package Cache: ", objItem.PackageCache 
    print "SKU Number: ", objItem.SKUNumber 
    print "Vendor: ", objItem.Vendor 
    print "Version: ", objItem.Version 

[Python] 관리자 모드인지 확인

>>> import ctypes
>>> ctypes.windll.shell32.IsUserAnAdmin()

virtualbox 공유폴더

virtualbox 에 Ubuntu 설치 후 공유롤더 설정

cd /media/
sudo gpasswd -a [id] vboxsf