{"id":57570,"date":"2025-08-15T15:40:03","date_gmt":"2025-08-15T07:40:03","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/57570.html"},"modified":"2025-08-15T15:40:03","modified_gmt":"2025-08-15T07:40:03","slug":"%e4%b8%8d%e5%90%8cduckdb%e6%8f%92%e4%bb%b6%e5%af%b9%e4%b8%8d%e5%90%8c%e5%b7%a5%e5%85%b7%e7%94%9f%e6%88%90%e7%9a%84xlsx%e6%96%87%e4%bb%b6%e8%af%bb%e5%8f%96%e9%80%9f%e5%ba%a6%e7%9a%84%e6%af%94%e8%be%83","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/57570.html","title":{"rendered":"\u4e0d\u540cDuckDB\u63d2\u4ef6\u5bf9\u4e0d\u540c\u5de5\u5177\u751f\u6210\u7684xlsx\u6587\u4ef6\u8bfb\u53d6\u901f\u5ea6\u7684\u6bd4\u8f83"},"content":{"rendered":"

\u4e0a\u6587\u63d0\u5230\u7684SharedString\u683c\u5f0f\u5bf9\u8bfb\u53d6\u6027\u80fd\u7684\u5f71\u54cd\u5982\u4f55，\u4e0b\u9762\u7528\u5b9e\u9a8c\u6765\u8bf4\u660e\u3002
\n1.\u751f\u6210\u4e24\u79cd\u683c\u5f0f\u6587\u4ef6
\nDuckDB\u7684excel\u63d2\u4ef6\u751f\u6210\u4e0d\u5e26SharedString\u683c\u5f0f\u7684xlsx\u6587\u4ef6，\u5982\u4e0b\u6240\u793a<\/p>\n

load<\/span> excel
\ncopy (<\/span>from<\/span> read_csv(<\/span>'NYC_311_SR_2010-2020-sample-1M.csv'<\/span>)<\/span>)<\/span>to<\/span> 'ducknyc.xlsx'<\/span> WITH<\/span> (<\/span>FORMAT xlsx,<\/span> HEADER true<\/span>)<\/span>;<\/span>
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 62.449<\/span> user<\/span> 59.112000<\/span> sys 0.852000<\/span><\/p>\n

writexlsx\u5e93\u751f\u6210\u5e26SharedString\u683c\u5f0f\u7684xlsx\u6587\u4ef6，\u6211\u8ba9DeepSeek\u5206\u522b\u7528c\u548cpython\u7f16\u5199\u4e86\u628acsv\u6587\u4ef6\u8f6c\u6362\u4e3axlsx\u7684\u7a0b\u5e8f，\u5982\u4e0b\u6240\u793a：<\/p>\n

#<\/span>include<\/span> "xlsxwriter.h"<\/span><\/span>
\n#<\/span>include<\/span> <stdio.h><\/span><\/span>
\n#<\/span>include<\/span> <stdlib.h><\/span><\/span>
\n#<\/span>include<\/span> <string.h><\/span><\/span><\/p>\n

#<\/span>define<\/span> MAX_LINE_LENGTH<\/span> 1024<\/span><\/span><\/span>
\n#<\/span>define<\/span> MAX_FIELD_LENGTH<\/span> 256<\/span><\/span><\/span><\/p>\n

int<\/span> main<\/span>(<\/span>int<\/span> argc,<\/span> char<\/span> *<\/span>argv[<\/span>]<\/span>)<\/span> {<\/span>
\n if<\/span> (<\/span>argc !=<\/span> 3<\/span>)<\/span> {<\/span>
\n printf<\/span>(<\/span>"Usage: %s <input.csv> <output.xlsx>\\\\n"<\/span>,<\/span> argv[<\/span>0<\/span>]<\/span>)<\/span>;<\/span>
\n return<\/span> 1<\/span>;<\/span>
\n }<\/span><\/p>\n

const<\/span> char<\/span> *<\/span>input_csv =<\/span> argv[<\/span>1<\/span>]<\/span>;<\/span>
\n const<\/span> char<\/span> *<\/span>output_xlsx =<\/span> argv[<\/span>2<\/span>]<\/span>;<\/span><\/p>\n

\/\/ \u6253\u5f00 CSV \u6587\u4ef6<\/span>
\n FILE *<\/span>csv_file =<\/span> fopen<\/span>(<\/span>input_csv,<\/span> "r"<\/span>)<\/span>;<\/span>
\n if<\/span> (<\/span>!<\/span>csv_file)<\/span> {<\/span>
\n printf<\/span>(<\/span>"Error: Could not open CSV file '%s'\\\\n"<\/span>,<\/span> input_csv)<\/span>;<\/span>
\n return<\/span> 1<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u521b\u5efa\u5de5\u4f5c\u7c3f\u548c\u5de5\u4f5c\u8868<\/span>
\n lxw_workbook *<\/span>workbook =<\/span> workbook_new<\/span>(<\/span>output_xlsx)<\/span>;<\/span>
\n lxw_worksheet *<\/span>worksheet =<\/span> workbook_add_worksheet<\/span>(<\/span>workbook,<\/span> NULL<\/span>)<\/span>;<\/span><\/p>\n

char<\/span> line[<\/span>MAX_LINE_LENGTH]<\/span>;<\/span>
\n int<\/span> row =<\/span> 0<\/span>;<\/span><\/p>\n

\/\/ \u9010\u884c\u8bfb\u53d6 CSV \u6587\u4ef6<\/span>
\n while<\/span> (<\/span>fgets<\/span>(<\/span>line,<\/span> sizeof<\/span>(<\/span>line)<\/span>,<\/span> csv_file)<\/span>)<\/span> {<\/span>
\n \/\/ \u79fb\u9664\u6362\u884c\u7b26<\/span>
\n line[<\/span>strcspn<\/span>(<\/span>line,<\/span> "\\\\n"<\/span>)<\/span>]<\/span> =<\/span> '\\\\0'<\/span>;<\/span><\/p>\n

char<\/span> *<\/span>token;<\/span>
\n int<\/span> col =<\/span> 0<\/span>;<\/span><\/p>\n

\/\/ \u4f7f\u7528\u9017\u53f7\u5206\u9694\u5b57\u6bb5<\/span>
\n token =<\/span> strtok<\/span>(<\/span>line,<\/span> ","<\/span>)<\/span>;<\/span>
\n while<\/span> (<\/span>token !=<\/span> NULL<\/span>)<\/span> {<\/span>
\n \/\/ \u5c1d\u8bd5\u5c06\u5b57\u6bb5\u8f6c\u6362\u4e3a\u6570\u5b57<\/span>
\n char<\/span> *<\/span>endptr;<\/span>
\n double<\/span> number =<\/span> strtod<\/span>(<\/span>token,<\/span> &<\/span>endptr)<\/span>;<\/span><\/p>\n

if<\/span> (<\/span>*<\/span>endptr ==<\/span> '\\\\0'<\/span>)<\/span> {<\/span>
\n \/\/ \u5982\u679c\u662f\u6570\u5b57，\u5199\u5165\u6570\u5b57<\/span>
\n worksheet_write_number<\/span>(<\/span>worksheet,<\/span> row,<\/span> col,<\/span> number,<\/span> NULL<\/span>)<\/span>;<\/span>
\n }<\/span> else<\/span> {<\/span>
\n \/\/ \u5426\u5219\u5199\u5165\u5b57\u7b26\u4e32<\/span>
\n worksheet_write_string<\/span>(<\/span>worksheet,<\/span> row,<\/span> col,<\/span> token,<\/span> NULL<\/span>)<\/span>;<\/span>
\n }<\/span><\/p>\n

token =<\/span> strtok<\/span>(<\/span>NULL<\/span>,<\/span> ","<\/span>)<\/span>;<\/span>
\n col++<\/span>;<\/span>
\n }<\/span><\/p>\n

row++<\/span>;<\/span>
\n }<\/span><\/p>\n

\/\/ \u5173\u95ed\u6587\u4ef6<\/span>
\n fclose<\/span>(<\/span>csv_file)<\/span>;<\/span><\/p>\n

\/\/ \u4fdd\u5b58\u5e76\u5173\u95ed\u5de5\u4f5c\u7c3f<\/span>
\n lxw_error error =<\/span> workbook_close<\/span>(<\/span>workbook)<\/span>;<\/span>
\n if<\/span> (<\/span>error)<\/span> {<\/span>
\n printf<\/span>(<\/span>"Error: Failed to create XLSX file: %s\\\\n"<\/span>,<\/span> lxw_strerror<\/span>(<\/span>error)<\/span>)<\/span>;<\/span>
\n return<\/span> 1<\/span>;<\/span>
\n }<\/span><\/p>\n

printf<\/span>(<\/span>"Successfully converted '%s' to '%s'\\\\n"<\/span>,<\/span> input_csv,<\/span> output_xlsx)<\/span>;<\/span>
\n return<\/span> 0<\/span>;<\/span>
\n}<\/span><\/p>\n

\u7f16\u8bd1\u6267\u884c\u5982\u4e0b<\/p>\n

git<\/span> clone –depth<\/span>=<\/span>1<\/span> https:\/\/github.com\/jmcnamara\/libxlsxwriter
\ncd<\/span> libxlsxwriter
\nmake<\/span>
\nexport<\/span> LD_LIBRARY_PATH<\/span>=<\/span>$LD_LIBRARY_PATH<\/span>:\/par\/libxlsxwriter\/lib
\ngcc c2xx.c -o<\/span> c2xx -lxlsxwriter<\/span> -I<\/span> \/par\/libxlsxwriter\/include -L<\/span> \/par\/libxlsxwriter\/lib -O3<\/span><\/p>\n

time<\/span> .\/c2xx nyc1m.csv cnyc.xlsx
\nSuccessfully converted 'nyc1m.csv'<\/span> to 'cnyc.xlsx'<\/span><\/p>\n

real0m29.910s
\nuser0m28.432s
\nsys0m1.420s<\/p>\n

ls<\/span> -la<\/span> cnyc.xlsx
\n-rw-r–r– 1<\/span> root root 188461713<\/span> Aug 15<\/span> 09:10 cnyc.xlsx<\/p>\n

c\u7a0b\u5e8f\u6ca1\u6709\u8003\u8651\u8f6c\u4e49\u5b57\u7b26\u7684\u95ee\u9898，\u8f6c\u6210\u7684xlsx\u6587\u4ef6\u6709\u70b9\u95ee\u9898，\u4f46\u7a00\u5947\u7684\u662f，sheetreader\u63d2\u4ef6\u5c45\u7136\u80fd\u8bc6\u522b\u3002<\/p>\n

import<\/span> csv
\nimport<\/span> xlsxwriter
\nimport<\/span> sys<\/p>\n

def<\/span> csv_to_xlsx<\/span>(<\/span>input_csv,<\/span> output_xlsx)<\/span>:<\/span>
\n """
\n \u5c06 CSV \u6587\u4ef6\u8f6c\u6362\u4e3a XLSX \u6587\u4ef6<\/p>\n

\u53c2\u6570:
\n input_csv (str): \u8f93\u5165\u7684 CSV \u6587\u4ef6\u8def\u5f84
\n output_xlsx (str): \u8f93\u51fa\u7684 Excel \u6587\u4ef6\u8def\u5f84
\n """<\/span>
\n try<\/span>:<\/span>
\n # \u521b\u5efa\u5de5\u4f5c\u7c3f\u548c\u5de5\u4f5c\u8868<\/span>
\n workbook =<\/span> xlsxwriter.<\/span>Workbook(<\/span>output_xlsx)<\/span>
\n worksheet =<\/span> workbook.<\/span>add_worksheet(<\/span>)<\/span><\/p>\n

# \u8bbe\u7f6e\u683c\u5f0f – \u53ef\u9009<\/span>
\n bold_format =<\/span> workbook.<\/span>add_format(<\/span>{<\/span>'bold'<\/span>:<\/span> True<\/span>}<\/span>)<\/span>
\n date_format =<\/span> workbook.<\/span>add_format(<\/span>{<\/span>'num_format'<\/span>:<\/span> 'yyyy-mm-dd'<\/span>}<\/span>)<\/span><\/p>\n

# \u6253\u5f00 CSV \u6587\u4ef6<\/span>
\n with<\/span> open<\/span>(<\/span>input_csv,<\/span> 'r'<\/span>,<\/span> encoding=<\/span>'utf-8'<\/span>)<\/span> as<\/span> csv_file:<\/span>
\n csv_reader =<\/span> csv.<\/span>reader(<\/span>csv_file)<\/span><\/p>\n

for<\/span> row_idx,<\/span> row in<\/span> enumerate<\/span>(<\/span>csv_reader)<\/span>:<\/span>
\n for<\/span> col_idx,<\/span> value in<\/span> enumerate<\/span>(<\/span>row)<\/span>:<\/span>
\n try<\/span>:<\/span>
\n # \u5c1d\u8bd5\u8f6c\u6362\u4e3a\u6d6e\u70b9\u6570<\/span>
\n num_value =<\/span> float<\/span>(<\/span>value)<\/span>
\n if<\/span> num_value.<\/span>is_integer(<\/span>)<\/span>:<\/span>
\n # \u5982\u679c\u662f\u6574\u6570，\u5199\u5165\u6574\u6570<\/span>
\n worksheet.<\/span>write_number(<\/span>row_idx,<\/span> col_idx,<\/span> int<\/span>(<\/span>num_value)<\/span>)<\/span>
\n else<\/span>:<\/span>
\n # \u5982\u679c\u662f\u6d6e\u70b9\u6570，\u5199\u5165\u6d6e\u70b9\u6570<\/span>
\n worksheet.<\/span>write_number(<\/span>row_idx,<\/span> col_idx,<\/span> num_value)<\/span>
\n except<\/span> ValueError:<\/span>
\n # \u5982\u679c\u4e0d\u80fd\u8f6c\u6362\u4e3a\u6570\u5b57，\u5199\u5165\u5b57\u7b26\u4e32<\/span>
\n worksheet.<\/span>write_string(<\/span>row_idx,<\/span> col_idx,<\/span> value)<\/span><\/p>\n

# \u5173\u95ed\u5de5\u4f5c\u7c3f<\/span>
\n workbook.<\/span>close(<\/span>)<\/span>
\n print<\/span>(<\/span>f"\u6210\u529f\u5c06 '<\/span>{<\/span>input_csv}<\/span><\/span>' \u8f6c\u6362\u4e3a '<\/span>{<\/span>output_xlsx}<\/span><\/span>'"<\/span><\/span>)<\/span><\/p>\n

except<\/span> FileNotFoundError:<\/span>
\n print<\/span>(<\/span>f"\u9519\u8bef: \u627e\u4e0d\u5230\u8f93\u5165\u6587\u4ef6 '<\/span>{<\/span>input_csv}<\/span><\/span>'"<\/span><\/span>)<\/span>
\n sys.<\/span>exit(<\/span>1<\/span>)<\/span>
\n except<\/span> Exception as<\/span> e:<\/span>
\n print<\/span>(<\/span>f"\u53d1\u751f\u9519\u8bef: <\/span>{<\/span>str<\/span>(<\/span>e)<\/span>}<\/span><\/span>"<\/span><\/span>)<\/span>
\n sys.<\/span>exit(<\/span>1<\/span>)<\/span><\/p>\n

if<\/span> __name__ ==<\/span> "__main__"<\/span>:<\/span>
\n if<\/span> len<\/span>(<\/span>sys.<\/span>argv)<\/span> !=<\/span> 3<\/span>:<\/span>
\n print<\/span>(<\/span>"\u7528\u6cd5: python csv_to_xlsx.py <input.csv> <output.xlsx>"<\/span>)<\/span>
\n sys.<\/span>exit(<\/span>1<\/span>)<\/span><\/p>\n

input_csv =<\/span> sys.<\/span>argv[<\/span>1<\/span>]<\/span>
\n output_xlsx =<\/span> sys.<\/span>argv[<\/span>2<\/span>]<\/span><\/p>\n

csv_to_xlsx(<\/span>input_csv,<\/span> output_xlsx)<\/span><\/p>\n

\u6267\u884c\u5982\u4e0b<\/p>\n

python3 pip.pyz install<\/span> xlsxwriter
\ntime<\/span> python3 c2xx.py "NYC_311_SR_2010-2020-sample-1M.csv"<\/span> pynyc.xlsx
\n\u6210\u529f\u5c06 'NYC_311_SR_2010-2020-sample-1M.csv'<\/span> \u8f6c\u6362\u4e3a 'pynyc.xlsx'<\/span><\/p>\n

real6m13.559s
\nuser6m4.476s
\nsys0m5.680s<\/p>\n

\u56e0\u4e3apython\u6709\u5185\u7f6e\u7684csv\u8bfb\u53d6\u51fd\u6570，\u6240\u4ee5\u5b83\u6b63\u786e\u5730\u5904\u7406\u4e86\u8f6c\u4e49，\u5f97\u5230\u7684xlsx\u6587\u4ef6\u683c\u5f0f\u6b63\u786e\u3002
\nxlsx\u6587\u4ef6\u53ca\u5176\u4e2dSharedString\u548csheet1.xml\u5927\u5c0f\u5982\u4e0b\u8868\u6240\u793a：<\/p>\n\n\u8f6c\u6362\u5de5\u5177xlsxSharedStringsheet1<\/tr>\n\n\n\n\n
duckdb excel<\/td>\n249MB<\/td>\n0<\/td>\n1.7GB<\/td>\n<\/tr>\n
c<\/td>\n188MB<\/td>\n120MB<\/td>\n1.1GB<\/td>\n<\/tr>\n
python<\/td>\n220MB<\/td>\n107MB<\/td>\n1.5GB<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

2.\u7528\u4e0d\u540c\u63d2\u4ef6\u8bfb\u53d6
\n2.1\u7528excel\u63d2\u4ef6<\/p>\n

D load<\/span> excel;<\/span>
\n–\u4e0d\u5e26all_varchar=1\u9009\u9879\u8bfb\u53d6python\u751f\u6210\u7684\u6587\u4ef6\u5931\u8d25<\/span>
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> 'pynyc.xlsx'<\/span>;<\/span>
\n 0<\/span>%<\/span> \u2595 \u258f Run Time<\/span> (<\/span>s)<\/span>: real<\/span> 3.805<\/span> user<\/span> 7.372000<\/span> sys 0.132000<\/span>
\nInvalid Input Error:
\nread_xlsx: Failed to<\/span> parse cell 'I4018'<\/span>: Could not<\/span> convert<\/span> string ''<\/span> to<\/span> DOUBLE<\/span>
\n–\u5e26all_varchar=1\u9009\u9879\u8bfb\u53d6\u6210\u529f<\/span>
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> read_xlsx(<\/span>'pynyc.xlsx'<\/span>,<\/span>all_varchar=<\/span>1<\/span>)<\/span>;<\/span>
\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 count_star(<\/span>)<\/span> \u2502
\n\u2502 int64 \u2502
\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524
\n\u2502 1000000<\/span> \u2502
\n\u2502 (<\/span>1.00<\/span> million)<\/span> \u2502
\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 48.707<\/span> user<\/span> 95.948000<\/span> sys 0.272000<\/span>
\nheader=<\/span>1<\/span>\u76f8\u5f53\u4e8e\u81ea\u52a8\u5224\u65ad\u683c\u5f0f，header=<\/span>0<\/span>\u76f8\u5f53\u4e8eall_varchar,<\/span>\u56e0\u4e3a\u5217\u6807\u9898\u90fd\u662f\u5b57\u7b26\u4e32\u3002<\/p>\n

Run Time<\/span> (<\/span>s)<\/span>: real<\/span> 0.111<\/span> user<\/span> 0.176000<\/span> sys 0.016000<\/span>
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> read_xlsx(<\/span>'pynyc.xlsx'<\/span>,<\/span>header=<\/span>1<\/span>)<\/span>;<\/span>
\n 0<\/span>%<\/span> \u2595 \u258f Run Time<\/span> (<\/span>s)<\/span>: real<\/span> 3.539<\/span> user<\/span> 6.880000<\/span> sys 0.092000<\/span>
\nInvalid Input Error:
\nread_xlsx: Failed to<\/span> parse cell 'I4018'<\/span>: Could not<\/span> convert<\/span> string ''<\/span> to<\/span> DOUBLE<\/span>
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> read_xlsx(<\/span>'ducknyc.xlsx'<\/span>,<\/span>header=<\/span>1<\/span>)<\/span>;<\/span>
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 3.411<\/span> user<\/span> 5.300000<\/span> sys 0.312000<\/span>
\nInvalid Input Error:
\nread_xlsx: Failed to<\/span> parse cell 'N4'<\/span>: Could not<\/span> convert<\/span> string 'WILLOUGHBY AVENUE'<\/span> to<\/span> DOUBLE<\/span>
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> read_xlsx(<\/span>'cnyc.xlsx'<\/span>,<\/span>header=<\/span>1<\/span>)<\/span>;<\/span>
\n 0<\/span>%<\/span> \u2595 \u258f Run Time<\/span> (<\/span>s)<\/span>: real<\/span> 3.804<\/span> user<\/span> 7.516000<\/span> sys 0.084000<\/span>
\nInvalid Input Error:
\nread_xlsx: Failed to<\/span> parse cell 'I10'<\/span>: Could not<\/span> convert<\/span> string '1305 EAST 19 STREET'<\/span> to<\/span> DOUBLE<\/span>
\nD
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> read_xlsx(<\/span>'pynyc.xlsx'<\/span>,<\/span>header=<\/span>0<\/span>)<\/span>;<\/span><\/p>\n

\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 count_star(<\/span>)<\/span> \u2502
\n\u2502 int64 \u2502
\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524
\n\u2502 1000001<\/span> \u2502
\n\u2502 (<\/span>1.00<\/span> million)<\/span> \u2502
\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 48.054<\/span> user<\/span> 51.680000<\/span> sys 0.192000<\/span>
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> read_xlsx(<\/span>'ducknyc.xlsx'<\/span>,<\/span>header=<\/span>0<\/span>)<\/span>;<\/span><\/p>\n

\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 count_star(<\/span>)<\/span> \u2502
\n\u2502 int64 \u2502
\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524
\n\u2502 1000001<\/span> \u2502
\n\u2502 (<\/span>1.00<\/span> million)<\/span> \u2502
\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 44.848<\/span> user<\/span> 87.600000<\/span> sys 0.444000<\/span>
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> read_xlsx(<\/span>'cnyc.xlsx'<\/span>,<\/span>header=<\/span>0<\/span>)<\/span>;<\/span><\/p>\n

\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 count_star(<\/span>)<\/span> \u2502
\n\u2502 int64 \u2502
\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524
\n\u2502 296663<\/span> \u2502
\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 13.064<\/span> user<\/span> 25.484000<\/span> sys 0.100000<\/span>
\nD <\/p>\n

2.2\u7528rusty_sheet\u63d2\u4ef6<\/p>\n

D select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> read_sheet(<\/span>'pynyc.xlsx'<\/span>,<\/span>header=<\/span>1<\/span>)<\/span>;<\/span><\/p>\n

\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 count_star(<\/span>)<\/span> \u2502
\n\u2502 int64 \u2502
\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524
\n\u2502 1000000<\/span> \u2502
\n\u2502 (<\/span>1.00<\/span> million)<\/span> \u2502
\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 76.280<\/span> user<\/span> 71.944000<\/span> sys 4.160000<\/span>
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> read_sheet(<\/span>'ducknyc.xlsx'<\/span>,<\/span>header=<\/span>1<\/span>)<\/span>;<\/span><\/p>\n

\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 count_star(<\/span>)<\/span> \u2502
\n\u2502 int64 \u2502
\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524
\n\u2502 1000000<\/span> \u2502
\n\u2502 (<\/span>1.00<\/span> million)<\/span> \u2502
\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 46.921<\/span> user<\/span> 57.200000<\/span> sys 0.640000<\/span>
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> read_sheet(<\/span>'cnyc.xlsx'<\/span>,<\/span>header=<\/span>1<\/span>)<\/span>;<\/span>
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 38.976<\/span> user<\/span> 38.220000<\/span> sys 0.656000<\/span>
\nBinder Error:
\nRead<\/span> spreadsheet failed: Missing column<\/span> name at 'AP1'<\/span>
\nD
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> read_sheet(<\/span>'pynyc.xlsx'<\/span>,<\/span>header=<\/span>0<\/span>)<\/span>;<\/span><\/p>\n

\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 count_star(<\/span>)<\/span> \u2502
\n\u2502 int64 \u2502
\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524
\n\u2502 1000001<\/span> \u2502
\n\u2502 (<\/span>1.00<\/span> million)<\/span> \u2502
\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 77.455<\/span> user<\/span> 93.204000<\/span> sys 4.148000<\/span>
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> read_sheet(<\/span>'ducknyc.xlsx'<\/span>,<\/span>header=<\/span>0<\/span>)<\/span>;<\/span><\/p>\n

\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 count_star(<\/span>)<\/span> \u2502
\n\u2502 int64 \u2502
\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524
\n\u2502 1000001<\/span> \u2502
\n\u2502 (<\/span>1.00<\/span> million)<\/span> \u2502
\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 49.145<\/span> user<\/span> 61.764000<\/span> sys 0.704000<\/span>
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> read_sheet(<\/span>'cnyc.xlsx'<\/span>,<\/span>header=<\/span>0<\/span>)<\/span>;<\/span><\/p>\n

\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 count_star(<\/span>)<\/span> \u2502
\n\u2502 int64 \u2502
\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524
\n\u2502 1000217<\/span> \u2502
\n\u2502 (<\/span>1.00<\/span> million)<\/span> \u2502
\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 56.306<\/span> user<\/span> 72.896000<\/span> sys 0.644000<\/span><\/p>\n

2.3\u7528sheetreader\u63d2\u4ef6，\u56e0\u6700\u9ad8\u53ea\u652f\u6301Duckdb 1.2.2，\u6545\u91c7\u7528\u8be5\u7248\u672c\u6d4b\u8bd5\u3002<\/p>\n

.<\/span>\/<\/span>duckdb122
\nv1.<\/span>2.2<\/span> 7<\/span>c039464e4
\nD .<\/span>timer on<\/span>
\nD load<\/span> sheetreader;<\/span><\/p>\n

D select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> sheetreader(<\/span>'pynyc.xlsx'<\/span>,<\/span>has_header=<\/span>1<\/span>)<\/span>;<\/span>
\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 count_star(<\/span>)<\/span> \u2502
\n\u2502 int64 \u2502
\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524
\n\u2502 1000000<\/span> \u2502
\n\u2502 (<\/span>1.00<\/span> million)<\/span> \u2502
\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 17.722<\/span> user<\/span> 46.544000<\/span> sys 0.368000<\/span>
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> sheetreader(<\/span>'ducknyc.xlsx'<\/span>,<\/span>has_header=<\/span>1<\/span>)<\/span>;<\/span>
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 10.142<\/span> user<\/span> 45.000000<\/span> sys 0.544000<\/span>
\nInvalid Error:
\nFailed to<\/span> retrieve shared strings file<\/span>
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> sheetreader(<\/span>'cnyc.xlsx'<\/span>,<\/span>has_header=<\/span>1<\/span>)<\/span>;<\/span>
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 6.426<\/span> user<\/span> 28.680000<\/span> sys 0.136000<\/span>
\nBinder Error:
\nFirst<\/span> row<\/span> must contain only strings when<\/span> has_header is<\/span> set<\/span> to<\/span> true<\/span>
\nD
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> sheetreader(<\/span>'pynyc.xlsx'<\/span>,<\/span>has_header=<\/span>0<\/span>)<\/span>;<\/span>
\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 count_star(<\/span>)<\/span> \u2502
\n\u2502 int64 \u2502
\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524
\n\u2502 1000000<\/span> \u2502
\n\u2502 (<\/span>1.00<\/span> million)<\/span> \u2502
\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 17.470<\/span> user<\/span> 55.900000<\/span> sys 0.160000<\/span>
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> sheetreader(<\/span>'ducknyc.xlsx'<\/span>,<\/span>has_header=<\/span>0<\/span>)<\/span>;<\/span>
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 10.124<\/span> user<\/span> 44.872000<\/span> sys 0.536000<\/span>
\nInvalid Error:
\nFailed to<\/span> retrieve shared strings file<\/span>
\nD select<\/span> count<\/span>(<\/span>*<\/span>)<\/span> from<\/span> sheetreader(<\/span>'cnyc.xlsx'<\/span>,<\/span>has_header=<\/span>0<\/span>)<\/span>;<\/span>
\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 count_star(<\/span>)<\/span> \u2502
\n\u2502 int64 \u2502
\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524
\n\u2502 1000217<\/span> \u2502
\n\u2502 (<\/span>1.00<\/span> million)<\/span> \u2502
\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 13.244<\/span> user<\/span> 42.060000<\/span> sys 0.184000<\/span><\/p>\n

\u7b80\u5355\u5730\u6570\u65b9\u6846\u5c31\u77e5\u9053rusty_sheet\u63d2\u4ef6\u517c\u5bb9\u6027\u6700\u597d，sheetreader\u5904\u7406shared strings\u683c\u5f0f\u6548\u7387\u6700\u9ad8，\u5b83\u4e5f\u5904\u7406\u4e0d\u4e86\u522b\u7684\u683c\u5f0f\u3002\u5e76\u884c\u5ea6\u5927\u7ea6\u662f4\u3002
\nDuckDB\u5b98\u65b9excel\u63d2\u4ef6\u5728\u5168\u5b57\u7b26\u9009\u9879\u4e0b\u517c\u5bb9\u4e24\u79cd\u683c\u5f0f，\u5947\u602a\u7684\u662f\u5e26\u6807\u9898\u5224\u65ad，\u5b83\u8fde\u81ea\u5df1\u751f\u6210\u7684\u6587\u4ef6\u683c\u5f0f\u90fd\u5224\u65ad\u9519\u8bef\u3002<\/p>\n

\u5bf9\u4e8e\u8bc6\u522b\u7684\u7ed3\u679c，\u6211\u4eec\u7528summarize\u547d\u4ee4\u6765\u67e5\u770b.
\n\u4f5c\u4e3a\u57fa\u51c6\u7684duckdb\u8bc6\u522b\u539f\u59cbcsv\u6587\u4ef6<\/p>\n

D create<\/span> table<\/span> t as<\/span> from<\/span> read_csv(<\/span>'NYC_311_SR_2010-2020-sample-1M.csv.mp3'<\/span>)<\/span>;<\/span>
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 11.214<\/span> user<\/span> 19.248000<\/span> sys 1.760000<\/span>
\nD summarize t;<\/span>
\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 column_name \u2502 column_type \u2502 min \u2502 max \u2502 approx_unique \u2502 \u2026 \u2502 q50 \u2502 q75 \u2502 count \u2502 null_percentage \u2502
\n\u2502 varchar<\/span> \u2502 varchar<\/span> \u2502 varchar<\/span> \u2502 varchar<\/span> \u2502 int64 \u2502 \u2502 varchar<\/span> \u2502 varchar<\/span> \u2502 int64 \u2502 decimal<\/span>(<\/span>9<\/span>,<\/span>2<\/span>)<\/span> \u2502
\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524
\n\u2502 Unique<\/span> Key<\/span> \u2502 BIGINT<\/span> \u2502 11465364<\/span> \u2502 48478173<\/span> \u2502 1022792<\/span> \u2502 \u2026 \u2502 32855651<\/span> \u2502 40201435<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Created Date<\/span> \u2502 TIMESTAMP<\/span> \u2502 2010<\/span>–<\/span>01<\/span>–<\/span>01<\/span> 00<\/span>:00<\/span>:00<\/span> \u2502 2020<\/span>–<\/span>12<\/span>–<\/span>23<\/span> 01<\/span>:25<\/span>:51<\/span> \u2502 717832<\/span> \u2502 \u2026 \u2502 2016<\/span>–<\/span>02<\/span>–<\/span>11<\/span> 14<\/span>:40<\/span>:2<\/span>\u2026 \u2502 2018<\/span>–<\/span>07<\/span>–<\/span>31<\/span> 08<\/span>:55<\/span>:5<\/span>\u2026 \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Closed Date<\/span> \u2502 TIMESTAMP<\/span> \u2502 1900<\/span>–<\/span>01<\/span>–<\/span>01<\/span> 00<\/span>:00<\/span>:00<\/span> \u2502 2100<\/span>–<\/span>01<\/span>–<\/span>01<\/span> 00<\/span>:00<\/span>:00<\/span> \u2502 619261<\/span> \u2502 \u2026 \u2502 2016<\/span>–<\/span>02<\/span>–<\/span>26<\/span> 00<\/span>:08<\/span>:4<\/span>\u2026 \u2502 2018<\/span>–<\/span>08<\/span>–<\/span>02<\/span> 13<\/span>:09<\/span>:5<\/span>\u2026 \u2502 1000000<\/span> \u2502 2.86<\/span> \u2502
\n\u2502 Agency \u2502 VARCHAR<\/span> \u2502 3<\/span>–<\/span>1<\/span>–<\/span>1<\/span> \u2502 TLC \u2502 29<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Agency Name \u2502 VARCHAR<\/span> \u2502 3<\/span>–<\/span>1<\/span>–<\/span>1<\/span> \u2502 Valuation Policy \u2502 686<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Complaint Type<\/span> \u2502 VARCHAR<\/span> \u2502 .<\/span>.<\/span>\/<\/span>.<\/span>.<\/span>\/<\/span>WEB–<\/span>INF\/<\/span>web.<\/span>\u2026 \u2502 ZTESTINT \u2502 281<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Descriptor \u2502 VARCHAR<\/span> \u2502 1<\/span> Missed Collection \u2502 unknown odor\/<\/span>taste\u2026 \u2502 1553<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.30<\/span> \u2502
\n.<\/span>.<\/span>.<\/span><\/p>\n

\u7136\u540e\u7528\u4e0d\u540c\u63d2\u4ef6\u8bfb\u53d6\u5927\u5bb6\u90fd\u8bc6\u522b\u6b63\u786e\u7684pynyc.xlsx\u3002
\nduckdb\u5b98\u65b9excel\u63d2\u4ef6\u5168\u8bc6\u522b\u4e3avarchar<\/p>\n

D create<\/span> table<\/span> t as<\/span> from<\/span> read_xlsx(<\/span>'pynyc.xlsx'<\/span>,<\/span>header=<\/span>0<\/span>)<\/span>;<\/span>
\nD summarize t;<\/span>
\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 column_name \u2502 column_type \u2502 min \u2502 max \u2502 approx_unique \u2502 avg \u2502 std \u2502 q25 \u2502 q50 \u2502 q75 \u2502 count \u2502 null_percentage \u2502
\n\u2502 varchar<\/span> \u2502 varchar<\/span> \u2502 varchar<\/span> \u2502 varchar<\/span> \u2502 int64 \u2502 int32 \u2502 int32 \u2502 int32 \u2502 int32 \u2502 int32 \u2502 int64 \u2502 decimal<\/span>(<\/span>9<\/span>,<\/span>2<\/span>)<\/span> \u2502
\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524
\n\u2502 A1 \u2502 VARCHAR<\/span> \u2502 11465364<\/span> \u2502 Unique<\/span> Key<\/span> \u2502 857267<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000001<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 B1 \u2502 VARCHAR<\/span> \u2502 01<\/span>\/<\/span>01<\/span>\/<\/span>2010<\/span> 01<\/span>:05<\/span>:5<\/span>\u2026 \u2502 Created Date<\/span> \u2502 920156<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000001<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 C1 \u2502 VARCHAR<\/span> \u2502 \u2502 Closed Date<\/span> \u2502 667996<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000001<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 D1 \u2502 VARCHAR<\/span> \u2502 3<\/span>–<\/span>1<\/span>–<\/span>1<\/span> \u2502 TLC \u2502 29<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000001<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 E1 \u2502 VARCHAR<\/span> \u2502 3<\/span>–<\/span>1<\/span>–<\/span>1<\/span> \u2502 Valuation Policy \u2502 686<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000001<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 F1 \u2502 VARCHAR<\/span> \u2502 .<\/span>.<\/span>\/<\/span>.<\/span>.<\/span>\/<\/span>WEB–<\/span>INF\/<\/span>web.<\/span>\u2026 \u2502 ZTESTINT \u2502 281<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000001<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 G1 \u2502 VARCHAR<\/span> \u2502 \u2502 unknown odor\/<\/span>taste in<\/span> drinking water (<\/span>QA6)<\/span> \u2502 1553<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000001<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 H1 \u2502 VARCHAR<\/span> \u2502 \u2502 Wooded Area \u2502 149<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000001<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 I1 \u2502 VARCHAR<\/span> \u2502 \u2502 XXXXX \u2502 560<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000001<\/span> \u2502 0.00<\/span> \u2502
\n.<\/span>.<\/span>.<\/span><\/p>\n

sheetreader\u53ea\u6709double\u548cvarchar\u4e24\u79cd\u683c\u5f0f<\/p>\n

D create<\/span> table<\/span> t as<\/span> from<\/span> sheetreader(<\/span>'pynyc.xlsx'<\/span>)<\/span>;<\/span>
\nRun Time<\/span> (<\/span>s)<\/span>: real<\/span> 22.319<\/span> user<\/span> 62.448000<\/span> sys 2.436000<\/span>
\nD summarize t;<\/span>
\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 column_name \u2502 column_type \u2502 min \u2502 max \u2502 approx_unique \u2502 \u2026 \u2502 q50 \u2502 q75 \u2502 count \u2502 null_percentage \u2502
\n\u2502 varchar<\/span> \u2502 varchar<\/span> \u2502 varchar<\/span> \u2502 varchar<\/span> \u2502 int64 \u2502 \u2502 varchar<\/span> \u2502 varchar<\/span> \u2502 int64 \u2502 decimal<\/span>(<\/span>9<\/span>,<\/span>2<\/span>)<\/span> \u2502
\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524
\n\u2502 Unique<\/span> Key<\/span> \u2502 DOUBLE<\/span> \u2502 11465364.0<\/span> \u2502 48478173.0<\/span> \u2502 972278<\/span> \u2502 \u2026 \u2502 32847889.45051274<\/span> \u2502 40204486.57822673<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Created Date<\/span> \u2502 VARCHAR<\/span> \u2502 01<\/span>\/<\/span>01<\/span>\/<\/span>2010<\/span> 01<\/span>:05<\/span>:5<\/span>\u2026 \u2502 12<\/span>\/<\/span>31<\/span>\/<\/span>2019<\/span> 12<\/span>:58<\/span>:5<\/span>\u2026 \u2502 815306<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Closed Date<\/span> \u2502 VARCHAR<\/span> \u2502 \u2502 12<\/span>\/<\/span>31<\/span>\/<\/span>2019<\/span> 12<\/span>:59<\/span>:0<\/span>\u2026 \u2502 736431<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Agency \u2502 VARCHAR<\/span> \u2502 3<\/span>–<\/span>1<\/span>–<\/span>1<\/span> \u2502 TLC \u2502 27<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Agency Name \u2502 VARCHAR<\/span> \u2502 3<\/span>–<\/span>1<\/span>–<\/span>1<\/span> \u2502 Valuation Policy \u2502 476<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Complaint Type<\/span> \u2502 VARCHAR<\/span> \u2502 .<\/span>.<\/span>\/<\/span>.<\/span>.<\/span>\/<\/span>WEB–<\/span>INF\/<\/span>web.<\/span>\u2026 \u2502 ZTESTINT \u2502 247<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Descriptor \u2502 VARCHAR<\/span> \u2502 \u2502 unknown odor\/<\/span>taste\u2026 \u2502 1296<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Location Type<\/span> \u2502 VARCHAR<\/span> \u2502 \u2502 Wooded Area \u2502 147<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Incident Zip \u2502 DOUBLE<\/span> \u2502 0.0<\/span> \u2502 900836.0<\/span> \u2502 438<\/span> \u2502 \u2026 \u2502 11204.51877831457<\/span> \u2502 11234.278294563806<\/span> \u2502 1000000<\/span> \u2502 5.51<\/span> \u2502
\n.<\/span>.<\/span>.<\/span><\/p>\n

rusty_sheet\u57fa\u672c\u8fd8\u539f\u4e86\u6574\u6570\u7c7b\u578b，\u4f46\u65e5\u671f\u578b\u8bc6\u522b\u4e3a\u5b57\u7b26\u4e32\u3002<\/p>\n

D load<\/span> rusty_sheet;<\/span>
\nD create<\/span> table<\/span> t2 as<\/span> from<\/span> read_sheet(<\/span>'pynyc.xlsx'<\/span>,<\/span>header=<\/span>1<\/span>)<\/span>;<\/span>
\nD summarize t2;<\/span>
\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510
\n\u2502 column_name \u2502 column_type \u2502 min \u2502 max \u2502 approx_unique \u2502 avg \u2502 \u2026 \u2502 q25 \u2502 q50 \u2502 q75 \u2502 count \u2502 null_percentage \u2502
\n\u2502 varchar<\/span> \u2502 varchar<\/span> \u2502 varchar<\/span> \u2502 varchar<\/span> \u2502 int64 \u2502 varchar<\/span> \u2502 \u2502 varchar<\/span> \u2502 varchar<\/span> \u2502 varchar<\/span> \u2502 int64 \u2502 decimal<\/span>(<\/span>9<\/span>,<\/span>2<\/span>)<\/span> \u2502
\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524
\n\u2502 Unique<\/span> Key<\/span> \u2502 BIGINT<\/span> \u2502 11465364<\/span> \u2502 48478173<\/span> \u2502 1022792<\/span> \u2502 32687965.858032<\/span> \u2502 \u2026 \u2502 25252380<\/span> \u2502 32849287<\/span> \u2502 40204842<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Created Date<\/span> \u2502 VARCHAR<\/span> \u2502 01<\/span>\/<\/span>01<\/span>\/<\/span>2010<\/span> 01<\/span>:05<\/span>:5<\/span>\u2026 \u2502 12<\/span>\/<\/span>31<\/span>\/<\/span>2019<\/span> 12<\/span>:58<\/span>:5<\/span>\u2026 \u2502 920156<\/span> \u2502 NULL<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Closed Date<\/span> \u2502 VARCHAR<\/span> \u2502 \u2502 12<\/span>\/<\/span>31<\/span>\/<\/span>2019<\/span> 12<\/span>:59<\/span>:0<\/span>\u2026 \u2502 667996<\/span> \u2502 NULL<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Agency \u2502 VARCHAR<\/span> \u2502 3<\/span>–<\/span>1<\/span>–<\/span>1<\/span> \u2502 TLC \u2502 29<\/span> \u2502 NULL<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Agency Name \u2502 VARCHAR<\/span> \u2502 3<\/span>–<\/span>1<\/span>–<\/span>1<\/span> \u2502 Valuation Policy \u2502 686<\/span> \u2502 NULL<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Complaint Type<\/span> \u2502 VARCHAR<\/span> \u2502 .<\/span>.<\/span>\/<\/span>.<\/span>.<\/span>\/<\/span>WEB–<\/span>INF\/<\/span>web.<\/span>\u2026 \u2502 ZTESTINT \u2502 281<\/span> \u2502 NULL<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Descriptor \u2502 VARCHAR<\/span> \u2502 \u2502 unknown odor\/<\/span>taste\u2026 \u2502 1553<\/span> \u2502 NULL<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Location Type<\/span> \u2502 VARCHAR<\/span> \u2502 \u2502 Wooded Area \u2502 149<\/span> \u2502 NULL<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n\u2502 Incident Zip \u2502 BIGINT<\/span> \u2502 0<\/span> \u2502 900836<\/span> \u2502 548<\/span> \u2502 10825.273804119031<\/span> \u2502 \u2026 \u2502 10337<\/span> \u2502 11204<\/span> \u2502 11234<\/span> \u2502 1000000<\/span> \u2502 5.51<\/span> \u2502
\n\u2502 Incident Address \u2502 VARCHAR<\/span> \u2502 \u2502 west 155<\/span> street an\u2026 \u2502 333521<\/span> \u2502 NULL<\/span> \u2502 \u2026 \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 NULL<\/span> \u2502 1000000<\/span> \u2502 0.00<\/span> \u2502
\n.<\/span>.<\/span>.<\/span><\/p>\n

\u4ee5\u4e0a\u4ec5\u662f\u5bf9\u4e00\u4e2a\u6587\u4ef6\u7684\u6d4b\u8bd5，\u4e0d\u4ee3\u8868\u5176\u4ed6\u6587\u4ef6\u7684\u60c5\u51b5\u3002\u5404\u79cd\u63d2\u4ef6\u90fd\u6709\u6307\u5b9a\u5217\u7c7b\u578b\u7684\u529f\u80fd，\u52a0\u4e0a\u540e\u5e94\u8be5\u80fd\u53d6\u5f97\u66f4\u597d\u7684\u6548\u679c\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb37\u6b21\u3002\u5b9e\u9a8c\u6bd4\u8f83\u4e86\u4e0d\u540c\u65b9\u5f0f\u751f\u6210\u7684xlsx\u6587\u4ef6\u5bf9\u8bfb\u53d6\u6027\u80fd\u7684\u5f71\u54cd\u3002SharedString\u901a\u8fc7\u5171\u4eab\u91cd\u590d\u5b57\u7b26\u4e32\u51cf\u5c11\u4e86\u6587\u4ef6\u5927\u5c0f\uff0c\u4f46\u4e0d\u540c\u5b9e\u73b0\u65b9\u5f0f\u5bf9\u6027\u80fd\u5f71\u54cd\u663e\u8457\u3002\u5e26SharedString\u7684\u6587\u4ef6\u8bfb\u53d6\u8f83\u6162\u3002\u81ea\u52a8\u8bc6\u522b\u7c7b\u578b\u8ddd\u79bbcsv\u683c\u5f0f\u5c1a\u6709\u5dee\u8ddd\uff0c\u9700\u8981\u4eba\u5de5\u6307\u5b9a\u3002<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[55,6024,206,2545,1002,100,427,6023],"topic":[],"class_list":["post-57570","post","type-post","status-publish","format-standard","hentry","category-server","tag-c","tag-duckdb","tag-rust","tag-xml","tag-1002","tag-100","tag-427","tag-6023"],"yoast_head":"\n\u4e0d\u540cDuckDB\u63d2\u4ef6\u5bf9\u4e0d\u540c\u5de5\u5177\u751f\u6210\u7684xlsx\u6587\u4ef6\u8bfb\u53d6\u901f\u5ea6\u7684\u6bd4\u8f83 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/57570.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4e0d\u540cDuckDB\u63d2\u4ef6\u5bf9\u4e0d\u540c\u5de5\u5177\u751f\u6210\u7684xlsx\u6587\u4ef6\u8bfb\u53d6\u901f\u5ea6\u7684\u6bd4\u8f83 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb37\u6b21\u3002\u5b9e\u9a8c\u6bd4\u8f83\u4e86\u4e0d\u540c\u65b9\u5f0f\u751f\u6210\u7684xlsx\u6587\u4ef6\u5bf9\u8bfb\u53d6\u6027\u80fd\u7684\u5f71\u54cd\u3002SharedString\u901a\u8fc7\u5171\u4eab\u91cd\u590d\u5b57\u7b26\u4e32\u51cf\u5c11\u4e86\u6587\u4ef6\u5927\u5c0f\uff0c\u4f46\u4e0d\u540c\u5b9e\u73b0\u65b9\u5f0f\u5bf9\u6027\u80fd\u5f71\u54cd\u663e\u8457\u3002\u5e26SharedString\u7684\u6587\u4ef6\u8bfb\u53d6\u8f83\u6162\u3002\u81ea\u52a8\u8bc6\u522b\u7c7b\u578b\u8ddd\u79bbcsv\u683c\u5f0f\u5c1a\u6709\u5dee\u8ddd\uff0c\u9700\u8981\u4eba\u5de5\u6307\u5b9a\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/57570.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-15T07:40:03+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/57570.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/57570.html\",\"name\":\"\u4e0d\u540cDuckDB\u63d2\u4ef6\u5bf9\u4e0d\u540c\u5de5\u5177\u751f\u6210\u7684xlsx\u6587\u4ef6\u8bfb\u53d6\u901f\u5ea6\u7684\u6bd4\u8f83 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-08-15T07:40:03+00:00\",\"dateModified\":\"2025-08-15T07:40:03+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/57570.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/57570.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/57570.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4e0d\u540cDuckDB\u63d2\u4ef6\u5bf9\u4e0d\u540c\u5de5\u5177\u751f\u6210\u7684xlsx\u6587\u4ef6\u8bfb\u53d6\u901f\u5ea6\u7684\u6bd4\u8f83\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u4e0d\u540cDuckDB\u63d2\u4ef6\u5bf9\u4e0d\u540c\u5de5\u5177\u751f\u6210\u7684xlsx\u6587\u4ef6\u8bfb\u53d6\u901f\u5ea6\u7684\u6bd4\u8f83 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/57570.html","og_locale":"zh_CN","og_type":"article","og_title":"\u4e0d\u540cDuckDB\u63d2\u4ef6\u5bf9\u4e0d\u540c\u5de5\u5177\u751f\u6210\u7684xlsx\u6587\u4ef6\u8bfb\u53d6\u901f\u5ea6\u7684\u6bd4\u8f83 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb37\u6b21\u3002\u5b9e\u9a8c\u6bd4\u8f83\u4e86\u4e0d\u540c\u65b9\u5f0f\u751f\u6210\u7684xlsx\u6587\u4ef6\u5bf9\u8bfb\u53d6\u6027\u80fd\u7684\u5f71\u54cd\u3002SharedString\u901a\u8fc7\u5171\u4eab\u91cd\u590d\u5b57\u7b26\u4e32\u51cf\u5c11\u4e86\u6587\u4ef6\u5927\u5c0f\uff0c\u4f46\u4e0d\u540c\u5b9e\u73b0\u65b9\u5f0f\u5bf9\u6027\u80fd\u5f71\u54cd\u663e\u8457\u3002\u5e26SharedString\u7684\u6587\u4ef6\u8bfb\u53d6\u8f83\u6162\u3002\u81ea\u52a8\u8bc6\u522b\u7c7b\u578b\u8ddd\u79bbcsv\u683c\u5f0f\u5c1a\u6709\u5dee\u8ddd\uff0c\u9700\u8981\u4eba\u5de5\u6307\u5b9a\u3002","og_url":"https:\/\/www.wsisp.com\/helps\/57570.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-08-15T07:40:03+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"8 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/57570.html","url":"https:\/\/www.wsisp.com\/helps\/57570.html","name":"\u4e0d\u540cDuckDB\u63d2\u4ef6\u5bf9\u4e0d\u540c\u5de5\u5177\u751f\u6210\u7684xlsx\u6587\u4ef6\u8bfb\u53d6\u901f\u5ea6\u7684\u6bd4\u8f83 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-08-15T07:40:03+00:00","dateModified":"2025-08-15T07:40:03+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/57570.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/57570.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/57570.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u4e0d\u540cDuckDB\u63d2\u4ef6\u5bf9\u4e0d\u540c\u5de5\u5177\u751f\u6210\u7684xlsx\u6587\u4ef6\u8bfb\u53d6\u901f\u5ea6\u7684\u6bd4\u8f83"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/57570","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=57570"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/57570\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=57570"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=57570"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=57570"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=57570"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}