Question
Genpact
IN
Last activity: 8 Mar 2018 0:25 EST
Excel - Format Column
Using excel connector can we format particular column as numeric? I have a data table which I get imported from my c# code to excel connector and its working fine. but in C# code also I am not able to format this particular column to numeric. Kindly assist.
***Updated by moderator: Lochan to add Categories***
Pegasystems Inc.
US
http://help.openspan.com/80/Components/Microsoft_Excel.htm
The connector doesn't have that ability, but you could use a loop to sort the data at runtime.
Pegasystems Inc.
US
Here is a simple solution to format a range with numeric and zero decimals. This was written using 8.0.1082 but should be able to be opened by any version 8.0.1053 and above.
This uses a very small script to extract a the used range for a column. The rest just uses what is available from the connector.
Script:
Genpact
IN
Hello Jeff,
I cleaned and ran the solution, but it never crossed the script written and the proxy for workbook on hover shows NULL. Could you please look into it.