The Excel workbook you manage has been modified by many people, many of which are often inconsistent, providing VBA code to implement one-click layout of tabular data format, eliminating the manual frequent adjustment of Excel data format.1 Option Explicit2 OptionBase13 4 SubAutoSet ()5 DimI as Integer6 7 fori =1 toSheets.count8 Sheets (i). Activate ' This line of code can not save, before the table operation, you need to activate the operation of the table first9 Sheets (i). Cells
", which "builds on the power of Java and includes powerful additional features from languages such as Python, Ruby, and Smalltalk", such as dynamic classes Type conversion, closures, and metaprogramming (metaprogramming) support (see Resources). It is a mature object-oriented programming language that can be used both for object-oriented programming and as a pure scripting language. I like to view it as a Java language with no annoying code, but with other features in closures and dynamic langu
how Excel makes query tables quickly
Now we're going to use the "Development tools" for Excel 2016, and by default some people's Excel may not show this one and need to be set up briefly. Click "file → options", in the Open Options window, switch to the "custom Ribbon" on the left, and then to the right to find the "development tool" item, check it out on it.
First of all, create a front-end query interface, this interface can be concise
Photoshop makes a lifelike rain gif animation. Rain Animation production is the focus of the small part of the production, before the use of noise filters to make, drizzle relatively difficult to control; Here is the introduction of the channel with the filter to get the distribution of very natural small points, and then the appropriate dynamic blur can get the rain effect.
Heavy rain
Rain
1, save the background of the big
Photoshop makes a lovely piano icon. The effect chart is very creative, with some minimalist graphics to show the effect of the piano, the first to draw the structure to break down, the general understanding of each part of the material and light and shadow, and then a layer of description can be.
Final effect
1. Draw the outline of the piano icon.
2, draw the overall outline of the piano.
3, draw the lid an
jquery's deferred object.2, the back end of the PHP code running on the Nginx serverThe logic behind the backend is simple: we save the data from the front end to a file named Data-demo01, and the Save succeeds returns a 1 as a flag to the front end.(1) Front-end Ajax initiating GET requestIf the front-end Ajax initiates a GET request, then the backend is also better handled: if (isset ($_get[ ' name " ]) !empty ($_get[ " name " )) {$username = Trim ($_get[ " name " ]); if (file_put_
Photoshop makes romantic surreal Valentine's Day poster
This time did not follow the traditional Chinese wind to do, with a surreal romantic scene elements are put into a microscopic octave box to do the show, the following to see the production process.
Final effect
First, the brain storm:
Second, find inspiration:
Third, find material:
Iv. Analysis of synthetic steps:
1, fill the background colo
How the memory card makes the startup disk
Download "U Help u Disk Startup Disk Production tool";
Download the "U Help u Disk Startup Disk Production tool" installed to the computer any directory;
Run the "U Help" main program;
Insert memory card (Warm tip: The production process will format the memory card!) do a good job of data backup! When inserted, the tool is automatically recognized! If the desktop recommends inserti
Photoshop makes exquisite doughnut-shaped ink effects. the doughnut-shaped ink is made from a straight line of ink; when made, we first draw a layered linear ink effect with a brush, and then quickly turn to the ring with the polar coordinates filter.
Final effect
1, open PS software, press CTRL + N new document, Size: 1500 * 1500 pixels, resolution 72, background selection White, the following figure.
2. Select the Brus
Photoshop makes a pair of thick sandals
This tutorial does not rigidly adhere to a trick, you need more of your own thinking and testing. The tutorial will use a lot of pen tool, layer style inner shadow, layer overlay function, mouse painting and so on.
Final effect
1, first of all, we analyze the structure of this pair of sandals, for the complex shape of things, the first to split the analysis, the work behind the absolute is to
Photoshop makes the art of ancient tree-vine texture style
Final effect
1, first open a tree vine material, the following figure.
2. Select the Clone Stamp tool to clean up the branches of the selection, as shown in Figure 3.
3, into the channel panel, the green channel to copy a layer, increase the picture color contrast, branches outside the part of the white, the following figure. Then press CTRL
Photoshop makes a natural snow animation
Timeline animation is relatively complex, first of all to create a loop unit, because we want to reduce the size of the export animation picture. Make a good unit after stitching to get the complete snowflake, and then in the timeline set into animation.
Final effect
1, click the image below to open a larger picture, the right mouse button to choose "Save the picture as" save to this machine, and
1. Copy layer, soft light mode, use soft light to optimize the layer
2.ctrl+u hue saturation, with a straw to absorb the color of the leaves, the change in hue has reached the goal of the transformation season, we need the feeling of winter, to find the hue of the leaves, the brightness of the brightest.
3. Note the lightness of which tolerance slider details, you can choose to lower the saturation, you can also use hue to improve the brightness, here is the color range, turn off duplicate lay
The focus of the tutorial is the production of flame parts. The Flames are also composed of flares and smoke parts. You can do the flame first, first lay a rough background, and then render the high light, and then a few flame high light rendering out. Smoke is basically similar to flame making, so control the edge transition.
Final effect
1, the effect of the picture by the match and flame two parts of the composition, the following figure.
2, create a
The tutorial introduces the method of multi level stereo word making. The process is not complex, making good text, add style to the text to make texture. Then along the edge of the text to check out the outline as a three-dimensional word, and then add three-dimensional effect to this surface, and then gradually enlarge the face, and add three-dimensional effect, so you can make multi-level three-dimensional words.
Final effect
1, a new 1024 * 768 pixel file, select the Gradient
Photoshop makes basketball star poster. The effect drawing is very exquisite, in addition to the characters and some background, the other elements are painted by the author, and the use of more elements, you can see the author very attentively, and the tutorial also write very detailed, it is worth our study.
Original
1. Start my process below and create a new canvas that matches the size of your display.
2, create a ne
Photoshop makes the green pig icon in a famous game. The effect is very Meng, the author is based on the role of the animation set the icon effect, the creation of the first part of the icon to decompose the parts, and then check out the graphic, and then use the brush and layer style to increase light and shade.
Final effect
First, draw the basic graphics:
Second, layer style, light and shade:
Class
Photoshop makes a beautiful wordart of English fonts
The final effect chart:
The specific production steps are as follows:
1. Create a new file and then write a 9 word in a very coarse font, and of course you can also write your favorite lucky number, reducing its opacity to 20%, because its role is only an outline. This is a bold century Gothic font.
2. Now again the border area, we need to play our favorite text, change t
Today Spring Brother Technology blog and everyone to share under the development of the front-end, or the imitation of the station, sometimes it is easy to encounter the Product List page display dislocation, such as the original 4 line display, the result has become 3 lines display, it is difficult to see.It turns out that your CSS doesn't control well.A netizen asks: How CSS controls ul li each line displays several and wraps like the table effect.Today, Brother Chun to tell you: we look at th
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.