tablesample,wordpress怎样搭建网站

伏羲号

tablesample,wordpress怎样搭建网站?

想要搭建个人网站,就需要有单独的服务器,就在阿里云购买了台服务器,选择系统为“Ubuntu 14.04.5 LTS”,并在阿里云买了个域名(域名是为了方便记忆,否则输入ip地址访问网站很不方便),下面就使用Ubuntu系统搭建WordPress个人网站。

tablesample,wordpress怎样搭建网站

安装WordPress运行环境

1.安装Mysql数据库

apt update

apt upgrade

apt install mysql-server

查看mysql是否安装成功:

root@iZ2zeeg42qkecbhciml4pcZ:~# mysql --version

mysql Ver 14.14 Distrib 5.5.62, for debian-linux-gnu (x86_64) using readline 6.3

2.安装PHP

apt-get install software-properties-common

add-apt-repository ppa:ondrej/php

apt update

apt install php7.2

apt install libapache2-mod-php7.2

apt install php7.2-mysql

apt install php7.2-fpm

查看php是否安装成功:

root@iZ2zeeg42qkecbhciml4pcZ:~# php -v

PHP 7.2.16-1+ubuntu14.04.1+deb.sury.org+1 (cli) (built: Mar 7 2019 20:42:24) ( NTS )

Copyright (c) 1997-2018 The PHP Group

Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies

with Zend OPcache v7.2.16-1+ubuntu14.04.1+deb.sury.org+1, Copyright (c) 1999-2018, by Zend Technologies

3.安装Nginx

install nginx

查看Nginx是否安装成功:

root@iZ2zeeg42qkecbhciml4pcZ:~# nginx -v

nginx version: nginx/1.4.6 (Ubuntu)

重启Nginx后,在浏览器中输入http://阿里云服务器外网IP地址/

service nginx stop

service nginx start

如果图片显示为下图,说明阿里云服务器自动启动了apache2的服务,apache2和nginx都使用80端口,80端口冲突。

关闭apache2的服务

重启php7.2-fpm服务和Nginx服务:

在浏览器中输入http://阿里云服务器外网IP地址/

安装WordPress及其配置

1.Mysql创建数据库和用户:

root@iZ2zeeg42qkecbhciml4pcZ:~# mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 44

Server version: 5.5.62-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database 数据库名称 character set utf8 collate utf8_general_ci;

Query OK, 1 row affected (0.00 sec)

mysql> grant all on 数据库名称.* to '用户名'@localhost identified by '用户密码';

Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.00 sec)

mysql> quit

Bye

root@iZ2zeeg42qkecbhciml4pcZ:~#

2.下载WordPress并安装:

获取WordPress软件:点击此处

将下载的wordpress-5.0.3-

zh_CN.tar.gz

上传到云服务器上

安装wordPress:

root@iZ2zeeg42qkecbhciml4pcZ:~# ls

wordpress-5.0.3-zh_CN.tar.gz

root@iZ2zeeg42qkecbhciml4pcZ:~# mv wordpress-5.0.3-zh_CN.tar.gz /var/www/

root@iZ2zeeg42qkecbhciml4pcZ:~# cd /var/www/

root@iZ2zeeg42qkecbhciml4pcZ:/var/www# ls

html wordpress-5.0.3-zh_CN.tar.gz

root@iZ2zeeg42qkecbhciml4pcZ:/var/www# tar -zxvf wordpress-5.0.3-zh_CN.tar.gz

......

root@iZ2zeeg42qkecbhciml4pcZ:/var/www# ls

html wordpress wordpress-5.0.3-zh_CN.tar.gz

root@iZ2zeeg42qkecbhciml4pcZ:/var/www# cd wordpress/

root@iZ2zeeg42qkecbhciml4pcZ:/var/www/wordpress# ls

index.php readme.html wp-admin wp-comments-post.php wp-content wp-includes wp-load.php wp-

mail.php

wp-signup.php xmlrpc.php

license.txt

wp-activate.php wp-blog-header.php wp-config-sample.php wp-cron.php wp-links-opml.php wp-login.php wp-settings.php wp-trackback.php

root@iZ2zeeg42qkecbhciml4pcZ:/var/www/wordpress# mv wp-config-sample.php wp-

config.php

