Merhaba
excel için bu datayı çekerken macro kullanmanız gerekir
ve her sütün için bir tanımlama yapmanız gerekir
örnek :

Sheet1.Columns(4).NumberFormat = "MM.yyyy"

Sheet1.Columns(6).NumberFormat = "#,##0.00"
Sheet1.Columns(7).NumberFormat = "#,##0"
Sheet1.Columns(7).NumberFormat = "#,##0"


Sheet1.Columns(11).NumberFormat = "#,##0.0"
Sheet1.Columns(12).NumberFormat = "#,##0.0"
Sheet1.Columns(13).NumberFormat = "#,##0.0"
Sheet1.Columns(14).NumberFormat = "#,##0.0"
Sheet1.Columns(15).NumberFormat = "#,##0.0"
Sheet1.Columns(16).NumberFormat = "#,##0.0"
Sheet1.Columns(17).NumberFormat = "#,##0.0"
Sheet1.Columns(18).NumberFormat = "#,##0.0"
Sheet1.Columns(19).NumberFormat = "#,##0.0"
Sheet1.Columns(20).NumberFormat = "#,##0.0"
Sheet1.Columns(21).NumberFormat = "#,##0.0"
Sheet1.Columns(22).NumberFormat = "#,##0.0"
Sheet1.Columns(23).NumberFormat = "#,##0.0"


Sheet1.Columns(27).NumberFormat = "#,##0"
Sheet1.Columns(28).NumberFormat = "#,##0"
Sheet1.Columns(28).NumberFormat = "#,##0.00"
Sheet1.Columns(29).NumberFormat = "#,##0.00"