Export text to a microsoft excel spreadsheet, Excel spreadsheet file name format, Export text to a microsoft excel spreadsheet -7 – Rockwell Automation FactoryTalk View Machine Edition Users Guide User Manual

Page 207: Excel spreadsheet file name format -7

Advertising
background image

12

Set up language switching

12-7

• •

application language is French, and you have imported French text strings for the Change
Password window, then the French strings will be compiled in the run-time application. If
the operator opens the window, the strings will be shown in French. If the operator
changes to another language, the strings will still be shown in French.

Unicode file name format

The format for the exported Unicode text file name is
<ApplicationName><HMIServerName><RFC1766>.txt, where:

<ApplicationName> is the name of the application.

<HMIServerName> is the name of the HMI server containing the text strings you
exported. This is always the same name as the application name.

<RFC1766> is the RFC1766 name associated with the language selected for the
export operation.

For details about the schema of exported Unicode text files, see page 12-11.

For a list of Windows languages and the corresponding RFC1766 names, see page F-1.

Export text to a Microsoft Excel spreadsheet

FactoryTalk View supports Microsoft Excel versions 2000, 2002, 2003, 2007, 2010, and
2013. The exported file is in Microsoft Excel 5.0/95 Workbook format, with the extension
.xls.

Optimizing duplicate strings

When you export text to an Excel spreadsheet, you have the option of optimizing
duplicate strings. FactoryTalk View analyzes the text and indicates repeated instances of
the same string using a reference number. This way the translator only needs to translate
the text once. When you import the translated strings from the spreadsheet into the
application, FactoryTalk View copies the translated string into all the graphic objects that
used the string originally.

Excel spreadsheet file name format

The format for the exported spreadsheet file name is
<ApplicationName>_<ExportVersion>.xls, where:

<ApplicationName> is the name of the application.

<ExportVersion> is an incremental number assigned to each successful export
operation.

The maximum number of characters viewable in an Excel cell depends on the version of Excel
and the font size. If the maximum is exceeded, the cell will be blank.

Advertising