Locale Issues While Exporting To Excel
Last updated on SEPTEMBER 19, 2017
Applies to:Siebel CRM - Version 15.4 [IP2015] and later
Information in this document applies to any platform.
** Checked for relevance on 14 Sep 2017 **
On : 15.4 [IP2015] version, Siebel VB / eScript / COM
Using COM Integration, Sending values from Siebel To Excel and then getting values from Excel to Siebel , formats of the calculations returning incorrect. It seems to be Siebel Locale values are getting overwritten by OS values.
From Siebel 100.00 is sent to excel, the Excel is using the Spanish (Cost Rica) OS formatting for it and changing the value to 100,000 thus making the calculations incorrect in excel. The number then that displays in Siebel is also incorrect. Excel reads the OS and not from Siebel during the integration between the two. How can this be changed? This is also happening for dates in the Com Integration. (Siebel format MM/DD/YYYY, OS format DD/MM/YYYY. )
“Unhandled Exception: Unsupported data type” error is coming.
The issue can be reproduced at will with the following steps:
1. Use below sample code to reproduce the behavior:
if (MethodName == "MyMethod")
var Tdate = new Date();
var ExcelApp =
ExcelApp.Visible = true;
ExcelApp.ActiveSheet.Cells(1,1).Value = Tdate;
// ------- application failing
var fileName = "C:\\TestSuchi.xls";
ExcelApp = null;
The issue has the following business impact:
Due to this issue, users cannot get Date & Currency data in same format from Excel.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms