当前位置：文档之家 › workbook uint 2 uint 2

workbook uint 2 uint 2

  • 格式：doc
  • 大小：49.00 KB
  • 文档页数：11

Unit 2

P 16 Vocabulary

C 1.It was very_____ you------remember my birthday

A.consider of; to B. consider able of; of

C. considerate of; to D. considered of; to

C 2.He ran to the table and _________the phone

A. picked off B. picked out C. pick out D. picked on

B 3.I don’t think that your watch is________.

A. worthy the price B. worth the price

C. worth D. worth to buy

C 4.she love teaching. if she _____a second life to live ,she

____teaching as her career again.

A.is to be give; will choose B. is given; chooses

C. were given; would choose D. were give; choose

D 5. The teacher is instructing us _____how ______use the

computer.

A. to; to B. for; in C. of; to D. in; to

B 6. There appears in the city the increase of traffic jam that

____new roads.

A. comes up with B. comes with

C. comes up to D. comes up

C . 7. Yesterday I was busy finishing my homework ____.

A.to the moment B. for the moment C. at the moment

Don the moment.

D 8 As a student, you _____ your attention ____study.

A.concentrate; in B. should concentrate ;in

C. concentrate D. should concentrate ;on

B 9. I don’t have enough money ______,but I’ll give it to

you ,late.

A.is decorated B. decorates with

C. is decorating D is decorated for

A 10. The big hall _______beautiful flowers.

A is decorated with B. decorates with

C. is decorating with D. is decorated for

P19 grammar

A. 1 We hadn’t met for 20 years, but I recognized her

____I saw her .

A.the moment B. for the moment

C. the moment when D. at the moment when

B.2_______I reached home ____it began to rain .

A.No sooner, than B. No sooner when

C. No sooner had, than D. No sooner had ,when

B 3 He had _____entered the room ____the phone rang.

A.hardly, than B. scarcely, when

C. scarcely, than D. barely, than

B.4She is always listening to music ______her phone

rang

A.When do B. When doing C. While do D. after do

A.5 _____the firemen heard the alarm ,they fell in for

action .

B.The instant(that) B. The instant when

C. For the instant that D. For the instant when

C 6_____I met with difficulty, he came to my help .

A.Whoever B. Whatever C. Whenever D. Whichever

D 7_____he goes to the town, he visits his aunt .

A.Before B. After C. Since D. Whenever

A 8. She informed her husband _____she arrived home

A.As soon as B. before C. after D. as

D 9. _____the doctor her husband ____she arrived home

A.Hardly ,than B. Hardly when

C. Hardly had ,than D. Hardly had ,when

D 10 I know nothing about English ______I entered this

school .

A. after B. when C. as soon as D. before.

P21 PASSAGE 1

World Environment Day was established by the United

Nations General Assembly in 1972nto create the opening of the

Stockholm Conference on the Human Environment .Another resolution ,adopted by the General Assembly the same day ,led

to the creation of UNEP [United Nations Environment

Program]

World Environment Day can be celebrated in mang

ways ,including street rallies ,bicycle parades,green concert ,essay and poster competitions in school ,tree

planting,recycling efforts ,clean-up campaigns and much more.

Heads of State ,prime Minister and Ministers of Environment

deliver statement and commit themselves to care for the

Earth .More serious pledgeare made which lead to

the establishment of permanent governmental structures dealing

with environment management and economic planning .This

observance also provides an opportunity to

sign or ratify international environ-metal conventions.

World Environment Day ,commemoratedeach

year on 5 June is one of the principal vehiclesthrough which the United Nation stimu-lates worldwide

awareness of the environment and enhances political attention

and action

The world Environment Day theme selected for 2014 is

“Wanted! Sans and oceans-----Dead or Alive ?” The theme ask

that we make a choice as to how we want to treat the Earth’s seas and oceans. It also calls on each and every one of us to

act .Do we want to keep seas and oceans healthy and alive or

polluted and dead ?

It will be held in Barcelona ,Spain in close collaboration with the Universal Forum of Cultures .UNEP is honored

that the City of Barcelona ,the Catalan Regional Government

and Government and the Government of Spain will be hosting

this important United Nations day.

Previous Themes

2003 Water ---two billion People are Dying for It !

合集下载

workbook删除sheet的方法

workbook删除sheet的方法

workbook删除sheet的方法

Workbook是Excel工作簿对象，它包含了一系列的Sheet。在某些情况下，我们可能需要删除不需要的Sheet来简化工作簿结构或释放内存空间。本文将介绍一些常见的方法来删除Workbook中的Sheet，包括使用Excel VBA宏和Python的openpyxl库。

一、使用Excel VBA宏删除Sheet

Excel VBA是一种基于Visual Basic的编程语言，可以用于自动化操作Excel工作簿和Sheet。下面是一些常用的删除Sheet的VBA方法：

1. 使用Sheet对象的Delete方法删除Sheet：

```vba

Sub DeleteSheet()

Dim ws As Worksheet

Set ws = ThisWorkbook.Sheets("Sheet1") '需要删除的Sheet

Application.DisplayAlerts = False '禁止显示警告对话框

ws.Delete

Application.DisplayAlerts = True '重新启用显示警告对话框

End Sub

```

上述代码中，我们首先通过`ThisWorkbook.Sheets("Sheet1")`获取需要删除的Sheet对象，然后使用Sheet对象的Delete方法删除该Sheet。需要注意的是，在删除Sheet之前，我们需要通过`Application.DisplayAlerts = False`先禁止显示警告对话框，然后通过`Application.DisplayAlerts =

True`重新启用显示警告对话框。

