xlrd

wolf0000

1. import xlrd as xl
   
2. 
   
3. # 读取文件
   
4. excel = xl.open_workbook("testdata/testdata.xls")
   
5. # 读取文件第一页
   
6. table = excel.sheets()[0]
   
7. # 读取文件总行数
   
8. print(table.nrows)
   
9. # 读取文件总列数
   
10. print(table.ncols)
    
11. # 读取文件第一行数据
    
12. print(table.row_values(0))
    
13. # 读取文件第一列数据
    
14. print(table.col_values(0))
    
15. # 循环读取数据
    
16. print("--------------------------------------------------------")
    
17. for i in range(1,table.nrows):
    
18.     print(table.row_values(i))

复制代码

wolf0000

1. @overload
   
2.     def __init__(
   
3.         self: Connection[Cursor],  # different between overloads
   
4.         *,
   
5.         host: str | None = ...,
   
6.         user: Any | None = ...,
   
7.         password: str = ...,
   
8.         database: Any | None = ...,
   
9.         port: int = ...,
   
10.         unix_socket: Any | None = ...,
    
11.         charset: str = ...,
    
12.         sql_mode: Any | None = ...,
    
13.         read_default_file: Any | None = ...,
    
14.         conv=...,
    
15.         use_unicode: bool | None = ...,
    
16.         client_flag: int = ...,
    
17.         cursorclass: None = ...,  # different between overloads
    
18.         init_command: Any | None = ...,
    
19.         connect_timeout: int | None = ...,
    
20.         ssl: Mapping[Any, Any] | None = ...,
    
21.         ssl_ca=...,
    
22.         ssl_cert=...,
    
23.         ssl_disabled=...,
    
24.         ssl_key=...,
    
25.         ssl_verify_cert=...,
    
26.         ssl_verify_identity=...,
    
27.         read_default_group: Any | None = ...,
    
28.         compress: Any | None = ...,
    
29.         named_pipe: Any | None = ...,
    
30.         autocommit: bool | None = ...,
    
31.         db: Any | None = ...,
    
32.         passwd: Any | None = ...,
    
33.         local_infile: Any | None = ...,
    
34.         max_allowed_packet: int = ...,
    
35.         defer_connect: bool | None = ...,
    
36.         auth_plugin_map: Mapping[Any, Any] | None = ...,
    
37.         read_timeout: float | None = ...,
    
38.         write_timeout: float | None = ...,
    
39.         bind_address: Any | None = ...,
    
40.         binary_prefix: bool | None = ...,
    
41.         program_name: Any | None = ...,
    
42.         server_public_key: bytes | None = ...,
    
43.     ): ...

复制代码