Tag:excel

  • C# reading Excel files

    Time:2022-4-28

    #C# reading Excel data Create a form file in Visual Studio 2019, design a button button and a GridView control (used to display data in Excel) This article refers to the npoi third-party package, which can be downloaded through nuget search in vs private void Button1_Click(object sender, EventArgs e) { //Instantiate datatable to store data […]

  • How to parse excel content in clipboard with JS

    Time:2022-4-9

    catalogue preface 1. Paste event and clipboard 2. Content format in the clipboard 3. How to parse HTML strings preface This time, I recorded an idea last night: copy the excel content to the clipboard and convert it into the JSON format I want. The core is to convert the excel content into JSON. This […]

  • Change your posture to meet excel

    Time:2022-4-3

    In an accident, the mouse right clicked on an excel file It is found that this product is actually a compressed file. After decompression, it is found that it contains the following files (for reference only) Most of them are in XML format (a little surprise). The following figure shows the view of Excel file […]

  • [Python] use pandas to merge all excel in the folder

    Time:2022-3-4

    source code import pandas as pd import os #Target folder you want to merge target_dir=’C:/Users/Kinglake/Desktop/666/’ #Get the list of file names in this directory Print (“merge”, target_dir, “path file:”) for root,dirs,files in os.walk(target_dir): Print (“total”, len (files), “PCs”) #Generate absolute path for index in range(len(files)): files[index]=target_dir+files[index] #print(files) #Read in files and merge for index in […]

  • Python + excel | visual vaccination changes over time

    Time:2022-2-19

    1、 Introduction The topic comes from the big homework I helped my younger sister do (it seems that I can learn Python even if my liberal arts is better?) The relevant information is taken from the data published on the official website of the National Health Commission, which is true and reliable. Data is for […]

  • Teach you how to use Python to batch merge the second table of all Excel files in the folder

    Time:2022-2-17

    Click above“Python crawler and data mining”, pay attention Reply“book”You can receive a total of 10 e-books from introduction to advanced python this day chicken soup Huaijun is an autumn night, walking and chanting the cool day. Hello, I’m an advanced Python player. Today, I will continue to share with you the knowledge of Python office […]

  • [using JS self-made form software to play data] 4 Implementation of row column counter

    Time:2022-2-5

    Render cells Column counter principle Stepper Character operation table Source code We have designed an underlying rendering class. Now we are going to build a module to render cells based on this underlying class. Column counter Usually in Excel, we can see that the horizontal ruler uses letters such as a, B, C and D […]

  • Summary of common operations for generating excel reports with VBScript

    Time:2022-1-15

    After QTP automatic test, it is often necessary to write the test results into excel. Here, some common methods of Excel operation are summarized and sorted out for easy reference. Office Excel 2003 version is supported, but 2007 version is not supported. VBScript code ? 1 2 3 4 5 6 7 8 9 10 […]

  • How to download excel stream file and set download file name in Vue

    Time:2021-12-5

    catalogue summary 1. Download via URL 2. Download through the a tag download attribute combined with the blob constructor 3. Through the JS file download Plug-in summary Export excel requirements. When you click download template or download feedback results, Axios initiates a back-end interface request, and the returned data is garbled when obtaining the response, […]

  • VBS traversal excel worksheet implementation code

    Time:2021-10-2

    Core code ? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 ‘****************************************** ‘drag the file to get the file path ‘****************************************** If wscript.Arguments.count=0 then         msgbox “Drag file to this […]

  • Python handles excel and automatically fills in the abbreviation according to the full name

    Time:2021-10-2

    When dealing with excel at work, you need to fill in a column of abbreviation according to the full name of the device manufacturer. Since there are tens of thousands of devices in the data table, it takes a lot of time to manually process by relying solely on the excel screening function. Here, you […]

  • Implementation of pandas for Excel processing

    Time:2021-9-26

    This paper mainly introduces the implementation of pandas for Excel processing, which is shared with you as follows: read file import padas Numerical processing DF [“dog”] = DF [“dog”]. Replace (- 1,0) # value replacement get data Data = DF. Head() # default read line Detailed explanation of LOC and iloc LOC [row, column] first […]