使用vim命令编辑wp-config.php:

vim wp-config.php

修改文件中的数据库配置信息,填写刚才创建的数据库信息:

/** WordPress数据库的名称 */

define('DB_NAME', '数据库名称');

/** MySQL数据库用户名 */

define('DB_USER', '用户名');

/** MySQL数据库密码 */

define('DB_PASSWORD', '数据库密码');

/**

* WordPress数据表前缀。

*

* 如果您有在同一数据库内安装多个WordPress的需求,请为每个WordPress设置

* 不同的数据表前缀。前缀名只能为数字、字母加下划线。

*/

$table_prefix = 'wp_';

在阿里云控制台将域名解析到指定的服务器上:

控制台->域名->解析->添加纪录

配置服务安全组策略,将80(http)端口和443(https)端口开放:

控制台->云服务器ECS->网络和安全->安全组->配置规则

配置80端口:

配置443端口:

配置后查看内容:

编辑Nginx配置文件:/etc/nginx/sites-available/default

client_max_body_size 10m;

server {

listen 80;

listen [::]:80;

server_name localhost; #你的域名

root /var/www/wordpress;

index index.php index.html index.htm index.nginx-debian.html;

location / {

# First attempt to serve request as file, then

# as directory, then fall back to displaying a 404.

#try_files $uri $uri/ =404;

try_files $uri $uri/ /index.php?$args;

}

location ~ \.php$ {

# include fastcgi.conf;

include fastcgi_params;

fastcgi_buffer_size 128k;

fastcgi_buffers 32 32k;

#fastcgi_intercept_errors on;

# With php-fpm (or other unix sockets):

fastcgi_pass unix:/var/run/php/php7.2-fpm.sock;

# With php-cgi (or other tcp sockets):

#fastcgi_pass 127.0.0.1:9000;

}

}

重启Nginx后,在浏览器中输入http://阿里云服务器外网IP地址/

service nginx stop

service nginx start

在浏览器中访问自己的域名,查看是否成功:

到此WordPress就安装成功了,你可以自行配制您的网站信息。

足反射疗法是一门科学的治疗保健养生方法吗?

作为脊柱反射疗法和分形针原创发明人的回答是肯定的。不要把反射一词理解的太呆板也不可太玄忽,而是将其定义域和值域恰到好处的在现代分形几何学(1982)一书的基本理论。因那是苐一直觉感悟到一个不懂易经的IBM 数学家能在分形一词,概括道尽如此简单却又深刻对复杂现象的领悟。分形几何现象从宏观到微观现象在时空里的几何循环,展示一种宇宙精神所谓天不变道亦不变。分形几何用四种分形属性,自相似性,自对称性,微结构性和自仿射性来描述宇宙复杂性。其中对称性李政道杨振宁的诺贝尔奖课题研究很深刻的了。而且正是这划时代的研究催生了分形几何的问世。

道人注意到的是自反射性涉及到局部与其他局部,局部与全部之间的现象全息关系道尽了宇称守恒的基本逻辑时空结构,杨振宁称奇偶对称,在亚利桑那大学生命科学贝克思同教授探讨这个奇偶对称结构与奇偶宇称守恒定律间的关系时,道人用简单的例子说出了器官数和器官功能的奇偶关系,如耳眼偶数器官只有一个功能,而奇数器官,鼻子嘴巴生殖器官却有偶数功能。这番不可思议神话只有留给施一公和颜院士这些大伽了。

道人的小打小闹只是把传统推拿按摩和针灸要用分形逻辑思维模式走出一个手上功夫可以替代繁重要的厨子和打扫电影院的劳累,因到帝国理工时已是五十多了,为挣学费和生存一天要打二分工。那个时代帝国理工的博士生都在打工。直到脊柱反射疗法和分形针炙练得手到病除才彻底离开厨子一行。反射全息在宏观宇宙里的无处不在,石头与大山,浮云与兰天,枝叶与森林,,,

然让一个革命思维模式的获得是对传统针灸推拿的再思考,即古人是如何发现用针制痛的?(详见头条相关内容)很快可以-确定一个古人的知识控制论模型,knowledge cybernetics model. 健康机体气机流通,故天痛。若不通则痛,一根针的刺激,一个推拿手法的刺激立刻恢解除和恢复流通,测痛消失,故分形针法只用一根针。如此简单的道理,那未

