Python efficiency revolution processing Excel tables

Excel is a powerful spreadsheet application running in Windows environment. An Excel spreadsheet is called a workbook, and a workbook is saved in a file with the extension. xlsx. Each workbook can contain multiple tables (worksheets) the table currently viewed by the user (or the last table viewed before closing) is called the active table. ...

Added by saadatshah on Tue, 19 May 2020 10:10:42 +0300

python notes: drawing Nightingale rose with pyecharts

Recently, "Nightingale rose map" has caught fire all over the Internet due to the people's Daily's report of the epidemic. Used to see pie chart, at first contact with this chart, it is inevitable to be amazed by its visual impact. Since I have been studying Python for the past two years, I am now ready to use Python to make Nightinga ...

Added by Yrogerg on Wed, 13 May 2020 21:42:52 +0300

Developing Excel VBA to send mail automatically

From: http://blog.csdn.net/chenxiangping/article/details/70821116 1, . set up Outlook email account (not the focus of this article) 2, . set up Outlook Trust Center as follows If the following operation settings are not made, the prompt is as follows when Excel VBA calls Outlook to automatically send mail 2.1 Outlook - > to ...

Added by saariko on Sun, 03 May 2020 08:09:12 +0300

Asp.net MVC simple implementation generate Excel and download

Due to the requirements on the project, you need to export the Excel file with the specified conditions. After a rummage, it finally came true. Now post the code and share it (directly share the code of some auxiliary classes in our project)   Our project uses Asp.Net MVC4.0 mode. Each ActionResult must return a View or Json, etc. (the paramete ...

Added by busterbry on Sun, 03 May 2020 03:07:20 +0300

Python notes: draw several beautiful polylines with the pyecharts Library

I believe that many people with a certain Python foundation should have found that the visual graphics drawn with the matplotlib library are slightly ugly (default) except for the area map! However, the visual graphics created by pyecharts library have strong visual impact! The following is a group of broken lines that my colleagues dislike th ...

Added by johndale on Thu, 23 Apr 2020 18:28:23 +0300

Python office automation from Word to Excel

Yunqi information:[ Click to see more industry information]Here you can find the first-hand cloud information of different industries. What are you waiting for? Come on! Hello, everyone. Today, I was entrusted by a small partner of a civil servant to help him. There is a word like this (the specific content of the document has been modified du ...

Added by shoombooltala on Tue, 21 Apr 2020 10:49:36 +0300

python operation excel import data to mysql

Requirement: the exchange code of excel is imported into mysql, with a total of 30W pieces of data. Navicat has its own functions. It can directly import excel data into mysql. There are too many databases and manual operation is very troublesome. A script is written with python. Use pip to import xlrd,pymysql library. ...

Added by uncleronin on Mon, 06 Apr 2020 19:22:11 +0300

Automated installation of unattended batch scripts for SQL Server 2014 Enterprise Edition

_Copyright Statement: This is an original article created by a blogger and may not be reproduced without the permission of the blogger. SQL Server series software is a relational database management system introduced by Microsoft.At a conference in San Francisco on April 16, 2014, Microsoft CEO Satia Nadela officially launched "SQL Ser ...

Added by blade_922 on Sun, 05 Apr 2020 08:45:43 +0300

Complete permission control with SpreadJS in offline filing scenarios

SpreadJS As a pure front-end spreadsheet control based on HTML5, it is compatible with more than 450 Excel formulas. It can bring users a friendly experience of using Excel, and can meet business scenarios such as Web Excel component development, data filling, Excel class report design, table and document collaborative editing in enterprise IT ...

Added by wha??? on Sun, 05 Apr 2020 06:26:27 +0300

Python web crawler notes (5): Download and analyze JD P20 sales data

(I) analysis page Download the sales data for this link below https://item.jd.com/6733026.html#comment 1. When turning the page, the Network tab of Google F12 can see the following request.   It can be seen from the Preview tab that this request is to obtain comment information 2. Compare the first page, the second page, the third page Differ ...

Added by brianjw on Thu, 02 Apr 2020 12:19:09 +0300