semvec/pypi-packages huggingface dataset:
EasyHTML2023 1.0.0.1
中文的python HTML解析提取器！

# EasyHTML 中文的python HTML解析提取器！
>如果程序错了，请报告给534047068@qq.com。
****
输入首字母快速输入，不用切换输入法。按下Tab键补全。<br>
（我用的pycharm）
****
```python
# 假设有以下 HTML 代码
from Easy_HTML_2023 import EH
html = '''
<html>
<body>
    <div class="container">
        <h1>标题</h1>
        <p>段落文本</p>
        <a href="https://example.com">链接1</a>
        <a href="https://example.com">链接2</a>
    </div>
    <div class="box">
        <h2>副标题</h2>
        <p>其他文本</p>
        <a href="https://example.com">链接3</a>
    </div>
</body>
</html>
'''

# 创建美丽汤对象
soup = EH.EH(html)

# 获取所有的 div 标签内容
div内容 = soup.查找标签('div')
for 内容 in div内容:
    文本内容 = soup.获得文本(内容)
    print(文本内容)

# 获取类名为 "container" 的元素内容
container内容 = soup.查找类名('container')
for 内容 in container内容:
    文本内容 = soup.获得文本(内容)
    print(文本内容)

# 获取所有的链接及其网址
链接列表 = soup.查找链接()

```
运行上述代码将输出以下结果：
```
标题 段落文本 链接1 链接2
标题 段落文本 链接1 链接2
链接1
链接2
https://example.com
https://example.com
```
>使用方法相当于beautifulsoup，不过也略有不同。（可以去看源代码）。
excel2mssql 0.0.3
A package to insert data from Excel or CSV to MSSQL
Requires Python: >=3.9

# excel-to-mssql
`excel2mssql` is a Python library that provides functionality to read data from Excel and CSV files and insert it into a Microsoft SQL Server database.

## Installation
```bash
pip install excel2mssql
```

## Usage
### CsvToMssql
To use `CsvToMssql`, you need to create an instance of the class and pass in the path to the CSV file, the name or IP address of the SQL Server, the name of the database to connect to, the name of the table to insert the data into, and the username and password to use for authentication.

```python
from excel2mssql.worker import CsvToMssql

csv_path = "path/to/csv/file.csv"

# This is just an example, preferably you would store these in environment variables
server = "localhost"
database = "mydatabase"
schema = "myschema"
table_name = "mytable"
username = "myusername"
password = "mypassword"

csv_to_mssql = CsvToMssql(
    csv_path=csv_path,
    server=server,
    database=database,
    schmea=schema,
    table_name=table_name,
    username=username,
    password=password,
)

columns = ["column1", "column2", "column3"]

csv_to_mssql.csv_to_mssql(columns=columns, sep=",", encoding="utf-8", action="replace")
```

### ExcelToMssql
To use `ExcelToMssql`, you need to create an instance of the class and pass in the path to the Excel file, the name or IP address of the SQL Server, the name of the database to connect to, the name of the table to insert the data into, and the username and password to use for authentication.

```python
from excel2mssql.worker import ExcelToMssql

excel_path = "path/to/excel/file.xlsx"

# This is just an example, preferably you would store these in environment variables
server = "localhost"
database = "mydatabase"
schema = "myschema"
table_name = "mytable"
username = "myusername"
password = "mypassword"

excel_to_mssql = ExcelToMssql(
    excel_path=excel_path,
    server=server,
    database=database,
    schmea=schema,
    table_name=table_name,
    username=username,
    password=password,
)

sheet_name = "Sheet1"
columns = ["column1", "column2", "column3"]

excel_to_mssql.excel_to_mssql(sheet_name=sheet_name, columns=columns, action="replace")
```

## License
This package is licensed under the MIT License. See the [LICENSE](LICENSE) file for details.

## Contributing
If you find a bug or have a feature request, please open an issue on the repository. If you would like to contribute code, please fork the repository and submit a pull request.

Before submitting a pull request, please make sure that your code adheres to the following guidelines:
 - Follow the [PEP 8](https://www.python.org/dev/peps/pep-0008/) style guide.
 - Write docstrings for all functions and classes.
 - Write unit tests for all functions and classes.
 - Make sure that all tests pass by running pytest.
 - Keep the code simple and easy to understand.