学习笔记

摘要： 窗体 ' '->Forms ' Module ' ClassModules ' Option Explicit Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As Str 阅读全文

摘要： 模版表名Template sheet25 数据列表名sheet1 打印程序 Sub PrintLabel() With ThisWorkbook.Sheets("Sheet1") limitmax = .Range("B10000").End(xlUp).Row For i = 2 To limit 阅读全文

摘要： import pandas as pd import pyodbc import time # 文件路径及文件名 mdb_file = r"X:\xxx.accdb" driver = '{Microsoft Access Driver (*.mdb, *.accdb)}' cnxn = pyodb 阅读全文

摘要： Server: import socket # 创建socket tcp_server_socket = socket.socket(socket.AF_INET, socket.SOCK_STREAM) # 本地信息 address = ('服务器ip', 3000) # 绑定 tcp_serve 阅读全文

摘要： Sub GetSheetName() Dim Path As String Dim File As String Dim WB As Workbook Dim sht As Worksheet Dim arr() As String Dim narr() As String Application. 阅读全文

摘要： Sub GetSheetName() Dim Path As String Dim File As String Dim WB As Workbook Dim sht As Worksheet Application.ScreenUpdating = False Path = ThisWorkboo 阅读全文

摘要： Sub compact_code() On Error Resume Next Dim Element As Object For Each Element In ActiveWorkbook.VBProject.VBComponents ActiveWorkbook.VBProject.VBCom 阅读全文

摘要： 用vim新建一个python文件后，如pw.py，会自动填写文件头部，如： # !/usr/bin/env python # -*- coding: utf-8 -*- # Pw @ 2013-04-15 17:26:33 将以下代码加入／etc/vim/vimrc文件： function Head 阅读全文

摘要： Demo.py from apps import create_app app=create_app() if __name__== '__main__': app.run(app.config['HOST'],app.config['PORT'],app.config['DEBUG'],threa 阅读全文

摘要： import sys from sqlalchemy import create_engine from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import Column, Integer, String 阅读全文