Hello, this is my first post and I’m sorry if my English is hard to read.
This is what I want to do:
1.use “Read CSV” to read a csv file content as datatable
2.Use “Excel application scope” to open an excel format(.xlsx)
-In the detail setting of the excel file: “show 0s” : ON
3.use “Write Range” to paste the datatable
When I open the excel format after pasting the datatable, I have two problems:
- "0"s (in the beginning of each cell) fall
- the last 5 or 6 digits of large numbers automatically converted into "0"s
I would appreciate you very much if you give me advice.
I am not allowed to use “invoke code” or use excel macro basically.
Thank you for reading:)