.
...
| Code Block |
|---|
for (int i = 2; i < wb.Worksheets.Count; i++)
{
string sheetName = wb.Worksheets[i].Name.ToString();
ws.Cells[16 + i, 1].Formula = "=HYPERLINK(\"#"+sheetName+"!A1\", \""+sheetName+"\")";
}
|
13. Finally, we want to insert Inserting a picture into the cover sheet. This a worksheet requires creating an Anchor object using the Worksheet.CreateAnchor() method.
...
14. We then want to create a Picture object using Pictures.CreatePicture method where the string describing the name of the image is pulled from the utility method RBImage.SelectedItem.Value.
...