search

zero88 / robotframework-excel

Robot-framework auto-test excel
Apache License 2.0
20 stars 12 forks source link

Corrupted file after using Write To Cell By Name #2

Closed en237 closed 6 years ago

en237 commented 6 years ago

While trying to open an Excel file modified during the test (with Write To Cell By Name keyword), i receive the following notification from Excel

image

I click on Yes to repair and after below message, the file open

image

Any idea why the file is getting corrupted ?

zero88 commented 6 years ago

Excel writer lib (XlsxWriter) seems having a problem that I have not yet investigated in details. Better to use clone new file from existing file. Check a sample:

https://github.com/zero-88/robotframework-excel/blob/master/tests/acceptance/ExcelRobotTest.robot#L77-L85

Closed it! I will mark it in document.