Can we use any other file format for config file for RE framework other than excel. The client cannot install excel on the production server. So we need to use a text, csv, xml file etc.
Yes you can have.
Let us know if you are facing any issue in loading the files.
Hi. I created using excel in development environment and it is working fine. But now I need to change the format from excel to the one mentioned above. Since I am new to this I don’t know how to implement it. If you could just guide or share a xaml file would be appreciated.
What is the required format you are looking for? is it csv or text or a xml?
Which ever is easier to implement
Use work book activities. For these no need of Excel application to be installed in the machine
Since I have already implemented it using excel, which ever is easier without making much changes will be better.
@Lakshman in that case I’ll not be able to change the values in config file on production server if I need to change. I’ll have to make the changes on development environment and then copy the excel file right?
In that case go for CSV format, there will not be much changes needs to be done.
Yes, Exactly. If this is ok for you then you can follow that way.
Can you please help how I can read from xml file.
Please follow the below link for your reference and let us know if this helps
Aa of now implemented using csv and it’s working. Will explore for xml. Thanks.
Using Json files is a good and stable option as well, which allows you to deserialize a Json-formatted string from a text file to a collection of your choice, e.g. a Dictionary. Check the Newtonsoft.Json package, which should provide you with the methods needed.