2 Excel exceptions

Two exceptions occurred during Excel export today:

"Hresult: 0x800a03ec"

There are many causes for this exception. The problem I encountered was that a naming error in the table area resulted in Microsoft. office. interOP. excel. range namerange = oworksheet. get_range (cellname, type. the name cannot be found, and an error occurs. Name of the region corresponding to the Change number

 

"The select method of the range class is invalid"

The cause of this exception is that the range cannot be directly obtained by get_range. select (); first, make sure that the sheet in which the range is located is the current working sheet. Therefore, run sheet first. select () for example:

Microsoft. Office. InterOP. Excel. Range namerange = oworksheet. get_range (cellname, type. Missing );

Oworksheet. Select (type. Missing );

Namerange. Select ();