How to read cell data in excel and output to command prompt?

I find OLEDB and the Office 2007 drivers a little easier to use. If you don't have Office 2007, ou can download the drives from MS.

I find OLEDB and the Office 2007 drivers a little easier to use. If you don't have Office 2007, ou can download the drives from MS. $filepath = 'C:\Users\u00\documents\backupset.

Xlsx' #Choose connection string based on version #Connection String for Excel 2007: $connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=`"$filepath`";Extended Properties=`"Excel 12.0 Xml;HDR=YES`";" #Connection String for Excel 2003: #$connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=`"$filepath`";Extended Properties=`"Excel 8.0;HDR=Yes;IMEX=1`";" $qry = 'select * from sheet1$' $conn.open() $cmd = new-object System.Data.OleDb. OleDbCommand($qry,$conn) $da = new-object System.Data.OleDb. OleDbDataAdapter($cmd) $dt = new-object System.Data.

DataTable void$da. Fill($dt) $conn.close() $dt.

Thanks for your help...I have fixed the problem! I was using PowerShell V2 CTP2, now I have upgraded to CTP3 this has fixed the language barrier problem and I can now run scripts without worrying about the invoke function and all is fine! Many Thanks Max.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.