Python xlsxwriter extract value from cell

Question

I just want to know whether is it possible to extract the data which I have written at xlsxwritter.worksheet

import xlsxwriter

output = "test.xlsx"

workbook = xlsxwriter.Workbook(output)

worksheet = workbook.add_worksheet()

worksheet.write(0, 0, 'top left')

if conditional:

    worksheet.write(1, 1, 'bottom right')

for row in range(2):

  for col in range(2):

    # Now how can I check if a value was written at this coordinate?

    # something like worksheet.get_value_at_row_col(row, col)

workbook.close()

Answer 1

No, we can't extract the data because XlsxWriter is write only. In the event that you need to monitor your information you should do it in your own code, outside of XlsxWriter.

Wanna become a python expert? Come and join the python certification course fast!