Xlsxwriter

import vk_requests
import time
import xlsxwriter
import datetime
import codecs
 
api = vk_requests.create_api(app_id='', 
                             login='', 
                             password='', 
                             phone_number='') 
 
 
Group_id = 1
Topic_id = 2
 
#первое цифровое значение по ссылке - группа, второе - обсуждение
 
a = api.board.getComments(group_id=Group_id, topic_id=Topic_id)
CommentsCount = a['count']
 
print('N = ',CommentsCount)
 
num = 10 # input(':\n')
count = num
 
 
def GetTopicInfo(Offset):
    r = api.board.getComments(group_id=Group_id,
                              topic_id=Topic_id,
                              count=num,
                              offset=Offset)
    return r
 
# Create a workbook and add a worksheet.
 
'''
workbook = xlsxwriter.Workbook('data.xlsx')
 
worksheet = workbook.add_worksheet()
 
worksheet.write('A1', 'Hello world')
 
workbook.close()
 
'''
 
workbook  = xlsxwriter.Workbook('unicode_data.xlsx',{'strings_to_urls': False})
 
worksheet = workbook.add_worksheet()
 
bold = workbook.add_format({'bold': True})
 
 
#Создание колонок
worksheet.write(0, 0, u'Date', bold) 
worksheet.write(0, 1, u'Author', bold)
worksheet.write(0, 2, u'id', bold)
worksheet.write(0, 3, u'Text', bold)
 
Offset = 0
row = 1
col = 0
 
while Offset < CommentsCount:
    r = GetTopicInfo(Offset)
    i = 0
    print(Offset)
    try:
        while i < num:
            Topic_info = r['items'][i]
            Topic_info_from = r['items'][i]['from_id']
            Topic_info_id = r['items'][i]['id']
            Topic_info_text = r['items'][i]['text']
            Topic_info_date =  datetime.datetime.fromtimestamp(
                int(r['items'][i]['date'])
                ).strftime('%Y-%m-%d %H:%M:%S')
 
            worksheet.write(row, col,     Topic_info_date)
            worksheet.write(row, col + 1, Topic_info_from)
            worksheet.write(row, col + 2, Topic_info_id)
            worksheet.write(row, col + 3, Topic_info_text)
            row += 1
            print(i, Topic_info)
            i = i + 1
    except IndexError:
        print(u'Конец')
    Offset = Offset + num
    time.sleep(.35)
 
workbook.close()