Thursday, July 11, 2019
Tip of the Day: Assigning the Active Sheet with Exported Workbooks
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.1.30704 or higher
Sections......: Commands
Keywords......: GATEWAY, EXPORT, Workbook, Sheet, Active
Did you know you can assign the active sheet for exported worksheets,
when a user
launches the document?
The new ACTIVE_INDEX parameter for the GATEWAY EXPORT command is able to assign
the active sheet when the workbook is opened. The value is an
integer-based index
(e.g. 1, 2, etc.).
Example:
GATEWAY EXPORT XLSW Employee.xlsx +
SELECT * FROM Employee WHERE ActivEmp = 'A' +
OPTION COL_NAMES ON +
|SHEET_NAME Active_Employees +
|SHEET_INDEX 2 +
|ACTIVE_INDEX 1 +
|SHOW_PROGRESS ON +
|MERGE_DATA ON +
|ACTION OPENVIEW
With this and many others, every "final touch" you place on your work will be
greatly appreciated by all users!
Very Best R:egards,
Razzak.
https://www.rbase.com
http://www.facebook.com/rbase/
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/201907111309.x6BD9LwN002909%40atl4mhob07.registeredsite.com.
For more options, visit https://groups.google.com/d/optout.
