Excel

Unexpectedly, Java operation Excel is so simple!

preface In the work, using excel to process d...
6:28 19 June 2020

Converting Excel tables to visual graphics in Python

As you know, a large part of postgraduate entrance examination is also the ability to collect information. Every year, m...
23:37 16 June 2020

python builds ARIMA model for time series analysis (paper)

#How to start a paper on data processing from scratch I really don't know how to do it. It's pure entry-level. Just draw a picture and hand...
1:16 16 June 2020

PCA topic of R language principal component

12.3 Based on the principal component analysis of the scores of 50 students in the table below, how many comprehensive v...
2:20 13 June 2020

How to read by row and by column in excel

Recently, there is a demand that excel should be used for import and export. Generally, our idea is based on the number ...
6:29 6 June 2020

Phpspreadsheet Chinese document 2 (translation software version)

Due to phpoffice/phpexcel (this package has been discarded and is no longer maintained. The author suggests using the ph...
3:18 5 June 2020

C. how to add, modify and delete Excel Mini chart

The mini chart in Excel table can show us the trend of data change intuitively. This paper introduces how C ා can genera...
11:31 27 May 2020

C × datatable row to column and column to row conversion at the same time

Requirement: the database data is vertical. When presenting, it is required to see the row header (row to column) at the...
6:37 22 May 2020

pyqt5 learning record

1, Write at the beginning Boring writing. Recently, I learned how to do python GUI. I feel much behind the web page. I j...
14:11 18 May 2020

JS directly downloads pictures and videos instead of opening previews

The attachment list in a project usually needs to provide the function of downloading and deleting. The function itself ...
11:47 9 May 2020

Self filming tutorial 64 Python Testlink use case import split Excel tool

Case story: in the process of Testlink importing use cases in xml format, there will be a small problem: How to make sur...
11:08 8 May 2020

[theory combined with practice] an analysis of the reading speed of xlrd, openpyxl and xlwings

Because pneumonia is closed at home, there is no school opening, and the internship has not started yet, so I will revie...
3:10 15 February 2020

Install R & D server

It's really a process of energy consuming to reinstall the server, especially the whole data backup with ghost, the snai...
5:15 7 February 2020

Bash & Python processing application translation table for international import Excel into string.xml table

The company's business development must be internationalized. In the process of internationalization, the most headache is to write an internati...
4:13 14 January 2020

C ා create Excel chart with multi-level classification labels

Compared with data, charts can more intuitively reflect the trend of data changes. In the data table, the same data value may represent different data...
2:09 3 December 2019

R script reading summary Excel table data

It mainly uses xlsx and rJava package, opens Excel file, reads data of each table, and writes it to summary table. The following figure shows the ori...
21:25 2 December 2019

Get the weight or feature of a layer in the middle of Python

Get the weight or feature of a layer in the middle of Python Question: how to deal with a trained network model that wants to know the weight of a ce...
20:51 2 December 2019

[reprint] C ා tool class: Csv file conversion class

csv is a comma separated value format file that stores table data (numbers and text) in plain text. A csv file consists of any number of records separ...
10:11 2 December 2019

Details Python operation Excel files

Preface This article summarizes the third-party libraries and methods for working with Excel files using python. Introduction to Common Libraries 1.x...
22:15 2 September 2019

C# Learning Records Read Excel with OleDB

The project requires me to read an Excel form. The way on the Internet is to use Excel as a data source and OleDB to read it. As I understand it, Ole...
3:10 29 July 2019