[SOLVED] Excel Read Cell number formating information

[Blinky 7]

Hi ,

Is there a function that can get number formating of an excel cell?

i need to read prices from a column and get the currency formating because the cells are formated with diferent currencyes. or to read the formated string in the cell to include in a sql database.

thx in advance.

Edited February 15, 2012 by Blinky

[water 2,720]

This will open an existing xlsx-file and display the format of cell "A1":

#include <excel.au3>
$oExcel = _ExcelBookOpen("C:tempMappe1.xlsx")
ConsoleWrite(@error & @CRLF)
$sCellFormat = $oExcel.ActiveSheet.Range("A1").NumberFormat
ConsoleWrite($sCellFormat & @CRLF)

[Blinky 7]

Thx water this is perfect.

[water 2,720]

Glad to be of service