Add Named Range to Excel using C#

Vote count:

0

I am creating excel sheet which having named range created using code.

 ExcelRange namedRange = sheet1.Cells[2, startColumn + i, regionEndRow, startColumn + i];
 package.Workbook.Names.Add("NamedRange", namedRange);
 namedRange.Dispose();

After save the excel file I am trying to open the file. At that time its give me an error as follows

<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://ift.tt/K9sZsw"><logFileName>error097360_01.xml</logFileName><summary>Errors were detected in file 'D:\ExcelInputSheet\Sheet.xlsm'</summary>-<removedRecords summary="Following is a list of removed records:"><removedRecord>Removed Records: Named range from /xl/workbook.xml part (Workbook)</removedRecord></removedRecords></recoveryLog>

Is there any clue for this issue

asked 44 secs ago

udaya726

309