Installing the module
# Word action library
pip install docx
# Excel operation Library
pip install openpyxl
# Package exe tool
pip install pyinstaller
Reference address: https://python-docx.readthedocs.io/en/latest/
matters needing attention
Can only operate on docx format of openxml specification
Word interna ...
Posted on Fri, 29 May 2020 08:06:54 -0700 by luuney
SmartArt graphics can express the logical relationship between content and viewpoint through different layout and combination of text and graphics, which can quickly and effectively convey the intention and information of designers. This visual representation of graphic expression is commonly used in PPT, Word, Excel and other office documents ...
Posted on Fri, 08 May 2020 08:09:42 -0700 by Arc
Excel and Word operations are often used in the development process. They do not involve core business, but are often indispensable.Previous development methods have introduced NPOI, Aspose or other third-party libraries directly into business code, which is cumbersome, time-consuming and has poor scalability - for example, ...
Posted on Wed, 06 May 2020 16:58:59 -0700 by joix
ADO.NET mass data update
Important reference http://bbs.csdn.net/topics/370090507
public static void SqlBulkUpdate()
DataTable dt = ExcelHelper.ImportExcelFile("d://User1.xls "; / / import the data in Excel into 10000 data tables (as the data source for updating data)
DateTime begin = DateTime.Now;
string connectionSt ...
Posted on Mon, 04 May 2020 03:41:56 -0700 by danrah
Today, I will bring you a sample of how to use poi to export Excel for Java Web projects, which is suitable for novices in the first contact. There are two steps to export Excel: 1. Generate an excel and put it in the working directory; 2. Export it to the local.
Please download the required jar package by yourself, as ...
Posted on Sun, 03 May 2020 00:14:34 -0700 by abhic
Mainly usedorg.apache.tools.zip . ZipOutputStream this zip stream, here's an example of Execl.
The idea is to first write the zip stream into the http response output stream, and then write the excel stream into the zip stream (here, you don't need to generate files and package them, just read and write the execl template and output the data to ...
Posted on Sat, 02 May 2020 22:11:05 -0700 by synchro_irl
numpy create array
#Import the numppy library and rename numpy to np.
import numpy as np
#1). Create an array: a, b, c create the same array, choose any one;
#Method 1: Transform the data type to ndarray by passing the array/list directly into the array method.
a = np.array([1, 2, 3, 4, 5])
#The value passed in by the array method can be a r ...
Posted on Sat, 02 May 2020 19:08:51 -0700 by malam
Post a link to the official website of handsontable first Click to open the link
The biggest advantage of this plug-in is to move excel from the local to the web, and the operation is basically the same as excel. Users do not need to relearn, which is very consistent with the operation habits of the clerks. First, briefly introduce the followi ...
Posted on Fri, 01 May 2020 03:05:02 -0700 by Petrushka
In Office365, we can get messagetrace to track the records of mail sending and receiving, but for a specific mailbox, how to get the information of related operations, such as who deleted and moved some mail? In particular, some mailboxes may have access to many people, and then a certain email can not be found, how to track the operation log? ...
Posted on Tue, 21 Apr 2020 07:23:36 -0700 by doni49
Previously, we introduced EasyPOI, which is very convenient and simple for Excel import and export.However, version 4.0.0 and previous versions all parse data in Excel in a single-threaded way.The efficiency is poor. Today, I'm going to do a test of 5000 pieces of data imported using EasyPOI and my own handwritten ForkJoin (multitask ...
Posted on Sat, 18 Apr 2020 18:15:45 -0700 by NoReason