自学教程：Python中Cookies导出某站用户数据的方法

cookies = {        'JSESSIONID': 'XXX',    'phone': 'XXX',        'password': 'XXX',        'isAuto': '0',    '    loginAccess': 'XXX'}

headers = {    'Connection': 'keep-alive',    'sec-ch-ua': '"Google Chrome";v="89", "Chromium";v="89", ";Not A Brand";v="99"',   'Accept': 'application/json, text/javascript, */*; q=0.01',    'X-Requested-With': 'XMLHttpRequest',    'sec-ch-ua-mobile': '?0',    'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36',    'Content-Type': 'application/json',   'Sec-Fetch-Site': 'same-origin',    'Sec-Fetch-Mode': 'cors',    'Sec-Fetch-Dest': 'empty',    'Referer': 'https://xxx.xxx.xxx',    'Accept-Language': 'zh-CN,zh;q=0.9',}

params = ( ('method', 'getGoodsList'))

data = '{"pageSize":1000,"pageNumber":1,"searchText":"","sortOrder":"asc","isAdvancedSearch":false}'

response = requests.post(   'https://xxx.xxx.xxx',     headers=headers,    params=params,     cookies=cookies,    data=data)print(response.text.encode('utf8'))res = json.loads(response.text)

t = time.time()randStr = int(round(t * 1000))tSheetName = "a_" + str(randStr) + ".xlsx"workbook = xlsxwriter.Workbook(tSheetName)worksheet = workbook.add_worksheet()

cursor = 0picurl = ''writeExcel(row=cursor)for obj in res["rows"]:        cursor += 1        picurl = ''       if obj['ImageKID']:                picurl = 'https://xxx.xxx.xxx? imageKid='+obj['ImageKID']        writeExcel(row=cursor,Description=obj['Description'], Category=obj['Category'], 		 		  Series=obj['Series'],BaseUnit=obj['BaseUnit'],Qty=obj['Qty'],    CostPrice=obj['CostPrice'],SalePrice=obj['SalePrice'],                       RetailPrice=obj['RetailPrice'],Barcode=obj['Barcode'],   Remark=obj['Remark'], ImageKID=picurl)

def writeExcel(row=0, Description='', Category='', Series='', BaseUnit='', Qty='', CostPrice='', SalePrice='', RetailPrice='', Barcode='', Remark='',ImageKID=''):   	if row == 0:        		worksheet.write(row, 0, '名称')        		worksheet.write(row, 1, '货号')        		worksheet.write(row, 2, '规格')        		worksheet.write(row, 3, '单位')        		worksheet.write(row, 4, '库存')        		worksheet.write(row, 5, '成本')        		worksheet.write(row, 6, '批发价')        		worksheet.write(row, 7, '零售价')       		worksheet.write(row, 8, '条码')        		worksheet.write(row, 9, '备注')        		worksheet.write(row, 10, '图片')        	else:           		 if ImageKID!='':                    		image_data = io.BytesIO(urllib.urlopen(ImageKID).read())                    		worksheet.insert_image(row, 10, ImageKID, {'image_data': image_data})        		worksheet.write(row, 0, Description)        		worksheet.write(row, 1, Category)        		worksheet.write(row, 2, Series)       		worksheet.write(row, 3, BaseUnit)        		worksheet.write(row, 4, Qty)        		worksheet.write(row, 5, CostPrice)       		worksheet.write(row, 6, SalePrice)       		worksheet.write(row, 7, RetailPrice)       		worksheet.write(row, 8, Barcode)        		worksheet.write(row, 9, Remark)        		worksheet.set_column(10, 10, 23)        		worksheet.set_row(row, 150)        

    def write(self, row, col, *args):        """        Write data to a worksheet cell by calling the appropriate write_*()        method based on the type of data being passed.        Args:            row:   The cell row (zero indexed).            col:   The cell column (zero indexed).            *args: Args to pass to sub functions.        Returns:             0:    Success.            -1:    Row or column is out of worksheet bounds.            other: Return value of called method.        """        return self._write(row, col, *args)

    def set_row(self, row, height=None, cell_format=None, options=None):        """        Set the width, and other properties of a row.        Args:            row:         Row number (zero-indexed).            height:      Row height. (optional).            cell_format: Row cell_format. (optional).            options:     Dict of options such as hidden, level and collapsed.        Returns:            0:  Success.            -1: Row number is out of worksheet bounds.		......        """

    def set_column(self, first_col, last_col, width=None, cell_format=None,                   options=None):        """        Set the width, and other properties of a single column or a        range of columns.        Args:            first_col:   First column (zero-indexed).            last_col:    Last column (zero-indexed). Can be same as first_col.            width:       Column width. (optional).            cell_format: Column cell_format. (optional).            options:     Dict of options such as hidden and level.        Returns:            0:  Success.            -1: Column number is out of worksheet bounds.      ......        """

    def insert_image(self, row, col, filename, options=None):        """        Insert an image with its top-left corner in a worksheet cell.        Args:            row:      The cell row (zero indexed).            col:      The cell column (zero indexed).            filename: Path and filename for image in PNG, JPG or BMP format.            options:  Position, scale, url and data stream of the image.        Returns:            0:  Success.            -1: Row or column is out of worksheet bounds.        """        # Check insert (row, col) without storing.        if self._check_dimensions(row, col, True, True):            warn('Cannot insert image at (%d, %d).' % (row, col))            return -1        if options is None:            options = {}        x_offset = options.get('x_offset', 0)        y_offset = options.get('y_offset', 0)        x_scale = options.get('x_scale', 1)        y_scale = options.get('y_scale', 1)        url = options.get('url', None)        tip = options.get('tip', None)        anchor = options.get('object_position', 2)        image_data = options.get('image_data', None)        description = options.get('description', None)        decorative = options.get('decorative', False)        # For backward compatibility with older parameter name.        anchor = options.get('positioning', anchor)        if not image_data and not os.path.exists(filename):            warn("Image file '%s' not found." % force_unicode(filename))            return -1        self.images.append([row, col, filename, x_offset, y_offset,                            x_scale, y_scale, url, tip, anchor, image_data,                            description, decorative])        return 0

workbook.close()

# -*- coding: UTF-8 -*-# 批量获取XX数据import ioimport json import requestsimport sysimport xlsxwriterimport timeimport urllib