excel to csv format error

S

Sundeep4sandy

New Member
Hi,

I'm currently converting an Excel file to CSV.

Step 1: Get data into collection
Step 2: Convert collection to CSV
Step 3: write it into a file.

It works, but there is a problem with Data format error.

For example:
Excel value - 9781621577720
CSV value - 9.78162E+12

I'd like to know if CSV can have the same values as excel. or is there a way to convert 9.78162E+12 to exact value of 9781621577720
 
S

Sundeep4sandy

New Member
The solution that you mentioned to rewrite the file may not be possible.

I've dealt with a large file that contains 32K-70k rows and it also contains some 50000+ blank rows

Steps as follows:

1. Get Excel file data to Collection(fast-disable logging)
2. Convert collection to CSV
3. Write to a CSV file.

I'm able to perform it efficiently with lot of Vb.net scripts and blue prism logics but my only problem is I cannot rewrite CSV to excel for the format as blueprism get hanged if we performing that large data operation in writing.

I'd like to be CSV and have the formats currently identified.
 
You must log in or register to reply here.
Top