| | |
|---|
| | | if cat: |
|---|
| | | bump(cat) |
|---|
| | | rows_out.append([sh, "%s%d" % (get_column_letter(i+1), p+1), rl_g[p][:38], cl_g[i][:18], cat, |
|---|
| | | ("" if vg is None else str(vg)[:20]), ("" if vd is None else str(vd)[:20]), note]) |
|---|
| | | ("" if vg is None else str(vg)[:20]), ("" if vd is None else str(vd)[:20]), note, |
|---|
| | | "%s%d" % (get_column_letter(j+1), q+1)]) |
|---|
| | | per_sheet.append((sh, cnt)) |
|---|
| | | # è¾åº CSV |
|---|
| | | csv = prefix + ".csv" |
|---|
| | | with io.open(csv, "w", encoding="utf-8-sig", newline="") as f: |
|---|
| | | f.write("页ç¾,çæ件åå
æ ¼,è¡æ ç¾,å表头,ç±»å«,çæ件å¼,æå·¥å¼,å¤æ³¨\n") |
|---|
| | | f.write("页ç¾,çæ件åå
æ ¼,è¡æ ç¾,å表头,ç±»å«,çæ件å¼,æå·¥å¼,å¤æ³¨,æå·¥åå
æ ¼\n") |
|---|
| | | for x in rows_out: |
|---|
| | | if x[4] not in ACTION: continue |
|---|
| | | f.write(",".join('"%s"' % str(v).replace('"', "'") for v in x) + "\n") |
|---|