传统经络针灸推拿是一个数千年宝厍?或者是一个大垃圾坑?千百年来分形逻辑思维系统发生器接受了这个挑战,在中国经络理论被黄帝内经九针十二原被视为人类文明史上最牛的,无人敢于置疑的神聖经典。在构思分形针灸和脊柱反射疗法时有过一段举棋不定的苦心。是复兴返回到黄帝内经系统?还是从人类文明苐一针?几经周折最后决定重走针灸进化的从零开始。下这么大的决心是避免了针灸历史上的那些想当然,随心所欲的专家们凭空捏造理论的俗不可耐的想当然和自以为是。这种局势目前在头条依然泛滥成灾。因为易经逻辑和现代分形几何学的如此合拍,简单的说后者的问世就是为着证明前者一样。而易经从古至今就设有人像本道人这样精通,悟出分形逻辑而悟一达万。自信心十足决定用分形发生器原则重新结构针灸疗法。

这个想法注定了分形针灸的成功,在分形这科学平台上,分形几何的基本框架上需要直面针刺疗法的苐一个,也是唯一的一个问题是疼痛发生的几何学位置和进针几何学位置之间的分形关系,这一问的答案自仿性解决了分形针灸和脊柱反射疗法的理论问题。这解决了针哪里的运作模式。也就是说分形针灸建筑在仿射性关系上,于是乎对称,自相似,微结构取穴法代替了传统针灸的固定经络穴位进针的人造系统。而分形针灸则用一个不断在时空中变化的分形几何学关系的取穴方法。分形针灸在九十年代大行其道,世纪之初在英国爆红,是NHS要立一个针灸课题以解决疼痛问题。在数以百计的正规中医药大学毕业生应招而不果,道人的分形针法力压群雄而夺帅旗。到今天脊柱反射疗法和分形针已传到六十多国,而且道人签发的资格证书是欧美承认,且学生可以进NHS系统作针灸师。

