Python operation Word and Excel and packaging

Installing the module # Word action library pip install docx # Excel operation Library pip install openpyxl # Package exe tool pip install pyinstaller Word operation 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

Java creates SmartArt graphics in PPT

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

EasyOffice-.NetCore line imports and exports Excel to generate Word

brief introduction 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 update data

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

JAVA export EXCEL table POI

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

Java bulk file compression export and download to local

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

Data Science Library for python learning

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

Notes on the plug-in of handsontable imitating excel

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

PowerShell audit Office365 mailbox operation log

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

From Excel Batch Import Data to ForkJoin's Principles

Preface 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