Reading from different tabs of same .csv file

Solved909 views#csv import #efficieny C++
1
0 Comments

Hello Community,

Just a thought in my head as I have developed three different C# scripts to pull parameters (static) from 3 different .csv files to be synched into the same element.

Is it possible to have all as tabs in a single .csv file for a more seamless and efficient way of execution?

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 12th December 2023

2 Answers

5
13.11K 1 Comment

Hi,

I do not believe it is possible to do that with a CSV as those files are like basic text files and as far as I am aware have no way of encoding multiple tabs.

For that, you would need to either do some custom logic to encode that data or use an Excel file (or similar) that does support tabs.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 12th December 2023
Samson Fayoyiwa [DevOps Advocate] commented

Thanks Joao, yes was approaching it from the other excel formats.
2
2.75K 1 Comment

Hi Samson,

A CSV file is a plain text file that stores data in a tabular format by separating data entries with commas. CSV files are used when data needs to be compatible with many different programs. Most likely, you are using Microsoft Excel. However, there are programs that do not support multiple tabs, such as great old Notepad.exe.
Hope this helps you further.

Samson Fayoyiwa [DevOps Advocate] Posted new comment 8th December 2023