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