GPM合并资料整理-GEM部分

2024-01-11 08:12
文章标签 整理 资料 部分 合并 gpm gem

本文主要是介绍GPM合并资料整理-GEM部分，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

一、性能数据上报项

1. CPU模块

上报键值说明采集平台
cpu当前进程cpu使用率平均值Android & iOS
totcpu系统cpu总使用率平均值Android & iOS
cpu_temp_maxcpu最高温度Android
cpu_temp_avgcpu温度平均值Android
gpu_temp_avggpu温度平均值Android
gpu_temp_maxgpu最高温度Android
gpugpu使用率平均值Android
gpu_modelgpu型号Android
cpu_modelcpu型号Android
cpu_corecpu核心数Android
cpu_freqcpu最大时钟频率Android

2. memory及存储模块

上报键值说明采集平台
mem当前进程内存使用量平均值Android & iOS
availmem当前设备可用内存量平均值Android & iOS
max_mem内存使用量最大值Android & iOS
start_mem开始对局时内存使用量Android & iOS
end_mem结束对局时内存使用量Android & iOS
totalmem当前设备总内存量Android & iOS
total_storage当前设备总存储空间大小Android & iOS
free_storage当前设备可用存储空间大小Android & iOS

3. 网卡模块

上报键值说明采集平台
wsndpkt无线网卡发包总数Android & iOS
wrcvpkt无线网卡收包总数Android & iOS
wsnddrop无线网卡发包丢包Android & iOS
wrcvdrop无线网卡收包丢包Android & iOS
wsnderr无线网卡发包错包Android & iOS
wrcverr无线网卡收包错包Android & iOS
msndpkt移动网卡发包总数Android & iOS
mrcvpkt移动网卡收包总数Android & iOS
msnddrop移动网卡发包丢包Android & iOS
mrcvdrop移动网卡收包丢包Android & iOS
msnderr移动网卡发包错包Android & iOS
mrcverr移动网卡收包错包Android & iOS

4. FPS模块

上报键值说明采集平台
fminfps最小值Android & iOS
fmaxfps最大值Android & iOS
favgfps平均值Android & iOS
fheavyfps严重抖动个数（本次fps值比上次fps值低10以上）Android & iOS
flightfps轻微抖动个数（本次fps值比上次fps值低4以上，10以下）Android & iOS
ftotalfps采集总个数Android & iOS
fcntx0fps自定义抖动个数（阈值由云控下发）Android & iOS
lfps1低于云控下发的lfps1阈值的个数Android & iOS
lfps2低于云控下发的lfps2阈值的个数Android & iOS
lfps3低于云控下发的lfps3阈值的个数Android & iOS

5. 电量模块

上报键值说明采集平台
battery电量消耗（开始-结束）Android & iOS
start_battery开始对局时电量值Android & iOS
end_battery结束对局时电量值Android & iOS
bs对局过程中是否有充电操作Android & iOS
bt电池温度平均值Android
max_battery_temp电池温度最大值Android

6. 网络相关模块

上报键值说明采集平台
netflow流量消耗Android & iOS
devices当前wifi下连接设备数Android & iOS
wifi_numwifi个数Android
wifi_rssi当前wifi信号强度Android
wifi_speed当前wifi链接速度Android
gate_delay到网关延迟（ping）Android & iOS
signal_level移动信号强度Android
xg当前网络类型Android & iOS
ldns本机DNS服务器Android & iOS

7. 机型相关

上报键值说明采集平台
manufacturer厂商Android
brand品牌Android
model型号Android
resolution分辨率Android

cpu&memory采集具体实现代码