参考文献Positive Health Online Your Country HOME ARTICLES BACK ISSUES BOOK REVIEWS RESEARCH EVENTS PRODUCTS Add as bookmark Fractal Acupuncture by Dr Zude Ye and Zoe Desmond(more info) listed in acupuncture, originally published in issue 62 - March 2001 How the Therapy was Developed Twelve years ago, during a fellowship at the Life Science Department of Arizona State University, Dr Ye, a Chinese medic and biostatistician, was discussing the body's organs and their function with colleagues, and he realized that he'd found a mathematical pattern regarding the human body, that is: multiple organs have singular functions, and a singular organ has multiple functions. He explained using the Taoist canon that organs are either yin or yang. A yang (singular) organ has a yin (double) function, while a yin (double) organ has a yang (single) function. One mouth has two functions, eating and speaking, one nose can breathe and smell, but the two eyes have the singular function of seeing, and the two ears can only hear. This is true of plants and animals as well as humans: a universal law. Dr Ye's wisdom was recognized by the University of Arizona, which awarded him an outstanding merit award in 1988. Point for water retention. '3 fingers' down from the elbow Seeing life in terms of a garden made of mathematical patterns fuelled Dr Ye's lifelong project to find an effective, simple holistic therapy. This new way of seeing the human body led him to study fractal theory, but with the intention of finding a holistic therapy. Whilst working as a research fellow for Imperial College London, Dr Ye developed fractal needle acupuncture, as well as extending traditional foot reflexology to every independent body part, thus developing spinal reflexology and facial reflexology. He has also founded golden section therapy and a form of needle therapy called time therapy. He includes them under the umbrella of fractal therapies, and has had successful practices in Arizona, London, Liverpool, Scotland and Devon. The Fractal Needle Theoretical Base A fractal is made up of parts that are in some way similar to the whole, i.e., a human is a microcosm of the macro – the universe. This similarity is not only a property of the fractal, it also defines a fractal. It is a geometric figure in which an identical motif repeats itself throughout its structure. We can easily apply this to the human body, as we do in reflexology using the foot as a micro of the whole body. Everything in the universe has a fractal structure, the idea of a human as a microcosm of the universe is behind much of Chinese and East Asian philosophy, and is the framework for Chinese medicine. The basic nature of a fractal is self-similarity, or self-affinity. It is a fine structure centre enlarger; what is at the centre repeats itself throughout the whole. So if we puncture a point in the arm that is a micro of the stomach, the sensation 'ripples' out to that part of the whole with which it shares an affinity. The Fractal Needle in Practice and How It Differs from Traditional Acupuncture Dr Ye has worked alone practising these therapies, quickly gaining many patients by word of mouth. Eventually a project researcher from Bristol University came to collect his cases for special research. His work was selected for study by Janet Conneely at the School of Medicine[1] because clear evidence emerged of the striking and rapid cure of patients who had experienced difficult illness. The sample of cases revealed this treatment works where very expensive and long-running NHS treatments have failed. Fractal therapies quickly treat difficult illnesses. Many patients of Dr Ye have 'untreatable' conditions. Often the patient has to rely on pain-killing, mind-numbing medication for the rest of their lives, switching drugs when the body becomes resistant to them, or when the side effects become unbearable. Asthma, prostate conditions, Parkinson's disease, psoriasis, menstrual disorders, and any kind of pain have been treated by fractal therapy. We also have success in treating patients with psychological and emotional disorders. We are currently seeking funding to research our practices through controlled trials, hopefully in order to promote its use amongst health professionals and to investigate how the therapies work. Dr Ye believes that the human body system uses the effects of one needle puncture to wake up a human's innate spontaneous healing ability. In some cases, like viral infections, it gives the often sluggish immune system a kick-start. The body is a self-organizing system; one-needle or one-finger stimulation at the right location will wake up the defence function to restore the balance, as reflexologists and masseurs know. Instead of chemicals doing the work to combat a condition, the fractal needle stimulates the body to balance itself, restoring order, and therefore 'normal' health. Dr Ye teaches each patient to treat themselves; he and his students all treat themselves. Self-treatment removes dependence on the therapist, promotes responsibility for self-healing and saves money for the patient. Western patients may find self-acupuncture a challenging concept at first, but the effectiveness of the treatment provides sufficient motivation. Traditional acupuncture uses affinity and similarity in treatment; for example, if the upper body part has illness the treatment involves the lower part, and vice versa, but fractal needle acupuncture takes this principle further, so that only a single needle is needed to provide a complete treatment. The first textbook of acupuncture was The Yellow Emperor's Classic of Internal Medicine. It seems to us that the Yellow Emperor's Classic of Internal Medicine's structure, or form of acupuncture, is an ancient model of the modern fractal theory. We can find a link between the new therapy and the ancient way by looking at the main principles of The Yellow Emperor's Classic: Self-similarity – every meridian has the five element points, every point with the same element treating the corresponding disease. The five points become progressively stronger, as the first is called the 'well', the second is the 'stream', the third is the 'river', the fourth is the 'lake', and the fifth is the' sea'. So if there is a fever, treat the 'well'; if the stomach is in pain, treat the 'stream'. If the left side has the problem, according to the Yellow Emperor, the right side should be treated. The same rule applies if the upper body has a problem, whereby the lower body should be treated. We can link this with the fractal's properties of self-affinity, and self-symmetry – like treats like. Fine structure is the structure of the phenomenon of time, as described by modern scientific theory. This fine structure has a connection with the ancient text in the sense that time acupuncture, called zi wu liu chu, treats the human body as a clock, with each meridian and organ 'opening' at a specific time, so the acupuncturist gives the optimum treatment at the optimum time. The human body's fine structure of time links with the fine structure of time outside the body, the micro with the macro. Fine structure with time together offer a most effective treatment approach. The most obvious difference between the fractal needle and traditional acupuncture is that the fractal needle uses one needle rather than the multiple needles of traditional acupuncture. We have found that one input creates multiple effects, and is sufficient to treat illness if the correct point is stimulated. Case Studies We will use examples of real cases to illustrate how the fractal needle is used. Case Study 1 The patient is 25 years old and suffers from water retention, which causes discomfort and swelling in the stomach area. First she is diagnosed in the traditional Chinese fashion by taking the pulse on each wrist, looking at the tongue and asking questions about eating and toilet habits. It is found through this holistic diagnosis that her problem lies in the spleen and stomach – this corresponds with the element of earth in the Chinese system. We can understand the five elements system by seeing that earth controls the element of water, so we treat the spleen as it correlates with earth energy. After treatment to reinforce the earth energy, it will be able to control the water, stopping the water retention. The fractal point for the spleen/stomach is half way down the forearm on the inside, or half way down the lower leg on the inside. This is using the arm or leg as a microcosm of the whole body, as the spleen and stomach are in the middle, so the fractal needle point is in the middle of the independent parts: leg or arm. Part of the treatment is to show the patient how to use the needle for themselves. The patient is shown the point on the arm or leg and shown how to find it using touch. She will know the point because it is the part that when pressed firmly causes the most reaction. She is given a needle, which has a plastic outer tube akin to a tampon applicator, and she inserts her own needle. It is inserted deeply, until it cannot go in any further, and then she is shown how to manipulate the needle. The benefit of this self-puncture is that the patient has a continual treatment. The effects of acupuncture only last, at best, 48 hours, but she is able to treat herself at any time, so the energy flow is reinforced continually. We tell her that she should puncture herself at least twice a day, more if she needs it. After three days her condition was relieved and she no longer needed to treat herself. The fractal needle can be used for difficult psychological problems as the following case illustrates. Case Study 2 A male patient aged 32 came into the clinic. He seemed agitated and low in self-esteem. He had a 'psychotic' episode the previous year, and, following hospital treatment, he experienced psychological problems that left him unable to work. He complained of heart palpitations in situations when he was with strangers. If in a situation like this, he would worry about needing the toilet, and being afraid to ask a stranger where it is caused great nervousness and worry about losing control of his bladder, which in turn caused him to need to urinate excessively. He was told by his doctor that there was nothing that could be done and was prescribed tranquillizers. The patient stated that he didn't like the effect they were having on him and wanted to try the fractal needle. He was diagnosed using the pulse to detect which of the five elements energy was at the root of his problem. His problem lay in the water energy; losing control of it meant that the kidney energy that corresponds to the element of water was deficient. The earth energy manages the element water, so the diagnosis found that the earth energy, i.e. the spleen and stomach, had to be reinforced. The fractal needle point doesn't have to be the same for everyone with a stomach/earth energy problem. The beauty of the fractal means that there is a choice of points that can be used. In this case, the point was at the base of the gastrocnemius (calf muscle). The patient returned after one week and he said that he no longer had the problem. He was treating himself twice a day and no longer felt as though he was losing control of his bladder in situations that he found stressful. Two weeks later he returned, looking like a different person. He seemed to be brimming with confidence, and told us that he had found a job, ironically in water management for the local council! Case Study 3 Dr Ye has had remarkable success in cases of asthmatics. The University of Southampton, under Professor Stephen Holgate, is currently looking into researching the effectiveness of acupuncture in terminal breathlessness using traditional acupuncture. However, the fractal needle technique allows the patient to control the condition themselves, giving them independence and freedom. The needle's stimulation causes an immediate reaction of free breathing, as he found in the case of a man aged 34, who had been dependent on his inhaler for a number of years. A holistic therapist himself, he was eager to find an alternative remedy. After the diagnosis to find what was at the root of his asthma, the needle was inserted in the point and immediately he felt his breathing had eased. He was shown how to puncture the point himself whenever he felt short of breath, instead of reaching for his inhaler. He wrote to Dr Ye after a few months, thanking him for the treatment, which had enabled him to throw away his inhalers and enjoy a finer quality of life after many years of suffering. Some of Dr Ye's asthma patients who are children have found that after two months of using the needle they can stop using inhalers without the asthma recurring. We need to do more academic research to find out statistically how effective the treatment is, and to find out how it works physically. In cases of Parkinson's disease, the fractal provides the best relief from the symptoms. The patients still have the condition, but with every puncture from the needle, the shakes stop. The effects last for a day or so depending on the individual, but with this technique, as the patient can self-treat, he/she is able to control the symptoms to great effect. Another difficult condition is prostatism. In one patient's own words: "Dr Ye's treatment produced a spectacular breakthrough the same day with rapid improvement ever since the first session on 19 January 2000. This was after I had abandoned hope following having been treated on the NHS with string dosages of antibiotics for a year 1996-7: ciprofloxacin 250mg – up to 2 twice a day (4 a day), or other long running antibiotics, and ever since I have had constant pain in the prostate area that varied in intensity and could be very depressing and debilitating, waking me at night. I experienced over frequent urination and involuntary urination, I also had homeopathic treatment which proved ineffective."[2] Another patient's testimony in the form of a questionnaire for Bristol University is as follows: 1) How I felt before treatment: Debilitated for one year. Exhausted, disinterested, unable to earn my living. Chest pains, physical exhaustion – after going twice up stairs. Unable to tolerate social interaction. 2) How the treatment made me feel: Gradual increase in energy and interest in life. Exhaustion level now normal for my age. Chest pains much decreased. 3) What the treatment involved: Acupuncture from Dr Ye followed by self-acupuncture and follow-ups from Dr Ye. 4) How I was helped by the treatment: The acupuncture seemed to redress some inner balance, which has remained. This changed my energy in some fundamental way. I feel returned to my healthy true self. References 1. To be published in October 2001. 2. Name of patient not supplied for publication. Bibliography Liu Bing Quan. Optimum Time for Acupuncture – A Collection of Traditional Chinese Chronotherapeutics. Shandong Science and Technology Press. China. 1988. Najing College of Traditional Chinese Medicine. Acupuncture and Moxibustion. Shanghai Scientific and Technologic Publishing Agency. China. 1979.What is Reflexology? Reflexology is a complementary therapy that is based on the theory that different points and areas on the feet, lower leg, hands, face and ears correspond with different areas of the body. Reflexology is an ancient therapy which has been practised for over 5000 years and we believe that working these points or areas can help aid relaxation, improve mood, release tension, enhance sleep and can generally help improve wellbeing; allowing us to cope better with the stresses that life can bring. We acknowledge that every person is unique and some people find other things improve as well - the only way to know if reflexology will help you is to try it! To find out more about reflexology have a look at our interactive foot chart and hand chart or to watch videos about how reflexology can help visit our YouTube channel. Contact us for advice We provide a dedicated advice line for therapists and members of the public which is open five days a week between 8.30am – 4.30pm. If