2. 使用Workbook对象的Worksheets属性删除Sheet：

```vba

Sub DeleteSheet()

Dim wb As Workbook

Whats your favorite food教学设计教学备课教案

Whats your favorite food教学设计教学备课教案

PEP5 Unit3 What’s your favorite food?

（一）教学内容

What’s your favorite food?是义务教育课程，标准实验教科书人教版五年级上册Unit3 PartA 的第一课，包括Let’s learn和Group work两部分。

（二）教学目标

1、能力目标：能够提问并回答三餐所吃的食物，如：What would you like for lunch

today? I’d like …… ……

2、知识目标：认识Let’s learn的单词和句子（pork、tofu、mutton、cabbage、tomato、eggplant、green beans、potato、fish），并了解Group work的内容

3、情感目标：注重培养学生健康合理饮食的观念。

（三）教学准备

简易的食物图片、词卡、厨师帽、PPT

（四）教学重点和难点

重点：A．能够用句型What would you have for lunch? 对别人吃些什么进行提问。

B．能用句型I’d like ….表达自己喜欢食物。

C．能初步掌握四会单词：potato ,tomato ,fish ,tofu , eggplant ,green beans.

D.能听说认读单词：pork ,cabbage ,mutton.

难点：生词pork ,mutton, cabbage ,eggplant的发音，并注意tomato 和potato的复数形式。

（五）教学过程

一、Warm up

1、Let’s chant.播放四年级下册第六单元73页的儿歌，学生说唱，活跃气氛，以及复习tomato 和potato单词。

2、Let’s say.帮助学生复习What would you like? I’ d like some…的问答。

二、Presentation

单词呈现

1、tomato. 由Let’s say直接引出单词tomato进行教学，师按音节教读：tomato

Workbook对象

Workbook对象

Workbook对象

上一期我们了解了Application对象，本期我们认识Workbook (工作簿)对象，看看VBA是怎么操作工作簿的？

01

Add、SaveAs、Clos方法

下面的练习将让你了解新建、命名、保存指定路径、关闭工作簿等操作。

Sub 新建工作簿()

Dim WB As workbook '定义WB为Workbook对象

On Error Resume Next '如有错误则跳过

Kill ThisWorkbook.Path & 'D:\CN\我的工作簿.xls' 删除同名文件

Set WB = Workbooks.Add '新建工作簿

WB.Password = '533' '设置工作表密码为533

WB.SaveAs Filename:='D:\CN\我的工作簿.xls' '工作簿保存路径

WB.Close False '关闭工作簿

End Sub

代码说明：

1.上面的代码使用了Kill、Add、SaveAs、Clos方法和On Error Resume Next语句；

2.首先为了预防同文件下有相同文件的工作簿，代码运用Kill语句删除同名文件；

3.没有同名文件程序就会提示找不到该文件，使用On Error Resume Next这条语句，它可以忽略下一个错误继续往后执行,是处理错误时常用语句；

4.Add方法可以新建了一个工作簿，使用PassWord属性设置打开文件密码为”533“；

5.用SaveAs方法将文件保存，用Close方法关闭工作簿；

我们需要重点了解一下SaveAs方法，他相当于Excel中新建工作簿后保存时弹出的另存为对话框，使用时SaveAs需要完整的路径名做参数；SaveAs参数比较多( FileName , FileFormat , Password , WriteResPassword , ReadOnlyRecommended , CreateBackup ,AccessMode , ConflictResolution , AddToMru , TextCodepage , TextVisualLayout , Local )，下面附上SaveAs的部分参数说明，对应的含义请查参数表:

workbook合并单元格方法

workbook合并单元格方法

workbook合并单元格方法

Workbook合并单元格方法

在Excel中，合并单元格是一种常见的操作，可以将多个单元格合并成一个单元格。Workbook是Excel中的一个对象，可以用来操作和管理Excel文件。在Workbook中，也提供了多种方法来进行单元格的合并操作。本文将详细介绍各种Workbook合并单元格的方法。

方法一：使用merge_cells()方法

merge_cells()方法是Workbook对象中的一个方法，可以将指定范围内的单元格进行合并。具体使用方法如下：

_cells('A1:C3')

上述示例会将A1到C3范围内的单元格进行合并。

方法二：使用range()方法

range()方法是Workbook对象的另一个方法，可以一次性合并多个单元格。具体使用方法如下：

('A1:C3').merge()

上述示例会将A1到C3范围内的单元格进行合并。 方法三：使用unicel()方法

unicel()方法是Workbook对象中的一个方法，可以将多个单元格合并成一个单元格，并保留合并后单元格的值。具体使用方法如下：

('A1:C3')

上述示例会将A1到C3范围内的单元格进行合并，并将合并后单元格的值保留。

方法四：使用add_table()方法

add_table()方法可以将多个单元格作为一个表格添加到Workbook中，并进行合并操作。具体使用方法如下：

_table('A1:C3', header=True, column=True)

上述示例会将A1到C3范围内的单元格作为一个表格添加到Workbook中，并在表格中进行合并操作。

方法五：使用insert()方法

insert()方法可以将一个单元格插入到指定位置，并进行合并操作。具体使用方法如下：

('A1').merge()

上述示例会在A1单元格插入一个单元格，并将其与之前的单元格进行合并。 方法六：使用auto_merge()方法