What is benifit to use CSV file in automation

Help Activities
,
1

Hi guys i am make excel automationin c# dot net and interop library and my file is always open in read only mode to over come this problem i have added kill process but some one suggest me to use CSV file can you please help me know what is benifit to use CSV file in automation.

2

@Aleem_Khan

Using a CSV file instead of Excel for automation has its own set of benefits and considerations.

Benefits of Using CSV Files:

-Simplicity
-Lightweight
-Compatibility
-Ease of Integration
-Version Control
-Speed and Reduced Dependency

Cheers…!

1 Like
3

How to read, write csv and perform other operation in c# ?

4

If is that file open in background shall it’s show in read only or not?

5

-Reading, writing CSV files, and performing other operations in C# can be done using the System.IO namespace for basic file operations and libraries like CsvHelper for more advanced CSV handling.

1 Like
6

Anything else which is importent for csv

7

@Aleem_Khan

There might not be any special adavantages

Few are here

  1. It does not need excel to be installed as it is not an excel based extension
  2. Relatively smaller size than excels
  3. Can be read and used just as a text file

Cheers

8

HI @Aleem_Khan ,
Smaller storage capacity
can save as excel without application
You can use several Text file activities together
regards,