Hello Everyone, I’ve read several threads on this topic for the past 2 days and the answers did not help me get rid of this error.
In my case, I am extracting information from a document, saving the extracted information into a data table (9 columns) and writing the results of the single row data table in an Excel report. I write into the next available Excel row every time I extract all the elements of the document. In other words, for every document that I extract data, I write a row. I am not handling a lof data (data table of 9 columns and one row); this error happens when I write the first or second row into the Excel report.
One of my columns requires a value of type System.DateTime. Whenever I cannot extract the data from the document, I write a random values for all columns, including a date value into the date column. During this test that I am getting the error, I wrote a value of “1111-11-11” as the random date.
I get this error whenever I use that date “1111-11-11”. If I use another date such as “Now” or “Today” or “1900-01-01” I don’t get the error.
I hope this helps some of you who have encountered this error.