# C# Scripts Repository

- [Read Excel](/scripting-utility-classes/common-scripts-repository/c-scripts-repository/read-excel.md)
- [Write Excel](/scripting-utility-classes/common-scripts-repository/c-scripts-repository/write-excel.md): This adds the first worksheet to an ExcelWorksheet variable, creates a loop based on the number of rows given to it, inserting the values with each iteration.
- [Add LOV in Excel](/scripting-utility-classes/common-scripts-repository/c-scripts-repository/add-lov-in-excel.md): This adds the first worksheet to an ExcelWorksheet variable, creates a loop based on a given value and adds DDLs in the cells with each iteration.
- [Change Excel Cell Color](/scripting-utility-classes/common-scripts-repository/c-scripts-repository/change-excel-cell-color.md): This colors the specified cells with the selected color.
- [RegexSplit (Text Filtering)](/scripting-utility-classes/common-scripts-repository/c-scripts-repository/regexsplit-text-filtering.md)
- [Start a process](/scripting-utility-classes/common-scripts-repository/c-scripts-repository/start-a-process.md): This is used to start a windows process with the given arguments. In the snippet below, set the path to the working directory and the name of the executable.
- [Filter HTML Contents](/scripting-utility-classes/common-scripts-repository/c-scripts-repository/filter-html-contents.md): By using the HtmlDocument object from the HtmlAgilityPack library, html document object filtering can be achieved.
- [Reading CSV Contents](/scripting-utility-classes/common-scripts-repository/c-scripts-repository/reading-csv-contents.md): This script can be used to read CSV file contents.
- [LINQ Filtering](/scripting-utility-classes/common-scripts-repository/c-scripts-repository/linq-filtering.md): This script can be used to filter collections through the use of LINQ.
- [Data Conversion](/scripting-utility-classes/common-scripts-repository/c-scripts-repository/data-conversion.md): This section describes various data conversion techniques.
- [Double to DateTime](/scripting-utility-classes/common-scripts-repository/c-scripts-repository/data-conversion/double-to-datetime.md): This snippet can be used to convert a double value (OA Date) to DateTime