Vista - Re: Import .csv file

You need to make the other sheet active before you save:


$xl= new-object -com Excel.Application
$xl.visible = $true
$xl.displayalerts=$false
$wb = $xl.workbooks.open("C:\Book1.xls")
$sheet1 = $wb.worksheets | where {$_.name -eq "s1"}
$wb.saveAs("c:\sheet1.csv", 6)

$sheet2 = $wb.worksheets | where {$_.name -eq "s2"}
$sheet2.select()
$wb.saveAs("c:\sheet2.csv", 6)

$xl.quit()



To save all worksheets to csv files:

$wb.worksheets | foreach {
$_.select()
$wb.saveAs("c:\"+$_.name+".csv", 6)
}



---
Shay Levy
Windows PowerShell
http://blogs.microsoft.co.il/blogs/ScriptFanatic

I used the code, but it still won't activate the second sheet.
Everything else works just like it should but the second sheet won't
saveas and won't import in PowerShell. Is there something that I'm not
doing correctly?



ronni

I used excel 2007 to test the code, what's youre version?

What happens if you try the second part where you can save all sheets?


---
Shay Levy
Windows PowerShell MVP
http://blogs.microsoft.co.il/blogs/ScriptFanatic

I'm usng excel 2007 as well.

When I use the second part of the code, I get an error saying that I
cannot access read-only documents. I didn't see this before because I
put it in a function that I'm creating. How do I make it so that the
documents aren't in read-only?


ronni

Can you create a sample excel file with two or three sheets, save it locally
on your hard drive and try the code again.
BTW, doe's your regional settings set to en-US?


---
Shay Levy
Windows PowerShell
http://blogs.microsoft.co.il/blogs/ScriptFanatic