How to read out a date format cell as string from excel with PowerShell?

Posts 2

Reply

Kokai Posted: 06-22-2009 4:56 AM

rated by 0 users

Hi all!

May problem is:
I have a scirpt, that read out the data from an excel file:

Quote:

$excel=New-Object -COM Excel.Application
$ci= [System.Globalization.CultureInfo]'en-US'
$src="path:excel.xls"
$book=$excel.Workbooks.PSBase.GetType().InvokeMember('Open', [Reflection.BindingFlags]::InvokeMethod, $null,$excel.Workbooks, $src, $ci)
$sheet= 1
$sh=$book.sheets.item($sheet)

#the read out command:
[string] $sh.Cells.item($row,$col).formulaLocal

But when read out an date format cell, the result not the date, but a number..for example: 2009.06.15 will be: 39979
How can I solve this problem?
Or how can I do, that the srcipt read out the cell as a string?

Thx the help in advance!
Koky