关于辅音连缀?

apple,simple,sampletrouble,table,ablelittle,battle,titlenoodle, fiddle,middlecircle,bicycle,sparklesingle,google, strugglerifle,arrival, vival, levelfinal,finals, fatal

win7可以精简哪些组件?

精简掉的组件详览:

1、 Character Map 字符映射表

2、 Games 系统自带的小游戏

3、 On-Screen Magnifier 放大镜

4、 Projictor Connectivity 网络投影仪

5、 Speech Support 语音识别

6、 Sticky Notes 便签

7、 Welcome Center 欢迎中心

8、 Windows Contact 联系人

9、 Windows FAX and Scanner 收发传真

10、Windows SideShow 辅助屏幕

11、Wordpad 写字板

12、Write 写字板 驱动:

13、1394 Driver 视频采集卡驱动

14、Display 显卡驱动除了 StandardVGA Graphic Adapter 保留外,其余全部移除

15、MediaManagers 媒体管理器-- WindowsSideShow Drivers

16、Modem 调制解调器驱动

17、Printers 打印机驱动

18、TV Tuners 电视调解器驱动

19、Diva Client 语音、会议、传真设备驱动

20、FloppyDriver 软驱驱动

21、Smart CardDrivers 智能卡驱动 语言包

22、两项 Chinese 语言和 Japanese 语言保留,其余全部删除 多媒体程序