1. cpu

  • Android采集代码：

      public static float totalCpuUsageRate() {return getTotalCpuUsageRate(USAGE_RATE_CAL_INTERVAL_MILLS_DEFAULT);}public static float getTotalCpuUsageRate(long calIntervalMills) {if (0 > calIntervalMills) {return VALUE_GET_FAILED;}float totalCpuUsageRate = VALUE_GET_FAILED;try {TotalCpuStatInfo totalCpuStatInfo1 = TotalCpuStatInfo.get();long cpuTotal1 = totalCpuStatInfo1.getCpuTotal();if (0 > cpuTotal1) {return totalCpuUsageRate;}long total1 = totalCpuStatInfo1.getTotal();if (0 > total1) {return totalCpuUsageRate;}try {Thread.sleep(calIntervalMills);} catch (Exception e) {GPMLogger.w(e, "getTotalCpuUsageRate failed");}TotalCpuStatInfo totalCpuStatInfo2 = TotalCpuStatInfo.get();long cpuTotal2 = totalCpuStatInfo2.getCpuTotal();if (0 > cpuTotal2) {return totalCpuUsageRate;}long total2 = totalCpuStatInfo2.getTotal();if (0 > total2) {return totalCpuUsageRate;}long totalDiff = total2 - total1;if (0 == totalDiff) {// NOTE: totalDiff为分母return totalCpuUsageRate;}long cpuTotalDiff = cpuTotal2 - cpuTotal1;return 100 * cpuTotalDiff / (totalDiff + 0f);} catch (Exception e) {GPMLogger.w(e, "getTotalCpuUsageRate failed");}return totalCpuUsageRate;}public static float myCpuUsageRate() {return getMyCpuUsageRate(USAGE_RATE_CAL_INTERVAL_MILLS_DEFAULT);}public static float getMyCpuUsageRate(long calIntervalMills) {if (0 > calIntervalMills) {return VALUE_GET_FAILED;}float myCpuUsageRate = VALUE_GET_FAILED;try {TotalCpuStatInfo totalCpuStatInfo1 = TotalCpuStatInfo.get();long total1 = totalCpuStatInfo1.getTotal();if (0 > total1) {return myCpuUsageRate;}MyCpuStatInfo myCpuStatInfo1 = MyCpuStatInfo.get();long myCpuTotal1 = myCpuStatInfo1.getCpuTotal();if (0 > myCpuTotal1) {return myCpuUsageRate;}try {Thread.sleep(calIntervalMills);} catch (Exception e) {GPMLogger.w(e, "getMyCpuUsageRate failed");}TotalCpuStatInfo totalCpuStatInfo2 = TotalCpuStatInfo.get();long total2 = totalCpuStatInfo2.getTotal();if (0 > total2) {return myCpuUsageRate;}MyCpuStatInfo myCpuStatInfo2 = MyCpuStatInfo.get();long myCpuTotal2 = myCpuStatInfo2.getCpuTotal();if (0 > myCpuTotal2) {return myCpuUsageRate;}long totalDiff = total2 - total1;if (0 == totalDiff) {// NOTE: totalDiff为分母return myCpuUsageRate;}long myCpuTotalDiff = myCpuTotal2 - myCpuTotal1;return 100 * myCpuTotalDiff / (totalDiff + 0f);} catch (Exception e) {GPMLogger.w(e, "getTotalCpuUsageRate failed");}return myCpuUsageRate;}private static class TotalCpuStatInfo {private static final int MIN_CPU_STAT_ITEM_NUM = 9;private static final String[] INVALID_RAW_CPU_STAT_ITEMS =new String[MIN_CPU_STAT_ITEM_NUM];public final long user;public final long nice;public final long system;public final long idle;public final long iowait;public final long irq;public final long softirq;public static TotalCpuStatInfo get() {BufferedReader cpuStatInfoReader = null;try {cpuStatInfoReader = new BufferedReader(new InputStreamReader(new FileInputStream(STAT_ABS_DIR), UTF8_CHARSET));return new TotalCpuStatInfo(cpuStatInfoReader.readLine());} catch (Exception e) {// NOTE: 高版本上获取不到, 不打印堆栈GPMLogger.d("get total cpu stat info failed");return new TotalCpuStatInfo(null);} finally {if (null != cpuStatInfoReader) {try {cpuStatInfoReader.close();} catch (IOException ignored) {}}}}private TotalCpuStatInfo(String cpuStatLine) {String[] rawCpuStatItems = CpuStatInfoHelper.buildRawCpuStatItems(cpuStatLine, MIN_CPU_STAT_ITEM_NUM, INVALID_RAW_CPU_STAT_ITEMS);user = CpuStatInfoHelper.buildCpuStatItem(rawCpuStatItems[2]);nice = CpuStatInfoHelper.buildCpuStatItem(rawCpuStatItems[3]);system = CpuStatInfoHelper.buildCpuStatItem(rawCpuStatItems[4]);idle = CpuStatInfoHelper.buildCpuStatItem(rawCpuStatItems[5]);iowait = CpuStatInfoHelper.buildCpuStatItem(rawCpuStatItems[6]);irq = CpuStatInfoHelper.buildCpuStatItem(rawCpuStatItems[7]);softirq = CpuStatInfoHelper.buildCpuStatItem(rawCpuStatItems[8]);}public long getCpuTotal() {return user + nice + system + iowait + irq + softirq;}public long getTotal() {return user + nice + system + idle + iowait + irq + softirq;}}private static class MyCpuStatInfo {private static final int MIN_CPU_STAT_ITEM_NUM = 17;private static final String[] INVALID_RAW_CPU_STAT_ITEMS = new String[MIN_CPU_STAT_ITEM_NUM];public final long utime;public final long stime;public final long cutime;public final long cstime;public static MyCpuStatInfo get() {BufferedReader cpuStatInfoReader = null;try {cpuStatInfoReader = new BufferedReader(new InputStreamReader(new FileInputStream(MY_STAT_ABS_DIR), UTF8_CHARSET));return new MyCpuStatInfo(cpuStatInfoReader.readLine());} catch (Exception e) {GPMLogger.w(e, "get my cpu stat info failed");return new MyCpuStatInfo(null);} finally {if (null != cpuStatInfoReader) {try {cpuStatInfoReader.close();} catch (IOException ignored) {}}}}private MyCpuStatInfo(String cpuStatLine) {String[] rawCpuStatItems = CpuStatInfoHelper.buildRawCpuStatItems(cpuStatLine, MIN_CPU_STAT_ITEM_NUM, INVALID_RAW_CPU_STAT_ITEMS);utime = CpuStatInfoHelper.buildCpuStatItem(rawCpuStatItems[13]);stime = CpuStatInfoHelper.buildCpuStatItem(rawCpuStatItems[14]);cutime = CpuStatInfoHelper.buildCpuStatItem(rawCpuStatItems[15]);cstime = CpuStatInfoHelper.buildCpuStatItem(rawCpuStatItems[16]);}public long getCurrentThreadCpuTotal() {return utime + stime;}public long getCpuTotal() {return utime + stime + cutime + cstime;}}

  • IOS采集代码：

      // ============当前进程cpu使用率============- (double) getCPU {kern_return_t kr;task_info_data_t tinfo;mach_msg_type_number_t task_info_count;task_info_count = TASK_INFO_MAX;kr = task_info(mach_task_self(), TASK_BASIC_INFO, (task_info_t)tinfo, &task_info_count);if (kr != KERN_SUCCESS) {GSDKLOG(@"================CPU:%.2f",-1.0f);return -1;}task_basic_info_t      basic_info;thread_array_t         thread_list;mach_msg_type_number_t thread_count;thread_info_data_t     thinfo;mach_msg_type_number_t thread_info_count;thread_basic_info_t basic_info_th;uint32_t stat_thread = 0; // Mach threadsbasic_info = (task_basic_info_t)tinfo;// get threads in the taskkr = task_threads(mach_task_self(), &thread_list, &thread_count);if (kr != KERN_SUCCESS) {GSDKLOG(@"=============CPU:%.2f",-1.0f);return -1;}if (thread_count > 0)stat_thread += thread_count;long tot_sec = 0;long tot_usec = 0;float tot_cpu = 0;int j;for (j = 0; j < thread_count; j++) {thread_info_count = THREAD_INFO_MAX;kr = thread_info(thread_list[j], THREAD_BASIC_INFO, (thread_info_t)thinfo, &thread_info_count);if (kr != KERN_SUCCESS) {GSDKLOG(@"=========CPU:%.2f",-1.0f);return -1;}basic_info_th = (thread_basic_info_t)thinfo;if (!(basic_info_th->flags & TH_FLAGS_IDLE)) {tot_sec = tot_sec + basic_info_th->user_time.seconds + basic_info_th->system_time.seconds;tot_usec = tot_usec + basic_info_th->system_time.microseconds + basic_info_th->system_time.microseconds;tot_cpu = tot_cpu + basic_info_th->cpu_usage / (float)TH_USAGE_SCALE * 100.0;}} // for each threadkr = vm_deallocate(mach_task_self(), (vm_offset_t)thread_list, thread_count * sizeof(thread_t));GSDKLOG(@"=============CPU:%.2f",tot_cpu);return tot_cpu;}// ============当前进程cpu使用率============processor_info_array_t cpuInfo, prevCpuInfo;mach_msg_type_number_t numCpuInfo, numPrevCpuInfo;unsigned numCPUs;NSLock * CPUUsageLock;- (void) getSystemCPU {int mib[2U] = { CTL_HW, HW_NCPU };size_t sizeOfNumCPUs = sizeof(numCPUs);int status = sysctl(mib, 2U, &numCPUs, &sizeOfNumCPUs, NULL, 0U);if (status)numCPUs = 1;CPUUsageLock = [[NSLock alloc] init];}- (double) getSystemCPUCircle {natural_t numCPUsU = 0U;kern_return_t err = host_processor_info(mach_host_self(), PROCESSOR_CPU_LOAD_INFO, &numCPUsU, &cpuInfo, &numCpuInfo);if (err == KERN_SUCCESS) {[CPUUsageLock lock];float tot_inUse = 0;float tot_total = 0;for(unsigned i = 0U; i < numCPUs; ++i) {float inUse, total;if(prevCpuInfo) {inUse = ((cpuInfo[(CPU_STATE_MAX * i) + CPU_STATE_USER] - prevCpuInfo[(CPU_STATE_MAX * i) + CPU_STATE_USER])+ (cpuInfo[(CPU_STATE_MAX * i) + CPU_STATE_SYSTEM] - prevCpuInfo[(CPU_STATE_MAX * i) + CPU_STATE_SYSTEM])+ (cpuInfo[(CPU_STATE_MAX * i) + CPU_STATE_NICE]   - prevCpuInfo[(CPU_STATE_MAX * i) + CPU_STATE_NICE]));total = inUse + (cpuInfo[(CPU_STATE_MAX * i) + CPU_STATE_IDLE] - prevCpuInfo[(CPU_STATE_MAX * i) + CPU_STATE_IDLE]);} else {inUse = cpuInfo[(CPU_STATE_MAX * i) + CPU_STATE_USER] + cpuInfo[(CPU_STATE_MAX * i) + CPU_STATE_SYSTEM] + cpuInfo[(CPU_STATE_MAX * i) + CPU_STATE_NICE];total = inUse + cpuInfo[(CPU_STATE_MAX * i) + CPU_STATE_IDLE];}tot_inUse += inUse;tot_total += total;}[CPUUsageLock unlock];if (prevCpuInfo) {size_t prevCpuInfoSize = sizeof(integer_t) * numPrevCpuInfo;vm_deallocate(mach_task_self(), (vm_address_t)prevCpuInfo, prevCpuInfoSize);}prevCpuInfo = cpuInfo;numPrevCpuInfo = numCpuInfo;cpuInfo = NULL;numCpuInfo = 0U;if (tot_total > 0) {GSDKLOG(@"CPU Usage: %.2f%%",tot_inUse/tot_total * 100.f);return tot_inUse/tot_total * 100.f;} else {return -1;}} else {GSDKLOG(@"Error!");return -1;}}

2. memory

  • Android采集代码：

      public static long getAvailableMemory(Context context) {if (null == context) {return VALUE_GET_FAILED;}@SuppressWarnings("AlibabaLowerCamelCaseVariableNaming")long availableMemoryInMB = VALUE_GET_FAILED;try {ActivityManager activityManager =(ActivityManager) context.getSystemService(Context.ACTIVITY_SERVICE);if (null == activityManager) {return availableMemoryInMB;}ActivityManager.MemoryInfo memoryInfo = new ActivityManager.MemoryInfo();activityManager.getMemoryInfo(memoryInfo);availableMemoryInMB = memoryInfo.availMem / (1024 * 1024);} catch (Exception e) {GPMLogger.w(e, "availableMemoryInMB failed");}return availableMemoryInMB;}// ============当前设备可用内存大小（原方案）============public static long getProcessMemery() {// TODO: 厂商反馈Debug.getPss()计算还是过于复杂，后续考虑使用Process.getPss()或者仿照Process.getPss()实现// NOTE: 当前实现应该在低优先级后台线程调用if (Build.VERSION_CODES.ICE_CREAM_SANDWICH <= Build.VERSION.SDK_INT) {return Debug.getPss() / 1024;}// NOTE: 仅在Android14下使用，不涉及私有API访问限制// Android 2.3上Process已有getPss方法// https://android.googlesource.com/platform/frameworks/base/+/refs/heads/gingerbread/core/java/android/os/Process.javatry {Method getPssMethod = Process.class.getMethod(GET_PSS_METHOD_NAME, int.class);return ((long) getPssMethod.invoke(null, Process.myPid())) / 1024;} catch (Exception e) {return VALUE_GET_FAILED;}}// ============当前设备可用内存大小（优化后方案）============private static ActivityManager sActivityMgr = null;private static int sPid = 0;public static int getProcessMemery(Context context) {try {if (sActivityMgr == null) {sActivityMgr = (ActivityManager) context.getSystemService(context.ACTIVITY_SERVICE);}if (sPid == 0) {sPid = android.os.Process.myPid();}if (sActivityMgr == null || sPid == 0) {return -1;}int[] myMempid = new int[]{sPid};Debug.MemoryInfo[] memoryInfo = sActivityMgr.getProcessMemoryInfo(myMempid);int memSize = 0;if (memoryInfo != null && memoryInfo.length > 0) {memSize = memoryInfo[0].getTotalPss();}return memSize;} catch (Exception e) {Logger.e("PSS fetch error: " + e.getMessage());}return -1;}

  • IOS采集代码：

      // ============当前设备可用内存大小============- (double) getSystemAvailableMemory {// 获取当前设备可用内存(单位：MB）vm_statistics_data_t vmStats;mach_msg_type_number_t infoCount = HOST_VM_INFO_COUNT;kern_return_t kernReturn = host_statistics(mach_host_self(), HOST_VM_INFO, (host_info_t)&vmStats, &infoCount);if (kernReturn != KERN_SUCCESS) {GSDKLOG(@"AvailableMemory=====%.2f",-1.0f);return -1;}double availMem = (vm_page_size * vmStats.free_count + vm_page_size * vmStats.inactive_count) / 1024.0 / 1024.0;GSDKLOG(@"AvailableMemory=====%.2f",availMem);return availMem;}// ============当前进程使用内存大小（原方案）============- (double) getFootPrint {task_vm_info_data_t vmInfo;mach_msg_type_number_t count = TASK_VM_INFO_COUNT;kern_return_t result = task_info(mach_task_self(), TASK_VM_INFO, (task_info_t) &vmInfo, &count);if (result != KERN_SUCCESS) {GSDKLOG(@"FootPrint=====%.2f",-1.0f);return -1;}GSDKLOG(@"FootPrint=====%i",(int)((vmInfo.phys_footprint) / 1024.0 / 1024.0));return vmInfo.phys_footprint / 1024.0 / 1024.0;}// ============当前进程使用内存大小（优化后方案）============- (instancetype) init {if (self = [super init]) {_isLowLevelDevice = NO;struct utsname systemInfo;uname(&systemInfo);NSString *platform = [NSString stringWithCString:systemInfo.machine encoding:NSASCIIStringEncoding];if ([platform isEqualToString:@"iPhone7,1"] || [platform isEqualToString:@"iPhone7,2"] || [platform isEqualToString:@"iPhone6,1"] || [platform isEqualToString:@"iPhone6,2"]) {_isLowLevelDevice = YES;}}return self;}- (double) getFootPrint {task_vm_info_data_t vmInfo;mach_msg_type_number_t count = TASK_VM_INFO_COUNT;kern_return_t result = task_info(mach_task_self(), TASK_VM_INFO, (task_info_t) &vmInfo, &count);if (result != KERN_SUCCESS) {GSDKLOG(@"FootPrint=====%.2f",-1.0f);return -1;}double footPrint = -1;if (_isLowLevelDevice || [UIDevice.currentDevice.systemVersion doubleValue] >= 12.0) {footPrint = vmInfo.phys_footprint / 1024.0 / 1024.0;}if ([UIDevice.currentDevice.systemVersion doubleValue] < 12.0) {footPrint = (vmInfo.internal + vmInfo.compressed - vmInfo.purgeable_volatile_pmap) / 1024.0 / 1024.0;}GSDKLOG(@"FootPrint=====%i",int((vmInfo.phys_footprint) / 1024.0 / 1024.0));return footPrint;}

二、性能数据统一上报类示例

使用同一个TDMReportHelper实例进行上报即可：

TDMReportHelper eventReportHandler = new TDMReportHelper(eventName);
eventReportHandler.addSS(key, value);
eventReportHandler.report();
eventReportHandler.destory();

这篇关于GPM合并资料整理-GEM部分的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！


http://www.chinasem.cn/article/593700。

相关文章

一文详解如何在Python中从字符串中提取部分内容

一文详解如何在Python中从字符串中提取部分内容

《一文详解如何在Python中从字符串中提取部分内容》：本文主要介绍如何在Python中从字符串中提取部分内容的相关资料,包括使用正则表达式、Pyparsing库、AST（抽象语法树）、字符串操作... 目录前言解决方案方法一：使用正则表达式方法二：使用 Pyparsing方法三：使用 AST方法四：使用字
阅读更多...
Mysql删除几亿条数据表中的部分数据的方法实现

Mysql删除几亿条数据表中的部分数据的方法实现

《Mysql删除几亿条数据表中的部分数据的方法实现》在MySQL中删除一个大表中的数据时,需要特别注意操作的性能和对系统的影响,本文主要介绍了Mysql删除几亿条数据表中的部分数据的方法实现,具有一定... 目录1、需求2、方案1. 使用 DELETE 语句分批删除2. 使用 INPLACE ALTER T
阅读更多...
Mysql中深分页的五种常用方法整理

Mysql中深分页的五种常用方法整理

《Mysql中深分页的五种常用方法整理》在数据量非常大的情况下,深分页查询则变得很常见,这篇文章为大家整理了5个常用的方法,文中的示例代码讲解详细,大家可以根据自己的需求进行选择... 目录方案一：延迟关联 (Deferred Join)方案二：有序唯一键分页 (Cursor-based Paginatio
阅读更多...
Python实现合并与拆分多个PDF文档中的指定页

Python实现合并与拆分多个PDF文档中的指定页

《Python实现合并与拆分多个PDF文档中的指定页》这篇文章主要为大家详细介绍了如何使用Python实现将多个PDF文档中的指定页合并生成新的PDF以及拆分PDF,感兴趣的小伙伴可以参考一下... 安装所需要的库pip install PyPDF2 -i https://pypi.tuna.tsingh
阅读更多...
Mysql中InnoDB与MyISAM索引差异详解(最新整理)

Mysql中InnoDB与MyISAM索引差异详解(最新整理)

《Mysql中InnoDB与MyISAM索引差异详解(最新整理)》InnoDB和MyISAM在索引实现和特性上有差异,包括聚集索引、非聚集索引、事务支持、并发控制、覆盖索引、主键约束、外键支持和物理存... 目录1. 索引类型与数据存储方式InnoDBMyISAM2. 事务与并发控制InnoDBMyISAM
阅读更多...
StarRocks索引详解(最新整理)

StarRocks索引详解(最新整理)

《StarRocks索引详解(最新整理)》StarRocks支持多种索引类型,包括主键索引、前缀索引、Bitmap索引和Bloomfilter索引,这些索引类型适用于不同场景,如唯一性约束、减少索引空... 目录1. 主键索引（Primary Key Index）2. 前缀索引（Prefix Index /
阅读更多...
使用Apache POI在Java中实现Excel单元格的合并

使用Apache POI在Java中实现Excel单元格的合并

《使用ApachePOI在Java中实现Excel单元格的合并》在日常工作中,Excel是一个不可或缺的工具,尤其是在处理大量数据时,本文将介绍如何使用ApachePOI库在Java中实现Excel... 目录工具类介绍工具类代码调用示例依赖配置总结在日常工作中，Excel 是一个不可或缺的工http://
阅读更多...
使用Python创建一个能够筛选文件的PDF合并工具

使用Python创建一个能够筛选文件的PDF合并工具

《使用Python创建一个能够筛选文件的PDF合并工具》这篇文章主要为大家详细介绍了如何使用Python创建一个能够筛选文件的PDF合并工具,文中的示例代码讲解详细,感兴趣的小伙伴可以了解下... 目录背景主要功能全部代码代码解析1. 初始化 wx.Frame 窗口2. 创建工具栏3. 创建布局和界面控件4
阅读更多...
Python自动化办公之合并多个Excel

Python自动化办公之合并多个Excel

《Python自动化办公之合并多个Excel》在日常的办公自动化工作中,尤其是处理大量数据时,合并多个Excel表格是一个常见且繁琐的任务,下面小编就来为大家介绍一下如何使用Python轻松实现合... 目录为什么选择 python 自动化目标使用 Python 合并多个 Excel 文件安装所需库示例代码
阅读更多...
使用Python合并 Excel单元格指定行列或单元格范围

使用Python合并 Excel单元格指定行列或单元格范围

《使用Python合并Excel单元格指定行列或单元格范围》合并Excel单元格是Excel数据处理和表格设计中的一项常用操作,本文将介绍如何通过Python合并Excel中的指定行列或单... 目录python Excel库安装Python合并Excel 中的指定行Python合并Excel 中的指定列P
阅读更多...

Copyright China编程 23002807@qq.com

沪ICP备2023033072号-2