35 lines
474 B
Markdown
35 lines
474 B
Markdown
installation :
|
|
|
|
```bash
|
|
pip install git+{reponame}
|
|
```
|
|
|
|
|
|
example read :
|
|
|
|
|
|
``` python
|
|
from xl import XL
|
|
|
|
file_path = "./1.xlsx"
|
|
sheet_name = "Sheet"
|
|
with XL(file_path) as excel_to_dict:
|
|
data = excel_to_dict.sheet_to_dict(sheet_name)
|
|
print(data)
|
|
```
|
|
|
|
|
|
example write :
|
|
|
|
|
|
``` python
|
|
from xl import XL
|
|
|
|
file_path = "./1.xlsx"
|
|
data = [
|
|
{"Name":"Alice", "Age":30},
|
|
{"Name":"Bob", "Age":25},
|
|
{"Name":"Charlie", "Age":35},
|
|
]
|
|
XL(file_path).json_to_sheet(data)
|
|
``` |