python下载 outlook附件中excel并解析excel

create extension "uuid-ossp"; select * from pg_available_extensions; select current_database(); CREATE TABLE IF NOT EXISTS mes_prod_user.t_transaction_info ( id character varying COLLATE pg_catalog."default" NOT NULL DEFAULT uuid_generate_v4(), lot_name character varying(40) COLLATE pg_catalog."default" NOT NULL, step_number character varying(200) COLLATE pg_catalog."default", product character varying(200) COLLATE pg_catalog."default" NOT NULL, component_qty integer, priority character varying(40) COLLATE pg_catalog."default", activity character varying(200) COLLATE pg_catalog."default", carrier character varying(200) COLLATE pg_catalog."default", process_location character varying(40) COLLATE pg_catalog."default", flow_name character varying(200) COLLATE pg_catalog."default" NOT NULL, lot_type character varying(40) COLLATE pg_catalog."default", owner character varying(200) COLLATE pg_catalog."default", transfer_date timestamp without time zone, created_time timestamp without time zone NOT NULL DEFAULT now(), execute_his_id character varying(200) COLLATE pg_catalog."default", CONSTRAINT info_pkey PRIMARY KEY (id) ); CREATE TABLE IF NOT EXISTS mes_prod_user.t_transaction_history ( id character varying COLLATE pg_catalog."default" NOT NULL DEFAULT uuid_generate_v4(), lot_name character varying(40) COLLATE pg_catalog."default" NOT NULL, activity character varying(200) COLLATE pg_catalog."default", txn_comment character varying(400) COLLATE pg_catalog."default", stage_name character varying(40) COLLATE pg_catalog."default", step_name character varying(40) COLLATE pg_catalog."default", step_number character varying(200) COLLATE pg_catalog."default", action_user character varying(40) COLLATE pg_catalog."default", action_date timestamp without time zone, phy_recipe_name character varying(200) COLLATE pg_catalog."default", eqp_name character varying(400) COLLATE pg_catalog."default", step_desc character varying(400) COLLATE pg_catalog."default", created_time timestamp without time zone NOT NULL DEFAULT now(), info_id character varying(200) COLLATE pg_catalog."default" ); CREATE TABLE IF NOT EXISTS mes_prod_user.t_lot_wip_history ( id character varying(100) COLLATE pg_catalog."default" NOT NULL, lot_name character varying(40) COLLATE pg_catalog."default", activity character varying(40) COLLATE pg_catalog."default" NOT NULL, carrier_name character varying(40) COLLATE pg_catalog."default", step_number character varying(200) COLLATE pg_catalog."default", step_name character varying(40) COLLATE pg_catalog."default", step_desc character varying(1000) COLLATE pg_catalog."default", txn_comment character varying(2000) COLLATE pg_catalog."default", priority character varying(100) COLLATE pg_catalog."default", stage_name character varying(40) COLLATE pg_catalog."default", eqp_name character varying(80) COLLATE pg_catalog."default", recipe_name character varying(160) COLLATE pg_catalog."default", last_updated_time timestamp without time zone NOT NULL, created_by_name character varying(80) COLLATE pg_catalog."default", insert_time timestamp without time zone NOT NULL DEFAULT now(), CONSTRAINT t_lot_wip_history_pkey PRIMARY KEY (id) ); CREATE TABLE IF NOT EXISTS mes_prod_user.t_execute_history ( id character varying COLLATE pg_catalog."default" NOT NULL DEFAULT uuid_generate_v4(), last_execute_date character varying(200) COLLATE pg_catalog."default" NOT NULL, mail_name character varying(400) COLLATE pg_catalog."default" NOT NULL, created_time timestamp without time zone NOT NULL DEFAULT now(), type integer, remark character varying(200) COLLATE pg_catalog."default", CONSTRAINT execute_pkey PRIMARY KEY (id) );