How to get cell Style and some operations of cell Style when POI parses Excel
Recently, the company's operation platform needs to upload Excel files and analyze and import them into the database. After the development, an unexpected production bug appears. The following are the specific reasons: 1. When using POI to parse excel, by default, if there is no data in Excel cell and cell Style has no border, it is null, so it ...
Posted by Ajita on Wed, 18 Dec 2019 08:50:53 +0100
Interface automation by reading configuration file and Excel content
The class libraries involved in this article, configparser, xlrd, xlutils, requests
Objective: to achieve a simple http interface test, put the data into the Excel table, test by reading the data in the Excel table, and write the test results back to the Excel table
1. Data preparation
2. Interface, port, path
baseurl = 1 ...
Posted by deezin on Thu, 12 Dec 2019 20:59:01 +0100
Document display scheme arrangement in Android App
I. Word, Excel, PPT display
1. Microsoft Office open Api interface
If the document content is not very confidential or just needs to preview the document, you can consider using Microsoft's public Api interface.
Microsoft Office public Api address: https://view.officeapps.live.com/op/view.aspx?
The implementation on Android is as follows:
...
Posted by CoffeeOD on Wed, 11 Dec 2019 16:51:02 +0100
Using java api to create excel content and send email
Copyright notice: This is the original article of the blogger. It can't be reproduced without the permission of the blogger. https://blog.csdn.net/qq_26654727/article/details/83473968
Article directory
Using java api to create excel content and send email
Main functions:
Core code (SendMail ...
Posted by phpMover on Tue, 10 Dec 2019 21:57:59 +0100
Synchronization tool classes CountDownLatch and CyclicBarrier
In the development, some asynchronous operations will obviously speed up the execution speed and bring better experience, but at the same time, it also increases the development complexity. If you want to use many threads, you must understand from these aspects
wait() notify() notifyall() method of thread
Thread returns Future asynchronously
...
Posted by brad_fears on Mon, 09 Dec 2019 01:33:19 +0100
Qt Writing Gas Safety Management System 26-Configuration Design
1. Preface
Configuration design is added at the request of a customer. The design concept is to provide a primary function of configuration design, such as reading the custom control dynamic library, loading all the controls into the control bar (somewhat like the qtcreator's control bar) Users drag the corresponding controls onto the canvas, a ...
Posted by az_wraith on Sat, 07 Dec 2019 00:30:00 +0100
Java compressed files and folders
Not updated for a long timeTen thousand words are omitted here. Hu Hansan is back again!!!! get down to business...
This time, the main function is to achieve: according to the incoming path, compress files and folders, for example, compress files from path A to directory B, including empty folders. Not much nonsense, directly on the code: (th ...
Posted by [JayZ] on Fri, 06 Dec 2019 21:05:32 +0100
Java reading Excl file (poi-3.13)
Copyright notice: This is the original article of the blogger. It can't be reproduced without the permission of the blogger. https://blog.csdn.net/u010046908/article/details/50581867
Recently, the project has encountered the initialization of reading Excel data to the ...
Posted by onekoolman on Tue, 03 Dec 2019 06:39:40 +0100
java data written to Excel
Just recently, the company has to write a reconciliation function. The background uses java to get reconciliation information from the bank. The data is of json type, and then it is written into excel and sent to the server in the card center. A lot of codes are found on the Internet, and then they are integrated and corrected. The codes are as ...
Posted by offsprg01 on Sat, 30 Nov 2019 23:45:52 +0100
Construction of mobile automation testing framework
Some thoughts on the big framework:
What functions need to be implemented by the framework
In the early stage, data and business need to be separated to facilitate maintenance
The management of test case set shall be convenient, so as to re Run a single case in case of exception
Use case design needs to be as simple as possible and provide ...
Posted by deezerd on Sat, 30 Nov 2019 11:48:00 +0100