Get worksheet as collection : Values

[NupurSood]

When  I use "get worksheet as collection", the values fetched into the collection are the ones that are displayed on the sheet and not the actual cell value. For instance, 5.87 displays 5 but when we click on the cell it is 5.87. Using "Get cell value" fetches 5.87, however, get collection gives 5. I need to use get collection since I have a huge excel sheet and I need to fetch these decimal points as well.    Any help would be appreciated. Thanks.

[Jagan_MohanP]

At present, per my knowledge,  There is no direct solution though the work around should be changing the excel format to display decimals with ""increase decimal option.

[NupurSood]

Was looking was an optimized way since my excel is has mixed data (including percentages, text etc.) and a lot many columns

[SukeshManthena]

Hello, Instead of using MS Excel VBO, use OLEDB VBO's ""Get Collection"" action (write an SQL query) to bring those values as it is. Good Luck.

[AndreyKudinov]

Or you can rewrite it using normal interop calls instead of copy-paste used in VBO, which has it's own downsides, but works better in most cases.