Writing to a CSV
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-02-20 08:01 PM
Thanks in advance.
------------------------------
Maneesh Vemula
RPA Developer
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-02-20 09:23 PM
I would recommend using Text format on the cells prior to input the data as per: https://support.microsoft.com/en-us/help/269370/last-digits-are-changed-to-zeroes-when-you-type-long-numbers-in-cells
That is a behavior that Excel have for number after the 15 digits long due to IEEE 754 especification, probably the csv format is causing issues when changing the format of the cell as well. If not crazy maybe using other file format as a test could help, like xlsx.
Hope this is somewhat useful.
Thanks,
------------------------------
Christopher Rojas
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-02-20 09:54 PM
------------------------------
Maneesh Vemula
RPA Specialist
America/New_York
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-02-20 07:30 AM
Hi Maneesh ,
The below steps will resolve your issue. Find the attachments for better under standing.
Steps to be followed:
1. Navigate to MS Excel VBO - Format cell
2. Duplicate Page- Format cell and rename as Format Cell Range
3. Create two data item(text) cellstart and cellend and delete cellref data item.
4. Open code stage format cell and rename as format cell range, remove cellref in input tab and initialize the two data item (cellstart and cellend)
5. Modify the code as shown in the screen shot
6. Initialize the created two data items in start stage and publish the object.
7. Open process studio create a flow include Format cell range action in process before writing 16 digits value and pass the input parameters.
8. On Format give value as "@" this will set the cell range format as text.
| Gerald | Automation Engineer Exponential Digital Solutions Pvt. Ltd. 4th Floor, Jyothirmaya Building, Infopark Phase 2, Brahmapuram, Kochi – 682303 +91 9159842805 (M) | ||
|
------Original Message------
Hello,
I would recommend using Text format on the cells prior to input the data as per: https://support.microsoft.com/en-us/help/269370/last-digits-are-changed-to-zeroes-when-you-type-long-numbers-in-cells
That is a behavior that Excel have for number after the 15 digits long due to IEEE 754 especification, probably the csv format is causing issues when changing the format of the cell as well. If not crazy maybe using other file format as a test could help, like xlsx.
Hope this is somewhat useful.
Thanks,
------------------------------
Christopher Rojas
------------------------------