Proxy Jet

To set up a proxy on your computer, you need to go through a simple procedure. If we're talking about Windows 10, you'll first need to open the "Settings" application and the "Network and Internet" section. Here, after opening the "Proxy Server" tab, find the column "Manual proxy server setup" just to the right and move the switch to the "On" position. Enter the IP address and the proxy port in the specified fields and click "Save".

When working with OpenXML, you may need to parse date values from date-formatted cells in Excel spreadsheets. The date values in OpenXML are represented as numeric values, and you need to convert these numeric values to DateTime objects.

Here's an example using C# and the DocumentFormat.OpenXml library to parse date values from an Excel spreadsheet:

1. Install the Open XML SDK:

   • If you haven't already, install the DocumentFormat.OpenXml NuGet package:

nuget install DocumentFormat.OpenXml

Write the Parsing Code:

• Create a C# script or add the following code to your project:

using System;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;

class Program
{
    static void Main()
    {
        string filePath = "path/to/your/excelfile.xlsx"; // Replace with the path to your Excel file

        // Call the function to parse dates from the Excel file
        ParseDatesFromExcel(filePath);
    }

    static void ParseDatesFromExcel(string filePath)
    {
        using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(filePath, false))
        {
            WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;
            SharedStringTablePart sharedStringTablePart = workbookPart.GetPartsOfType().FirstOrDefault();

            if (sharedStringTablePart != null)
            {
                foreach (WorksheetPart worksheetPart in workbookPart.WorksheetParts)
                {
                    foreach (Cell cell in worksheetPart.Worksheet.Descendants())
                    {
                        if (cell.DataType != null && cell.DataType.Value == CellValues.SharedString)
                        {
                            int sharedStringIndex = int.Parse(cell.InnerText);
                            string sharedStringValue = sharedStringTablePart.SharedStringTable.Elements().ElementAt(sharedStringIndex).InnerText;

                            if (DateTime.TryParse(sharedStringValue, out DateTime parsedDate))
                            {
                                Console.WriteLine($"Parsed Date: {parsedDate.ToShortDateString()}");
                            }
                            else
                            {
                                Console.WriteLine("Not a valid date format.");
                            }
                        }
                        else if (cell.CellValue != null)
                        {
                            if (DateTime.TryParse(cell.CellValue.Text, out DateTime parsedDate))
                            {
                                Console.WriteLine($"Parsed Date: {parsedDate.ToShortDateString()}");
                            }
                            else
                            {
                                Console.WriteLine("Not a valid date format.");
                            }
                        }
                    }
                }
            }
        }
    }
}

2. • Replace "path/to/your/excelfile.xlsx" with the actual path to your Excel file.

3. Run the Code:

   • Execute the code, and it will print parsed date values from the Excel file.

This code uses the SpreadsheetDocument class from the DocumentFormat.OpenXml.Packaging namespace to open the Excel file, and it iterates through the cells to parse and print date values. It checks if the cell contains a shared string (string stored in the shared string table) or a direct value. If it's a valid date, it parses and prints it. Adjust the code according to your specific needs and Excel file structure.

In Selenium with Python, you can add cookies to your browser session using the add_cookie method of the WebDriver's options or add_cookie method of the WebDriver instance. If you have cookies saved in a file, you can read the file and then add the cookies to your Selenium session. Here's an example:

from selenium import webdriver
import pickle

# Create a new instance of the browser (e.g., Chrome)
driver = webdriver.Chrome()

# Read cookies from a file (replace 'cookies.pkl' with your actual file name)
with open('cookies.pkl', 'rb') as cookies_file:
    cookies = pickle.load(cookies_file)

# Add each cookie to the browser session
for cookie in cookies:
    driver.add_cookie(cookie)

# Now the browser should have the added cookies

# Example: Navigate to a website after setting cookies
driver.get('https://example.com')

# Continue with your script...

# Close the browser when done
driver.quit()

In this example:

1. The Selenium WebDriver (Chrome in this case) is created.
2. Cookies are read from a file using the pickle module. Make sure your cookies file is in the correct format (a list of dictionaries).
3. Each cookie is added to the browser session using the add_cookie method.
4. The script navigates to a website (https://example.com) after setting the cookies. Adjust this part according to your specific use case.
5. The browser is closed using driver.quit() when the script is done.

Make sure to replace 'cookies.pkl' with the actual path to your cookies file.

Note: The format of the cookies file is crucial. It should be a list of dictionaries, and each dictionary should contain at least the keys 'name', 'value', 'domain', and 'path'. If the cookies were obtained using get_cookies() in a previous Selenium session, you can directly save the result using pickle.dump(cookies, file).

Here's a simple example of how to save cookies:

from selenium import webdriver
import pickle

driver = webdriver.Chrome()
driver.get('https://example.com')

# Get cookies
cookies = driver.get_cookies()

# Save cookies to a file
with open('cookies.pkl', 'wb') as cookies_file:
    pickle.dump(cookies, cookies_file)

driver.quit()

Then, you can use the first script to load and set these cookies in a new Selenium session.

Although free proxies are popular, they are far from being flawless in their work. Many of their IP addresses are blacklisted by popular resources, and the data transfer speed and stability are very unreliable. When choosing a proxy, keep in mind that the new version of IPv6 is not supported by most websites. Note also that proxies are divided into private and public, statistical and dynamic, and support different network protocols.

In CentOS, if there is no graphical interface (from the terminal), proxy configuration is done through the export http_proxy=http://User:Pass@Proxy:Port/ command. Accordingly, User is the user, Pass is the password to identify you, Proxy is the IP address of the proxy, and Port is the port number. If you have DE, the configuration can be done via Network Manager (as in any other Linux distribution).