Free Support Forum -

Error when generating and excel document

Hi, I am getting the following error:

"Aspose.Excel cannot shift nonblank cell off the worksheet."

Could someone explain what exactly this refers to. How does one go about fixing/avoiding it?

Thanks, Ilia

Hi Ilia,

Do you call InsertRow or InsertColumn method in your program?

In the following case you may meet this error:

You have put some data, say “hello world”, in column IV. And then you call InsertColumn method. The error will occur.

You can also test it in MS Excel:
* Put “hello world” in cell IV1
* Insert column at Colum IU
Then you will get a prompt error.