Problem in Print To Excel

chandrurec

Hi all,

When i try to export a report to excel using the excel buffer table, i am getting a error as mentioned below.

"An Exception was raised in the method range. The OLE Control or Automation Server has returned error (HRESULT -2147352567).The Component does not provide the exception description"

Whta may be the reason ? if anybody knows the reason for this error, please reply. This is an urgent issue.

Thanks in advence.

Regards,
chandru.

vijay_g

hi..

check variable ROWNO initialize or not it's cause of error.

Karenh

In my experience, that error is caused by the result set exceeding the maximum number of Excel rows (64 thousand something).

To test that, set a filter on the report to obtain a smaller result set. If you don't get the error, then that is likely the problem.

Cody89

Maybe you forgot to validate the fields "Row No." and "Column No." of the Excel Buffer-Table on inserting new values!???