excel函数:汉字转全拼_30天中的30个Excel函数：04

excel函数:汉字转全拼

Yesterday, in the 30XL30D challenge, we cleaned things up with the TRIM function, and learned that it's no SUBSTITUTE for calorie counting.

昨天，在30XL30D挑战赛中，我们使用TRIM功能清除了所有内容，并得知它不能替代卡路里计数。

For day 4 in the challenge, we'll examine the INFO function. Excel Help warns us to be careful with this function, or we could reveal private information to other users.

对于挑战的第4天，我们将检查INFO函数。 Excel帮助警告我们谨慎使用此功能，否则我们可能向其他用户透露私人信息。

NOTE: You can have all of the 30 Functions content in an easy-to-use single reference file -- the 30 Excel Functions in 30 Days eBook Kit ($10).

注意：您可以在一个易于使用的单个参考文件中获得这30个函数的全部内容-30天电子书工具包中的30个Excel函数 (10美元)。

So, let's take a look at the INFO information and examples, and if you have other tips or examples, please share them in the comments. And remember to guard your secrets!

因此，让我们看一下INFO信息和示例，如果还有其他提示或示例，请在评论中分享。并记住要保护您的秘密！

功能04：信息 (Function 04: INFO)

The INFO function shows information about the current operating environment.

INFO功能显示有关当前操作环境的信息。

您如何使用INFO？ (How Could You Use INFO?)

The INFO function can show information about the Excel application, such as:

INFO函数可以显示有关Excel应用程序的信息，例如：

Microsoft Excel version
Microsoft Excel版本
Number of active worksheets
活动工作表数
Current recalculation mode
当前重新计算模式

In previous versions of Excel you could also get memory information ("memavail", "memused", and "totmem"), but those type_text items are no longer supported.

在早期版本的Excel中，您还可以获得内存信息(“ memavail”，“ memused”和“ totmem”)，但是不再支持这些type_text项。

INFO语法 (INFO Syntax)

The INFO function has the following syntax:

INFO函数具有以下语法：

- type_text is one of the following items, that specifies what information you want.
  type_text是以下各项之一，用于指定所需的信息。
- "directory" Path of current directory
  “目录”当前目录的路径
- "numfile" Number of active worksheets in open workbooks.
  “ numfile”打开的工作簿中活动工作表的数量。
- "origin" Absolute cell reference of top left visible
  “原始”左上角的绝对单元格引用可见
- "osversion" Current operating system version, as text.
  “ osversion”当前操作系统版本，以文本形式。
- "recalc" Current recalculation mode; "Automatic" or "Manual".
  “ recalc”当前的重新计算模式； “自动”或“手动”。
- "release" Microsoft Excel version, as text.
  以文本形式“发布” Microsoft Excel版本。
- "system" Name of the operating environment: "pcdos" or "mac"
  “系统”操作环境的名称：“ pcdos”或“ mac”

信息陷阱 (INFO Traps)

In Excel's Help file, there is a warning that you should use the INFO function with caution, because it could reveal confidential information to other users.

在Excel的“帮助”文件中，警告您应谨慎使用INFO函数，因为它可能会向其他用户泄露机密信息。

For example, you might not want other people to see the file path that your Excel workbook is in. If you're sending an Excel file to someone else, be sure to remove any data that you don't want to share!

例如，您可能不希望其他人看到Excel工作簿所在的文件路径。如果要将Excel文件发送给其他人，请确保删除所有您不想共享的数据！

示例1：Microsoft Excel版本 (Example 1: Microsoft Excel version)

With the "release" value, you can use the INFO function to show what version of Excel is being used. The result is text, not a number.

通过“ release”值，您可以使用INFO函数来显示所使用的Excel版本。结果是文本，而不是数字。

In the screenshot below, Excel 2010 is being used, so the version number is 14.0.

在下面的屏幕快照中，正在使用Excel 2010，因此版本号为14.0。

=INFO("release")

= INFO(“发布”)

You could use the result to display a message, based on version number. =IF(C2+0<14,"Time to upgrade","Latest version")

您可以使用结果根据版本号显示消息。 = IF(C2 + 0 <14，“升级时间”，“最新版本”)

示例2：活动工作表的数量 (Example 2: Number of active worksheets)

With the "numfile" type_text value, the INFO function can show the number of active worksheets in all open workbooks. This number includes hidden sheets, sheets in hidden workbooks, and sheets in add-ins.

使用“ numfile” type_text值，INFO函数可以显示所有打开的工作簿中活动工作表的数量。此数字包括隐藏的工作表，隐藏的工作簿中的工作表和加载项中的工作表。

In this example, an add-in is running, and it has two worksheets, and the visible workbook has five worksheets. The total sheets returned by the INFO function is seven.

在此示例中，一个外接程序正在运行，并且它具有两个工作表，而可见的工作簿具有五个工作表。 INFO函数返回的总页数为7。

=INFO("numfile")

= INFO(“ numfile”)

示例3：当前重新计算模式 (Example 3: Current recalculation mode)

Instead of typing the type_text value as a string in the INFO function, you can refer to a cell that contains one of the valid values.

您可以引用包含有效值之一的单元格，而不是在INFO函数中将type_text值键入为字符串。

In this example, there is a data validation drop down list in cell B3, and the INFO function refers to it.

在此示例中，单元格B3中有一个数据验证下拉列表，并且INFO函数引用了该列表。

=INFO(B3)

= INFO(B3)

When "recalc" is selected, the result shows that the current recalculation mode is Automatic.

选择“重新计算”时，结果显示当前的重新计算模式为“自动”。

下载INFO功能文件 (Download the INFO Function File)

To see the formulas used in today's examples, you can download the INFO function sample workbook. The file is zipped, and is in Excel 2007 file format.

要查看当前示例中使用的公式，可以下载INFO函数示例工作簿 。该文件已压缩，并且为Excel 2007文件格式。