23、Autoplay 自动播放

24、Mobile resentation 演示设置

25、Sample Musicand Videos 示例音乐和视频

26、SamplePictures 示例图片

27、Windows DVDMaker 自带的 DVD 视频制作工具

28、Windows ISOBurn 自带的刻录程序

29、WindowsMedia Center 媒体中心

30、WindowsMedia Player 自带的媒体播放器 网络程序

31、Connect ToNetwork Projector 连接网络投影仪

32、RemoteDesktop and Assistance 远程桌面及辅助工具

33、RemoteDesktop Connection 远程桌面 系统功能

34、AdapterTroubleshotter 疑难解答平台

35、Advanced UAC 用户账户控制设置

36、Auto FileSystem Converter 文件系统转换器

37、CorruptedFile Recovery 数据恢复程序

38、DiskQuotta 磁盘配额

39、DisplayColor Calibration 颜色校准工具

40、EventingCommand Line Utility 自动接收公共信息。

41、IMAPIv2Burning Support 系统自带的刻录工具。

42、Location andMobile PC Sensor 本地和移动传感器。

43、MicrosoftCustom Dictionary 自定义词典

44、MicrosoftSync Center 同步中心

45、Narrator 屏幕阅读工具

46、On ScreenKeyboard 屏幕软键盘

