{"searchBar":{"inputPlaceholder":"Search by keyword or ask a question","searchBtn":"Search","error":"Please enter a keyword to search"}}
{}
{}
Search FAQs

Pro-Server EX/ 4. Designate Excel Template and Output File.

Designate the template file created in 1. and output file.

[Setting Example]
Setting Item

Description

Designate Template.Template FileC:¥Documents and Settings¥Administrator¥Desktop¥templete.xls
Output FileFolder NameC:¥Documents and Settings\Administrator¥Desktop
File NameGP Log data .xls
Start from Displayed StateWith check
1.Click on the [Feature] icon on the status bar.
2.Select [Action] from the tree display on the left of the screen, then click the [Add] button.
3.Click the [ACTION Type] list button, and select "Create form using Excel". Then, enter the name of ACTION to set in the [ACTION Name] field. In this example, enter "GP Log data".
4.Click the [Click here to set the ACTION parameter] button.
text
5.Make settings regarding an Excel template and its output file.
text
・ Click the [Reference] button of [Template File] to set the template file "template.xlt" which you created.
・ Click the [Reference] button of [Folder Name] and specify "Desktop" as a folder to save the output file.
・ Set the file name "GP Log data.xls" in the [File Name] field for the output file to set.
・ Check the box of [Start from Displayed State].
MEMO
[Year/Month/Day] is set for the default, [%Y%M%D].
[Start from Displayed State] can start reading or writing data with the output file displayed, so it's useful for confirming data quickly.

Did this answer your question?