波少散记

I have finally fixed it! The issue was the DST Root CA X3 cross-sign has expired To fix it on debian: run sudo dpkg-reconfigure ca-certificates uncheck mozilla/DST_Root_CA_X3.crt OK

apt-get update apt-get upgrade apt-get dist-upgrade Upgrade from Debian Jessie 8 to Debian 9 nano /etc/apt/sources.list deb http://httpredir.debian.org/debian stretch main contrib non-free deb http://httpredir.debian.org/debian stretch-updates main contrib non-free deb http://security.debian.org stretch/updates main contrib non-free apt-get update apt-get upgrade apt-get dist-upgrade cat /etc/os-release apt-get autoremove debian 9升级到debian 10 apt-get update && apt-get upgrade sed -i 's/stretch/buster/g' /etc/apt/sources.list apt-get update && apt-get upgrade apt-get dist-upgrade reboot lsb_release -a

方法一： 把所有EXCEL文件复制到同一目录下， 然后新建excel文件，在一个工作表格中 点击查看代码，把下面代码复制到文本框运行，即合并成功 ----------------------代码开始-------------------------------------------------- Sub 合并当前目录下所有工作簿的全部工作表() Dim MyPath, MyName, AWbName Dim Wb As workbook, WbN As String Dim G As Long Dim Num As Long Dim BOX As String Application.ScreenUpdating = False MyPath = ActiveWorkbook.Path MyName = Dir(MyPath & "\" & "*.xls") AWbName = ActiveWorkbook.Name Num = 0 Do While MyName <> "" If MyName <> AWbName Then Set Wb = Workbooks.Open(MyPath & "\" & MyName) Num = Num + 1 With Workbooks(1).ActiveSheet .Cells(.Range("B65536").End(xlUp).Row + 2, 1) = Left(MyName, Len(MyName) - 4) For G = 1 To Sheets.Count Wb.Sheets(G).UsedRange.Copy .Cells(.Range("B65536").End(xlUp).Row + 1, 1) Next WbN = WbN & Chr(13) & Wb.Name Wb.Close False End With End If MyName = Dir Loop Range("B1").Select Application.ScreenUpdating = True MsgBox "共合并...

安装中如果无法找到源，使用SOHU镜像源最好； apt update中出现问题 使用rm -r /var/cache/apt /var/lib/apt/lists 删除再更新 加入源好安装shadowsocks-libev  create /etc/apt/sources.list.d/jessie-backports.list deb http://archive.debian.org/debian jessie-backports main deb http://archive.debian.org/debian jessie-backports-sloppy main apt-get update -o Acquire::Check-Valid-Until=false  apt-get install shadowsocks-libev the -o Acquire::Check-Valid-Until=false is the key information. Hope it is helpful. 将内核更新至4.9以上 apt-cache search linux-image apt-get install -t jessie-backports linux-image-amd64 update-grub apt-get autoclean apt-get autoremove reboot dpkg -l|grep linux-image apt-get purge 开启bbr modprobe tcp_bbr echo "tcp_bbr" >> /etc/modules-load.d/modules.conf echo "net.core.default_qdisc=fq" >> /etc/sysctl.conf echo "net.ipv4.tcp_congestion_control=bbr" >> /etc/sysctl.conf 执行这个保存生效更改。 sysctl -p VPS提示： net.core.default_qdisc = fq net.ipv4.tcp_congestion_control = bb...