47、Recovery Windows 自带的系统恢复

48、SystemRestore Windows 自带的系统恢复

49、TablePC 平板电脑的相关功能

50、User AccountControl 用户账户控制设置

51、WindowsCabinet Maker 用于创建 cab 文件

52、Windows EasyTransfer 轻松传送

53、WindowsHelp 系统帮助文档

54、WindowsMemory Diagnostic 系统内存测试工具

55、WindowsPowerShell 命令行脚本语言编辑工具

56、Windows SQMConsolidater 客户体验改善计划

57、XPSViewer 浏览 XPS 文件 58、Zip Folder 系统自带的查看压缩文件的工具

python如何读写excel表格?

这个问题以前回答过,这里再总结一下,目前来说,有3种常见的python读写excel表格的方式,分别是xlrd和xlwt、openpyxl和pandas,这3种方法读写excel表格都挺简单的,下面我简单介绍一下这3种方式是如何读写excel的,实验环境win10+python3.6+pycharm5.0,主要内容如下:

为了更好地说明问题,这里我新建了一个grade.xls文件,数据都是随机填写的,后面读取的内容都是这个excel表格,截图如下:

xlrd和xlwt:这是最基本的2个读写excel表格的库,其中xlrd专门用于读取excel表格内容,xlwt专门用于写入excel表格,相关测试代码及截图如下:

1.首先,安装xlrd和xlwt,这个直接在cmd窗口输入命令“pip install xlrd xlwt”就行,如下:

2.xlrd读取excel表格,这里主要读取了表格所有行数、列数,以及单元格、行列内容,代码如下:

程序截图如下:

3.xlwt写入excel表格,这里比较简单,只需要按照行号和列好定位到对应单元格,再写入就行,代码如下:

写入excel表格内容如下:

openpyxl:这也是一个专门用于读写excel表格的库,读写方式与xlrd、xlwt类似,只不过只能是xlsx格式的excel,不能是xls类型的,不然会报错,相关测试代码及截图如下:

1.首先,安装openpyxl,这个直接在cmd窗口输入命令“pip install openpyxl”就行,如下:

2.读取excel表格,代码如下,很简单:

程序运行截图如下:

3.写入excel表格,这个代码也很简单,写入对应单元格就行:

写入excel表格的内容如下:

pandas:这是一种最简单的读写excel表格的方式,只需一行代码就能读写excel表格的内容,在数据处理上经常会用到,是一个很不错的库,相关测试代码及截图如下:

1.首先,安装pandas,这个由上面一样,直接输入命令“pip install pandas”就行,如下:

2.pandas读取excel表格,这里只需一行代码就能读取excel内容,主要用到read_excel这个函数,这里默认会读取列标题,如果不需要,设置header=None就行,如果需要做统计分析的话,也可以利用groupby等函数进行处理:

程序运行截图如下:

3.pandas写入excel表格,主要用到to_excel这个函数,也是一行代码就能保存,如果不需要index索引的话,设置index=False就行,代码如下:

写入excel表格内容如下:

至此,我们就完成了利用python来读写excel表格。总的来说,这个3种方式都挺简单的,只要你有一定python基础,熟悉一下相关代码,很快就能掌握的,当然,你也可以利用其它库读写excel表格内容,像win32com,xlswrite等,这里就不详细介绍了,网上也有相关资料和教程可供参考,感兴趣的可以搜一下,希望以上分享的内容能对你有所帮助吧。

发表评论

快捷回复: 表情:
AddoilApplauseBadlaughBombCoffeeFabulousFacepalmFecesFrownHeyhaInsidiousKeepFightingNoProbPigHeadShockedSinistersmileSlapSocialSweatTolaughWatermelonWittyWowYeahYellowdog
评论列表 (暂无评论,70人围观)

还没有评论,来说两句吧...