摘要: #![windows_subsystem = "windows"]mod cmd;mod excel;use druid::kurbo::{BezPath, Circle, Line};use druid::piet::RenderContext;use druid::widget::{ prelu 阅读全文
posted @ 2024-05-28 13:49 aimoss 阅读(100) 评论(0) 推荐(0)
摘要: extern crate simple_excel_writer as excel; use excel::*; fn main() -> Result<(), Box<dyn std::error::Error>> { let url: &str = "http://94.push2.eastmo 阅读全文
posted @ 2023-12-28 08:48 aimoss 阅读(124) 评论(0) 推荐(0)
摘要: print("数据来源:东方财富网-行情中心-沪深京A股")import re,requestsimport pandas as pdurl = "http://94.push2.eastmoney.com/api/qt/clist/get?cb=jQuery11240403998741793111 阅读全文
posted @ 2023-06-02 09:44 aimoss 阅读(909) 评论(0) 推荐(0)
摘要: 1、提取文件名DIR C:\Users\admin\Desktop\数据/b > C:\Users\admin\Desktop\temp.xls 2、EXCEL:=IF(A2=A3,B2&"\"&C3,B2)=COUNTIF($A$2:$A2,A2) 3、笔记本双路由添加 route add -p 阅读全文
posted @ 2022-10-20 23:48 aimoss 阅读(139) 评论(0) 推荐(0)
摘要: #同一文件夹下多工作簿内多sheet合并,且末列写入工作簿名称#注意:xlrd==1.2.0print("* * * * * *正在处理请稍后 * * * * * *\n")# -*- coding: utf-8 -*-import os,xlrd,xlsxwriterfilePath = r'C: 阅读全文
posted @ 2021-12-14 05:50 aimoss 阅读(72) 评论(0) 推荐(0)
摘要: [dependencies]itertools = "0.10.5"calamine = "0.19.1"simple_excel_writer = "0.2.0" use std::time::Instant;use itertools::Itertools;use std::collection 阅读全文
posted @ 2021-12-07 10:00 aimoss 阅读(393) 评论(0) 推荐(0)
摘要: import osimport openpyxlimport pandas as pdfrom win32com.client import Dispatchdf = pd.DataFrame(pd.read_excel(r'C:\Users\xoadmin\Desktop\name.xlsx',s 阅读全文
posted @ 2021-09-29 17:34 aimoss 阅读(204) 评论(0) 推荐(0)
摘要: import pandas as pdimport openpyxlfrom openpyxl.styles import Font#字体模块from openpyxl.styles import PatternFill#导入填充模块df = pd.DataFrame(pd.read_excel(r 阅读全文
posted @ 2021-09-25 22:24 aimoss 阅读(256) 评论(0) 推荐(0)
摘要: //.xaml文件 <Window x:Class="WpfApp1.MainWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com 阅读全文
posted @ 2021-08-01 17:54 aimoss 阅读(806) 评论(0) 推荐(0)