How I can insert a sheet in a excel?
Author: jmontgar@hotmail.com (jmontgar)
Hello,I use excel via COM signatures were generated by: /sti /mwr=com /pid Excel.Application:EXCEL_
How I can insert a sheet in a excel??
Thanks
Author: jmontgar@hotmail.com (jmontgar)
Hello,I use excel via COM signatures were generated by: /sti /mwr=com /pid Excel.Application:EXCEL_
How I can insert a sheet in a excel??
Thanks
Author: jmontgar@hotmail.com (jmontgar)
Hello,I use excel via COM signatures were generated by: /sti /mwr=com /pid Excel.Application:EXCEL_
How I can insert a sheet in a excel??
Thanks
Take a look at the ADD operation on your EXCEL_SHEETS signature. When I imported the signatures, the classification of the RESULT_ parameter came in as "?UNKNOWN?". I changed this to EXCEL_WORKSHEET. After that, the following code worked:
newinstance "EXCEL_APPLICATION", $excel$
$excel$->set_visible(1)
$excel$->get_workbooks($workbooks$) ; get the application's collection of workbooks
$workbooks$->add($workbook$, -) ; add a new workbook to it
$workbook$->get_worksheets($worksheets$) ; get the new workbook's collection of sheets
$worksheets$->add($worksheet$, -, -, -, -) ; add a new sheet to it
The variables are all defined as public handles.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.