How to convert a column number (for example, 127) to an Excel column (for example, AA)

How to convert numbers to Excel column names in C without using automation to get values directly from Excel. The possible range for Excel 2007 is 1 to 16384, which is the number of columns it supports. The result value should be in the form of excel column name, such as A, AA, AAA, etc. #1 building In perl, enter 1 (A), 27 (AA), and ...

Posted by jacksonpt on Sat, 25 Jan 2020 07:17:05 -0800

Countdown display and control

This may happen during the development of foreground functions: For a list of multiple order commodities, click view details, which contains the countdown of the corresponding commodity activity time. If you click view instead of refreshing the entire page, you need to close the countdown when you view the details and return t ...

Posted by LordShryku on Fri, 24 Jan 2020 07:49:20 -0800

Classic JavaScript inheritance mode

Understanding JavaScript inheritance is helpful for normal development. Here are four classic inheritance patterns. 1. Prototype chain Disadvantages: it belongs to the traditional inheritance mode and inherits both the constructor and the prototype Father.prototype.lastName = "king"; function Father (sex) { this.sex = sex } ...

Posted by jebadoa on Fri, 24 Jan 2020 07:12:53 -0800

Review the basic use of mongoose

mongodb reference mongoose official website mongoose is more convenient to use Using mongodb data driver to write an error log For more information on the official data-driven mongodb of node asset assertion is not used here import mongodb from 'mongodb' const MongoClient = mongodb.MongoClient const url = 'mongodb://localhost:27017/edu' expor ...

Posted by dannyluked on Fri, 24 Jan 2020 07:08:14 -0800

Development of sleep app (1): native.js calls the native mediorecorder object to realize the function of monitoring dreamtalk

We are going to develop a sleep aid app. On the way, we need to realize the function of listening to the user's dreamtalk. Because the h5 + encapsulated audiocorder object used by the front desk staff is not enough to achieve the expected effect, so we decided to use native.js to call the native mediacorder object to realize th ...

Posted by bloo on Fri, 24 Jan 2020 06:49:59 -0800

Design a page with nunjucks template

Use nunjucks instead of ejs, because this is a more powerful template engine in nodenunjucks official website Configure to use the nunjucks template engine The nunjuks template engine does not have specific restrictions on the suffix of template file names If the file name is a.html, you need to pass in a.html when rendering Pass b.nujs if the ...

Posted by lansing on Fri, 24 Jan 2020 06:12:01 -0800

JavaScript private methods

To create a JavaScript class using public methods, I need to do the following: function Restaurant() {} Restaurant.prototype.buy_food = function(){ // something here } Restaurant.prototype.use_restroom = function(){ // something here } In this way, users of our class can: var restaurant = new Restaurant(); restaurant.buy_food(); ...

Posted by Drayton on Fri, 24 Jan 2020 02:30:47 -0800

Submit the form using jQuery

I want to use jQuery Submit the form.Can anyone provide code, demo or example links? #1st floor From the manual: jQuery Doc $("form:first").submit(); #2nd floor You will have to use $("#formId").submit(). Typically, you can call this function from a function. For example: &l ...

Posted by Pooptart on Wed, 22 Jan 2020 20:38:50 -0800

Collection collection in Java (List class collection)

1. Differences between sets and arrays As a container, arrays have some inconveniences. They are inconvenient to add, delete and change operations. Arrays can only store the same data type, which can be either a basic data type or a reference data type.Java puts forward the concept of a collection, w ...

Posted by AnotherQuestion on Wed, 22 Jan 2020 17:08:43 -0800

web mobile learning: Gaud map demo

In the previous article, we used JS method to load plug-ins. Now we can use the official recommended method to load the plug-ins required by adding & plugin = amap.autocomplete after the KEY value in the script tag in the header tag    <script type="text/javascript" src="https://Webapi. Amap. COM / maps? V = 1.4.15 & key = applied ...

Posted by shadypalm88 on Wed, 22 Jan 2020 07:10:48 -0800