Is there any huge excel or high loaded application involved in the process?
Usually fi the excel which works with more number of rows can cause this error.
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.