Re: Optional Variant

go to sourceforge and get the CVS HEAD version and use the org.jawin
branch...
----- Original Message -----
From: "Rick Stoyle" <[email protected]>
To: <[email protected]>
Sent: Monday, April 26, 2004 5:56 PM
Subject: Re: [JAWIN] Optional Variant


> The Microsoft documentation for the Excel.Workbook object lists the method
> SaveAs as the following:
>
> SaveAs(Filename, FileFormat, Password, WriteResPassword,
> ReadOnlyRecommended, CreateBackup, AddToMru, TextCodePage,
> TextVisualLayout)
>
> All the parameters except Filename are listed as "Optional Variants"
> meaning that if nothing is passed, a default value is assigned. I think a
> better description would be a variant of the "No Parameter" type
> or "Missing" like you specified.  The _Workbook stub generated by jawin is
> as follows:
>
> public void saveAs(Object Filename, Object FileFormat, Object Password,
> Object WriteResPassword, Object ReadOnlyRecommended, Object CreateBackup,
> int AddToMru, Object TextCodePage) throws COMException { }
>
> I have tried a few different things but keep getting errors back from the
> COM object about the passed parameters.  With another bridge I have used,
> the following code worked:
>
> ...
> wbook = new _Workbook("Excel.Sheet");
> Variant missing = new Variant();
> missing.noParam();
> wbook.saveAs(new String("C:\MyExcelFile.xls"), missing, missing, missing,
> missing, missing, 1, missing);
>
> But, jawin does not have this type of method for the Variant Object.  What
> would the code look like to do the same with jawin.
>
> Rick