Algorithm: calculate the column number according to the number of excel columns
I met an algorithm problem when I was in Microsoft's 5 aspects. I calculated the number of columns according to excel column number and calculated the number of columns according to the column number. Because I didn't answer well during the interview, I recorded the implementation idea here.
First of all, let's talk about the following topics: ...
Posted by Kyrst on Wed, 27 Nov 2019 21:30:56 +0100
How to download DataTable
There are many ways to download datatable from the server to the local. Here are three ways.
Mode 1: transfer datatable to txt for download.
Steps:
1. Download datatable content to server txt
2. Download the server's txt to the local
3. Delete the txt on the server
Mode 2: the datatable is bound to the control GridView and then downloaded ...
Posted by b0ksah on Tue, 26 Nov 2019 21:31:19 +0100
Qt Write Gas Security Management System 16-Cloud Synchronization
1. Preface
Cloud synchronization function is preparation for later expansion. His purpose is to synchronize records from local databases, such as real-time collected data and stored running records, to the cloud database. By default, the mysql database of Ali Cloud is used. The speed of Ali Cloud is still very fast. I have bought low-match and ...
Posted by cdm2 on Sun, 24 Nov 2019 03:50:52 +0100
Qt Write Gas Security Management System 14-Mail Forwarding
1. Preface
Mail forwarding function and SMS alert function are basically the same, they are triggered after judging the alert, which may be slightly different. Mail forwarding needs to rely on the Internet, and can send a large amount of data without the limitation of 60 characters of SMS (of course, SMS can split multiple sending, but it costs ...
Posted by mudasir on Fri, 22 Nov 2019 03:58:47 +0100
Batch modification of excel files by python
Batch modification of excel by python
In the morning, I suddenly got help from my little sister. How to use the program to delete the pictures in excel in batches? As a front-end dog, I felt a little frustrated. After all, this is not my specialty. Miss said python should be OK. google it now.
It has been more than two years since I started to ...
Posted by tomhoad on Thu, 21 Nov 2019 13:12:45 +0100
Better named tuple than tuple in Python
First, thinking
1. What is tuple?
Immutable sequence type
List that cannot be modified
2. What operations does tuple support?
Tuple is a sequence type, supporting all operations of sequence type
Value by index
one_tuple = ("Excellent", 17, "male", "coding", "Never Stop Learning!")
one_tuple[-1]
Slicing operation
one_tuple = ("Excellent" ...
Posted by sandthipe on Wed, 13 Nov 2019 20:34:40 +0100
Qt Writing Gas Safety Management System 3-User Module
1. Preface
From this article, write specific functional modules one by one. User modules mainly have four aspects: user login, user exit, user management, rights control.Here, you can follow simple and common practice, such as user login interface, provide a drop-down box to select the user name, then enter the password, password box cipher tex ...
Posted by ratebuster on Mon, 11 Nov 2019 08:48:27 +0100
Java custom annotation usage
First, explain
1. Definition of notes
The Java file is called Annotation, which is represented by @ interface.
2. yuan annotation
There are some notes on @ interface as needed, including @ Retention, @ Target, @ Document, @ Inherited.
3. Retention policy of notes
@ Retention(RetentionPolicy.SOURCE) / / the annotation only ...
Posted by doug007 on Fri, 08 Nov 2019 16:55:41 +0100
vue export Excel format vue JSON Excel file Saver xlsx
vue export Excel format vue JSON Excel file Saver xlsx
Recently, the company is writing a project. It needs to export the json data in vue to Excel format. There are two ways to realize this: searching the data on the Internet
The second method is recommended by individuals. Although the first method is convenient, ...
Posted by ozace on Thu, 07 Nov 2019 16:35:41 +0100
[easyexc] Alibaba easyexcel version 2.0.5 simple reading and writing example
Ali easyexcel is a toolkit for reading and writing Excel based on the package of poi, which mainly solves the problem of large memory occupied by reading large file poi, and also provides some simple excel operation API. But I found it on the Internet. There are few official explanations. The example ...
Posted by Andre_Ng on Fri, 25 Oct 2019 16:29:10 +0200