How can i get data from a iqy file??


[PS] E:\>dir *.iqy


Directory: E:\


Mode LastWriteTime Length Name
---- ------------- ------ ----
-a--- 10-May-10 10:07 AM 758 owssvr.iqy


[PS] E:\>$a = New-Object -ComObject excel.application
[PS] E:\>$iqy = $a.Workbooks.Open(".\owssvr.iqy")
Exception calling "Open" with "1" argument(s): "'.\owssvr.iqy' could
not be found. Check the spelling of the file name,
and verify that the file location is correct.
If you are trying to open the file from your list of most recently
used files on the File menu, make sure that the file
has not been renamed, moved, or deleted."
At line:1 char:25
+ $iqy = $a.Workbooks.Open <<<< (".\owssvr.iqy")
+ CategoryInfo : NotSpecified: ( [],
MethodInvocationException
+ FullyQualifiedErrorId : ComMethodTargetInvocation

[PS] E:\>

Did you try the fully qualified path to the file? In my experience COM does
not always handle relative paths correctly.

-Paul


"Sicay" wrote:

> How can i get data from a iqy file??
>
>
> [PS] E:\>dir *.iqy
>
>
> Directory: E:\
>
>
> Mode LastWriteTime Length Name
> ---- ------------- ------ ----
> -a--- 10-May-10 10:07 AM 758 owssvr.iqy
>
>
> [PS] E:\>$a = New-Object -ComObject excel.application
> [PS] E:\>$iqy = $a.Workbooks.Open(".\owssvr.iqy")
> Exception calling "Open" with "1" argument(s): "'.\owssvr.iqy' could
> not be found. Check the spelling of the file name,
> and verify that the file location is correct.
> If you are trying to open the file from your list of most recently
> used files on the File menu, make sure that the file
> has not been renamed, moved, or deleted."
> At line:1 char:25
> + $iqy = $a.Workbooks.Open <<<< (".\owssvr.iqy")
> + CategoryInfo : NotSpecified: ( [],
> MethodInvocationException
> + FullyQualifiedErrorId : ComMethodTargetInvocation
>
> [PS] E:\>
>
>
>
> .
>

On May 12, 12:43*am, PaulChavez <PaulCha...@newsgroup>
wrote:

> Did you try the fully qualified path to the file? In my experience COM does
> not always handle relative paths correctly.
>
> -Paul
>
>
>
> "Sicay" wrote:

> > How can i get data from a iqy file??

>

> > [PS] E:\>dir *.iqy

>

> > * * Directory: E:\

>

> > Mode * * * * * * * *LastWriteTime * * Length Name
> > ---- * * * * * * * *------------- * * ------ ----
> > -a--- * * * * 10-May-10 *10:07 AM * * * *758 owssvr.iqy

>

> > [PS] E:\>$a = New-Object -ComObject excel.application
> > [PS] E:\>$iqy = $a.Workbooks.Open(".\owssvr.iqy")
> > Exception calling "Open" with "1" argument(s): "'.\owssvr.iqy' could
> > not be found. Check the spelling of the file name,
> > *and verify that the file location is correct.
> > If you are trying to open the file from your list of most recently
> > used files on the File menu, make sure that the file
> > *has not been renamed, moved, or deleted."
> > At line:1 char:25
> > + $iqy = $a.Workbooks.Open <<<< (".\owssvr.iqy")
> > * * + CategoryInfo * * * * *: NotSpecified: ( [],
> > MethodInvocationException
> > * * + FullyQualifiedErrorId : ComMethodTargetInvocation

>

> > [PS] E:\>

>

> > .- Hide quoted text -

>
> - Show quoted text -

Thank Paul. It worked with full qualified path.

1 more question:
http://social.technet.microsoft.com/...a-c0aba0960ed0
What does this line do ==> $iqy.SaveAs('c:\scripts\output\1-
RawContacts.csv', 6)

..Sicay

That line saves the workbook in CSV format.

It uses the SaveAs method of the Workbook COM object:
http://msdn.microsoft.com/en-us/library/bb214129.aspx

First paremeter is file to save to, second parameter is file format as
specified in the XlFileFormat enumeration.
http://msdn.microsoft.com/en-us/library/bb241279.aspx

-Paul


"Sicay" wrote:

> 1 more question:
> http://social.technet.microsoft.com/...a-c0aba0960ed0
> What does this line do ==> $iqy.SaveAs('c:\scripts\output\1-
> RawContacts.csv', 6)
>