Hi
i have a requirement where i need to generate multiple excel sheets in one excel using sqr.
Any suggestions how to code?
– Shyam
Thanks for posting your question!
Option 1: Using SQR and VB Script language, we can generate an excel worksheet dynamically. You can use the following command:
Workbook.Sheets.Add
We can execute the VB Script in SQR by using CALL SYSTEM built-in
Option 2: Using SQR and XML, we can also dynamically create an excel worksheet. This is possible only by using SQR2XML utilities. Here is the link

http://sourceforge.net/project/showfiles.php?group_id=117708

Thanks
Kannappan Krishnan

Posted by Nitin Pai
Comments (0)
July 28th, 2008

Comments (0)