# edata

**Repository Path**: lixkhao/edata

## Basic Information

- **Project Name**: edata
- **Description**: 表格数据读写工具
- **Primary Language**: Python
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-04-10
- **Last Updated**: 2021-04-10

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# edata
edata means 'easy data', is a wrapper of csv, xlrd, xlwt, pylightxl.
edata can be used to read csv, xls, xlsx format file as dict list data and write dict list data to those format file.


## install
```cmd
pip install edata
```

## example
```python
import edata

data_list = [{'id': 1, 'name': 'Lena'},
             {'id': 2, 'name': 'Java'},
             {'id': 3, 'name': 'Gaga'}]

# write data to file
edata.write('test.csv', data_list[0:100])
edata.write('test.xls', data_list[0:100])
edata.write('test.xlsx', data_list[0:100])
# read data from file
print(edata.read('test.csv'))
print(edata.read('test.xls'))
print(edata.read('test.xlsx'))
# get sheet names
print(edata.get_sheet_names('test.xls'))
print(edata.get_sheet_names('test.xlsx'))

```
3 file will be created and console will print:
```text
[{'id': '1', 'name': 'Lena'}, {'id': '2', 'name': 'Java'}, {'id': '3', 'name': 'Gaga'}]
[{'id': 1, 'name': 'Lena'}, {'id': 2, 'name': 'Java'}, {'id': 3, 'name': 'Gaga'}]
[{'id': 1, 'name': 'Lena'}, {'id': 2, 'name': 'Java'}, {'id': 3, 'name': 'Gaga'}]
['Sheet1']
['Sheet1']
```